Print Page | Close Window

Print a detail line even if there is no match

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2430
Printed Date: 29 Apr 2024 at 1:33pm


Topic: Print a detail line even if there is no match
Posted By: cpost
Subject: Print a detail line even if there is no match
Date Posted: 25 Feb 2008 at 1:26pm
I'm new to Crystal XI .. I've used Crystal in the past but one of the very early verisons. My question is how do I still print a detail line even if there is no match found between my linked tables? Presently I have two tables .. one is an MS SQL table and the other is an excel spreadsheet. The first column in the spreadsheet is populated with part numbers and is used as the link to the SQL table to pick up the detail about the part. If the user that is entering the data in the spreadsheet has a typo and no match is found in the SQL table .. Crystal does not print a detail line.. I would like it to print a detail line  anyway with a message saying something like "Item not Found".. has anyone done something similar to this?


Replies:
Posted By: rahulwalawalkar
Date Posted: 26 Feb 2008 at 12:41am
Hi,
 
You can create a formula to check if the field in excel i.e. partnumbers match with partnumber in sql table if they don't match display message "Item Not Found" ,Place the formula in details section....
 
formula
 
IF EXCELPARTNUMBER <> SQLPARTNUMBER then
"Item not Found"
 
Cheers
Rahul
 
 


Print Page | Close Window