I have a report that sometimes may generate records, and other times return nothing. The default page that shows up isn't the greatest, so I decided to create an HTML page if there aren't any records. Here's my current code:
TABLE FILE sp_soft_hard_fail_list
PRINT SOURCE_SYSTEM AS 'Source System'
FULL_TABLE AS ''
-IF &RECORDS EQ 0 THEN GOTO ERROR
The only problem is, even when I'm recieving records from the table the paragraph still appears at the very end of the report. I have tried to check &LINES as well, but that doesn't do anything eitherThis message has been edited. Last edited by: ccollier,
WebFOCUS 8.2.01M on Windows 10
June 13, 2019, 11:37 AM
Change your IF &RECORDS GOTO to skip the ERROR.
-IF &RECORDS NE 0 THEN GOTO SKIP
WebFOCUS 8206, Unix, Windows
June 13, 2019, 11:48 AM
That was extremely easy. Thanks, I guess I'm just not with it today