Want to Display that No Data was found

[suzq2]

I have written my report which has a open date & end time that I am prompting the client for. When it finds an incident in that time frame, it displays it on the report along with header information; but, when it doesn't find any data, it doesn't display anything under the titles. I would like the report to display "No Data Found". I have the report doing a count on # of Incidents found and it only displays when there is an incident found. I have written formulas to say if isnull ({@CountIncidents}) then "No Incidents Found" but nothing displays. What am I doing wrong? Thanks. Suzq2

 

[bdreed35]

Try this:

if {@CountIncidents} = 0 then 
    "No Incidents Found" 
else
    ""

You formula may never be null since it is doing a count.

~Brian

 

[Mike Lewis]

Suzq2,

I might be missing something here, but I can't see why your formula is: isnull ({@CountIncidents}) then "No Incidents Found".

Why not simply {@CountIncidents} = 0 then "No Incidents Found"?

Mike




Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[GMcNamara]

You need to consider the weirdo way that Crystal handles null values. Most times, Crystal will simply stop working when it is comparing a null field with a known value. For instance, if your formula was like:
if (TABLE.FIELD = 0) then blah blah

If TABLE.FIELD was null, this formula would simply stop. The then portion of your formula is never executed. If you think about it, that is true, because 0 is not null. It sounds like your count of Incidents is behaving exactly the way it should, given Crystal's handling of Null values.

Can you give a little more info regarding your formulas and the setup of the report?

 

[suzq2]

Thanks for responding. I had already tried the if {@CountIncidents} = 0 then "No Incidents Found" and nothing still displays on the report but the titles. suzq2

 

[Tomorrow]

I use a similar situation on all my reports.
Make a sub section and drop in a text field with "No Data Found".
Then conditionally suppress the section by picking up the one of the main fields that would normally be displayed such as Incident Number or open date - you may need to try a couple.
Code: not isnull(incident-Number)

This shows the section only when there this value is null

Tommorrow

 

[suzq2]

Thanks, Tommorrow, that worked great!!! Suzq2