Print Page | Close Window

Help !!!!

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18093
Printed Date: 20 Apr 2025 at 7:31pm


Topic: Help !!!!
Posted By: maffarr
Subject: Help !!!!
Date Posted: 28 Nov 2012 at 3:14am
Hi All
I am new here and have a problem.
I need to know if and how the following can be done.
If i have a list of contract numbers in excel. I have a current Crystal report that I need to change so that only the contract numbers that do not appear in the excel sheet will display in the crystal report.
Hope that makes sense


Replies:
Posted By: hilfy
Date Posted: 28 Nov 2012 at 3:39am
So, if I understand you correctly, you want to link the Excel sheet to a table in the database and only show the data from the database if there's no corresponding "record" in the Excel sheet.  Is that correct?
 
If so, here's what you'll do.
 
1.  Set up the data for the report using tables or a command in Crystal.
 
2.  Add the Excel file as a data source. The sheet will appear as a Table in the Database Expert.
 
3.  Join FROM the data TO the spreadsheet.  Right-click on the join and modify it to be a Left Outer join.
 
4.  In the Select Expert, edit the formula and include something like the following (using your table and field name from the spreadsheet):
 
IsNull({sheet.ContractNumber})
 
NOTE:  In the spreadsheet, the first row should be the column name, not data.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window