I have a report that runs daily with a month to date search criteria. The first day of the month there are no records to be picked up on the report which makes the process stop. Anyone know of a way to have a zero inserted into the report when there are no records? I am using CR 8, any help would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
No records found
- Thread starter Bharrell
- Start date
scottostanek
Programmer
Just off the top of my head--
Make a Page Header b that is suppressed normally with this condition:
if not (onfirstrecord and isnull({field1})) then Yes else No
//where field1 is any field off the master table.
Put a textfield in page header b with a "0" in it.
And you also have to set a flag on the report unchecked for "suppress if no records returned" (this is CR8.5 but it should be close enough).
Scotto the Unwise
Make a Page Header b that is suppressed normally with this condition:
if not (onfirstrecord and isnull({field1})) then Yes else No
//where field1 is any field off the master table.
Put a textfield in page header b with a "0" in it.
And you also have to set a flag on the report unchecked for "suppress if no records returned" (this is CR8.5 but it should be close enough).
Scotto the Unwise
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question