Want to display a 'No Data Found' message

[bessebo]

I have a report that runs 4 times a day. It prints any credit returns that have been received for that day that have not been previously reported. I run it at noon, 2PM, and 4PM. If no credit returns have been received from noon until 2PM I still run the report but it returns zero records. I am running this from Crystal Enterprise and email the reports to a list of users. I want to email the report if there is no data with a message on the report saying "No Data Found". I assume I have to have a text field with a condition that says if there are zero records make the text field visible. If there ARE records suppress the field. There is no special field that I can find called Number of Records. Is there one or does anyone out there have another solution?

Regards,
Bessebo

 

[vidru]

There's a special field called recordnumber, but that will return "1" even if there's no data.

If there's a field that is never null in your dataset, you could use the IsNull() function to test for no records.

The suppression formula for your "No Data" text object would look like:
[tt]
not isnull({Table.FieldThatAlwaysHasData})
[/tt]
-dave

 

[GJParker]

Try using the RecordNumber function

Gary Parker
Systems Support Analyst
Manchester, England

 

[dmurray00]

Within the report designer, conditionally format the cell of section to show the "No Data Found" cell object if the counter or fileds =0 .

Try that ...

 

[rnd]

You can use one of the functions in your suppression formula:
Count function on a field that will show if there is any record (like count of Transaction Number at Grand total level) OR
Sum of Credit Returns = $0 (be careful. It depends on your business. Positive and negative returns could accidentally end up a total = 0)
Record Number is not a good choice. It is destined to fail for this purpose.
Be sure it is a nullable field when you use IsNull condition.