Focal Point
Generating Empty Reports in RCaster717

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2751073352

October 23, 2007, 11:04 AM
ktnj
Generating Empty Reports in RCaster717
Hello all,

This there a way to generate a "Today's report is empty" message to email to everyone on an Rcaster distribution list for whom a report was not created?

Thanks to all,
Ken

Z/OS
Focus 725
WebFocus 717


October 23, 2007, 11:19 AM
Prarie
If you will do a search on this forum...you will find several discussions on this topic.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
After the TABLE FILE ... END producing the report, use D/M to test the number of records put into the preceding report (&RECORDS). If there are records, EXIT the FocExec. If there are no records, do either of two things:
1) Use D/M HTMLFORM command to include a pre-prepared web-page that displays on the 'empty report' condition (-HTMLFORM norecs).
2) Query a file that always exists and print a report that is nothing but a heading which explains the no-report condition:
TABLE FILE CAR
DEFINE FILE CAR
BLANK/A1 = ' ';
END
PRINT BLANK
HEADING
"No report to print"
WHERE READLIMIT LE 1
END


WIN/2K running WF 7.6.4
Development via DevStudio 7.6.4, MRE, TextEditor.
Data is Oracle, MS-SQL.
Thank you.
I think I'll use option 2.
Problem solved.


first request......... and then
-IF &RECORDS EQ 0 GOTO SPCL ELSE GOTO XIT;
-SPCL
DEFINE FILE CAR
BLNK/A1 WITH COUNTRY = ' ';
END
TABLE FILE CAR
PRINT BLNK AS 'THIS REPORT IS BLANK BECAUSE NO RECORDS WERE FOUND'
WHERE RECORDLIMIT EQ 1
ON TABLE SET EMPTYREPORT ON
END

ira aix 533 WF 5.3.6