Display not found message in crystal

[jrs11]

Hi..I have a small problem that I assume can be easily fised. I have a vb front end which passes parms to crystal and retrieves data. However...if data not found the crystal report shows up blank, which is correct, but my users want to have a message printed out. I know I can change the vb front end to do this, but this would require a new install of the front end and it is easier to ask them to overlay the report versus the front end. Is there a simple way to do this via crystal? Thanks appreciate it!

 

[rogar]

Put the message in a report header section and conditionally suppress that section on "Not IsNull({datafield}). You could also conditionally suppress the normal Page Header and Footer on "IsNull({datafield}) so that only the "No Records" header is displayed. Be sure the data field you test on does not contain nulls.

 

[jrs11]

I can get the not found message to conditionally suppress when not isnull, but I cannot get it to print out when isnull condition is met. I just get a blank report...no sections show up at all. What am I missing?

 

[Roadkill150]

Hello,
The issue isn't nulls in this case from what it sounds, but rather that you have no records returning at all (ie: blank report). What you need to do is place a record counter in the report, then conditionally suppress your section based on the counter. ie: {@counter}>0
Cheers,
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com