Crystal Reports Show Headers when No data regurns

Tips and Tricks
Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks

Topic: Show Headers when No data regurns

Author	Message
sanand Newbie Joined: 07 Apr 2010 Online Status: Offline Posts: 3	Topic: Show Headers when No data regurns Posted: 27 May 2010 at 12:10pm
	Hi Experts, I am learning Crystal Reports XI. I am working on a report that sometimes returns no data. I need to show the headers on the report when no data is rerturned. Can this be accomplished? Please help. TIA anand
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 02 Jun 2010 at 3:21am
	depends on what is in the header. I would think that any straight text and parameters would display, but obviously nothing related to data will display.
	IP Logged

sanand Newbie Joined: 07 Apr 2010 Online Status: Offline Posts: 3	Posted: 03 Jun 2010 at 1:13pm
	How about, showing text box with "No Data available for this report.."? I know how to handle this in vb or ms access. Thanks anand
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 20 Jun 2010 at 3:42am
	Hi Insert TextBox in Header with the text "No Data available for this report.."? Right Click the TextBox Select Format Text Click X+2 formula button next to Suppress and enter the code below not isnull(count({Table.FieldName}))* Cheers Rahul
	IP Logged

sanand Newbie Joined: 07 Apr 2010 Online Status: Offline Posts: 3	Posted: 06 Aug 2010 at 7:06am
	That is excellent and worked like a charm. Thanks again
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.015 seconds.