Print Page | Close Window

"no record" message

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=3677
Printed Date: 18 May 2024 at 11:09am


Topic: "no record" message
Posted By: bulluk
Subject: "no record" message
Date Posted: 11 Jul 2008 at 12:55am
Hi,
 
I'm creating report (CrystalReport X) which is showing stock of different warehouses. Warehouse is a parameter introduced by user and also is grouped by warehouses. As a condition is that only items, which Balance is more than 0, are appearing (so as a Record Selection formula I have Balance>0). As a result, if there is warehouse which all related items have Balance=0, he is not appearing, even not just with no records.
So is it any easy method to project such a group anyway, for example with message "No records/No items for this warehouse."
 
I was looking in the internet for sth like that but I couldn't find. I thought also about using condition RecordNumber=0 but I have no idea where and how to use it.
 
So thank you in advance for any help.
 
Lukas   


Replies:
Posted By: rahulwalawalkar
Date Posted: 13 Jul 2008 at 2:14pm
Hi,
 
Try  
 
IF  isnull(count(table.fieldname))  then
'No Records'


Print Page | Close Window