Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Handling a report with no records
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Handling a report with no records
 Login/Join
 
Gold member
posted
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 ''
END

-IF &RECORDS EQ 0 THEN GOTO ERROR

-ERROR
-HTMLFORM BEGIN
<html>
<body>
<p>Test</p>
</body>

</html>

-HTMLFORM END 


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 either

This message has been edited. Last edited by: ccollier,


WebFOCUS 8.2.01M on Windows 10
 
Posts: 50 | Registered: July 30, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Change your IF &RECORDS GOTO to skip the ERROR.

 
-IF &RECORDS NE 0 THEN GOTO SKIP

-HTMLFORM BEGIN
<html>
<body>
<p>Test</p>
</body>

</html>

-HTMLFORM END  

-SKIP


WebFOCUS 8206, Unix, Windows
 
Posts: 1720 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
That was extremely easy. Thanks, I guess I'm just not with it today Sweating


WebFOCUS 8.2.01M on Windows 10
 
Posts: 50 | Registered: July 30, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Handling a report with no records

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.