Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print "No records for the current month." for Blank Report

Status
Not open for further replies.
Sep 11, 2008
25
US
I am using Crystal 11.

I want to print "No records for the current month." if a report for a month has no records that match criteria.

What I tried (below) is not working:
Formula 1 (@RecordCount)
If Count({HPD_Help_Desk.Incident Number})= 0
Then
{@NoRecordsText}

Formula 2 (@NoRecordsText)
"No records for the current month."

How can I get the text, "No records for the current month." to print in the body of a blank report?

Thank you so much,

OldGrayMare
 
Go to file->report options and make sure that "suppress printing if no records" is NOT checked. Also make sure that you do not have "convert nulls to default values" checked. Then use a formula like this in the report header:

if isnull({HPD_Help_Desk.Incident Number}) Then
"No records for the current month."

-LB
 
In my continuing search for the answer to my problem, I got it solved, so please disregard my request unless you have a better or easier method than this:

I created another Page Header section and conditionally suppressed it this way:

IsNull ({HPD_Help_Desk.Incident Number}) = False
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top