Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Show Headers when No data regurns Post Reply Post New Topic
Author Message
sanand
Newbie
Newbie


Joined: 07 Apr 2010
Online Status: Offline
Posts: 3
Quote sanand Replybullet 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 IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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 IP Logged
sanand
Newbie
Newbie


Joined: 07 Apr 2010
Online Status: Offline
Posts: 3
Quote sanand Replybullet 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 IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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 IP Logged
sanand
Newbie
Newbie


Joined: 07 Apr 2010
Online Status: Offline
Posts: 3
Quote sanand Replybullet Posted: 06 Aug 2010 at 7:06am

That is excellent and worked like a charm.

 
Thanks again
IP 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.016 seconds.