Print Page | Close Window

not display the record number

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=1164
Printed Date: 05 Apr 2025 at 5:16pm


Topic: not display the record number
Posted By: ansa
Subject: not display the record number
Date Posted: 13 Aug 2007 at 2:30am
My report is empty, but the record number displays (=1). I want that it disappear and displays when count of record > 0 only. Please, help me.



Replies:
Posted By: jkwrpc
Date Posted: 14 Aug 2007 at 7:19am

If the record number is a report field you can conditionally suppress (hide) the field.  Right click on the field, go to Format Field, then the Common tab, Check Suppress then click on the Formula(X-2) button to the right. When the window opens enter

Count({datafield}) = 0;
 
This should suppress (hide) the field whenever there are not any records. Otherwise it will show. You of course will need to change the {datafield} to an appropriate field name.
 
Hope this helps.
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net


Posted By: ansa
Date Posted: 14 Aug 2007 at 8:16am
Oh, thanks. It's work!!!



Print Page | Close Window