Running a fex that produces a blank report - different options
Article ID: KB0070286
Updated On:
| Products | Versions |
|---|---|
| ibi WebFOCUS | 8207 and above |
Description
Running a fex that produces a blank report - different options Example: The following request does not retrieve any records SET EMPTYREPORT=OFF TABLE FILE WF_RETAIL_LITE HEADING "This is the heading" SUM COGS_US REVENUE_US COLUMN-TOTAL ROW-TOTAL BY COUNTRY_NAME WHERE COUNTRY_NAME EQ 'Louisiana' FOOTING "This is the footing" ON TABLE SET STYLE * GRID=OFF,$ END As EMPTYREPORT is OFF, this is what appears on the user's screen: 0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0
Issue/Introduction
Running a fex that produces a blank report - different options
Environment
Windows, Linux
Resolution
To deal with empty reports in a more professional manner...
1) SET EMPTYREPORT=ON
2) SET EMPTYREPORT=ANSI
1) SET EMPTYREPORT=ON
2) SET EMPTYREPORT=ANSI
Additional Information
One can refer the below document to control the display of empty reports
https://docs.tibco.com/pub/wf-wf/8207.28.10/doc/pdf/TIB_wfwf_8207.28.0_cr_language.pdf Page number - 1249
https://docs.tibco.com/pub/wf-wf/8207.28.10/doc/pdf/TIB_wfwf_8207.28.0_cr_language.pdf Page number - 1249
Feedback
Yes
No
Powered by
