Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Blank report Post Reply Post New Topic
Author Message
johnkret
Newbie
Newbie
Avatar

Joined: 14 Nov 2008
Location: United States
Online Status: Offline
Posts: 12
Quote johnkret Replybullet Topic: Blank report
    Posted: 01 Jun 2010 at 5:00am
How do I print a message on a report if there are no lines to print?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 02 Jun 2010 at 3:26am

you might try a formula and have it look at the COUNT() , suppress it if it is > 0 and display it if the count() is 0

It's a thought
 
HTH
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 02 Jun 2010 at 7:10am
What I do is  this:
 
1.  Create a separate section(group header, page header, etc, it depends on the report) and put a text block with "No Data Found" in the section.
2.  Go to the section expert and click on the button next to "Suppress" (do NOT check the suppress check box.)
3.  Choose a particular field that will always be on the report if there is data.  Set the suppression formula for this section to "Not IsNull({table.not_null_field}).  This will suppress this section if there is data on the report.
4.  You can set the supression formula on all of the other sections to "IsNull({table.not_null_field}) to suppress them when there is no data.
 
-Dell


Edited by hilfy - 02 Jun 2010 at 7:11am
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.031 seconds.