Record Count Question

[jhein]

I have a report where I need to display a zero if the datasource does not return any records. Is there someway to perform a record count...and if it is equal to zero then I can display a zero on the report?

 

[WindUp]

>Is there someway to perform a record count...and if it is equal to zero then I can display a zero on the report?

Insert a Text Object in it's own Data Section, put a "0" in that Object ("In my case I've been putting "No Records Found" in there, in big red letters.)

Open the Section Expert and set the Suppress = "

Count ({TableName.AnyValidFieldName}) >= 0

"
Good Luck!
WindUp

 

[synapsevampire]

Might want to check for isnull as well:

http://support.crystaldecisions.com/library/kbase/articles/c2005590.asp

-k

 

[jhein]

Thanks WindUp!!!

 

[jhein]

Thanks everyone. Right after I posted this thread, the answer came to me. I can't believe I didn't think of it sooner!