Displaying no records in if a criteria is not met o record not found. 1

[tydee]

i am trying to display records based on acriteria which i specify from a web page.the report is published only when the criteria is fully met now i also want to display amsg if the criteria is not met.

 

[Madawc]

Do a running total based on the criteria. Have a section in the report footer that is suppressed unless the count is greater than zero. But test first for the running total being null, e.g.

Isnull({your.count}) or {your.count} = 0

To conditionally suppress a section, right-click on the section and choose Section Expert. Choose the formula icon (x+2 and a pencil) for suppression. Enter a formula like the one given above.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP