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     [CLOSED]How to write NODATA to display empty report w/o using Master file/HTML FORM
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]How to write NODATA to display empty report w/o using Master file/HTML FORM
 Login/Join
 
Silver Member
posted
Hi Team,

What are the ways to display NODATA in fex report.

I don’t want to use any CAR or EMPDATA to create Dummy columns and then print the “No Data Available”.
Also I don’t want to write any HTMLFORM BEGIN and END code inside my .FEX file.

I want to know is there any WebFOCUS system defined file is there to achieve the same.

In PRODUCTION I do not want to write some unwanted code based on some sample files.

Let me know your concerns.

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8.0.05 - BI Portal, Developer Studio, Dev/App Studio, Excel, PDF, Active Formats and HTML5, Adobe Flex Builder, VBA
 
Posts: 47 | Location: Bengaluru, India | Registered: December 04, 2014Reply With QuoteReport This Post
Virtuoso
posted Hide Post
There are some system tables, such as SYSTABLE and SYSCOLUM.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1652 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks Wep5622, I will try that and let you know if i need any information.

It will be good if you can provide a sample .FEX file using the system tables.

Thanks a lot for your help on this.

Regards,
Suresh


WebFOCUS 8.0.05 - BI Portal, Developer Studio, Dev/App Studio, Excel, PDF, Active Formats and HTML5, Adobe Flex Builder, VBA
 
Posts: 47 | Location: Bengaluru, India | Registered: December 04, 2014Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Not sure what you are looking for. In my company, we have an include to produce an empty report. When we execute the report Select, if it returns absolutely no data, we GOTO the empty report logic.

 
-* File nodata.fex
-*
-********************************************************************************
-***  NULL / EMPTY REPORT ROUTINE
-********************************************************************************
-*
-SET &OURSTYLE = IF &WFFMT EQ       'PDF'       THEN '-INCLUDE PDF.STY'
-                                               ELSE '-INCLUDE XL_HTML.STY' ;
-*
-SET &MSGLINE1 = IF &FOCERRNUM          NE 0    THEN 'A WebFOCUS processing error has occurred. The WebFOCUS error number is: &FOCERRNUM.EVAL'
-           ELSE IF '&RC_OR_ADHOC.EVAL' EQ 'RC' THEN 'No records were selected based upon standard/default filtering criteria for this report.'
-           ELSE IF '&PORTED.EVAL'      EQ 'Y'  THEN 'No records were selected based upon standard/default filtering criteria for this report.'
-                                               ELSE 'No records were selected based upon the filtering criteria you provided at run time for this report.';
-SET &MSGLINE2 = IF &FOCERRNUM          NE 0    THEN 'Please contact your system administrator with this information.'
-           ELSE IF '&RC_OR_ADHOC.EVAL' EQ 'RC' THEN ' '
-           ELSE IF '&PORTED.EVAL'      EQ 'Y'  THEN ' '
-                                               ELSE 'Please verify the filtering criteria entered, adjust as needed, and rerun the report.';
-*
DEFINE FILE SYSTABLE
MSGLINE1/A100  = '&MSGLINE1.EVAL';
MSGLINE2/A100  = '&MSGLINE2.EVAL';
BLANKLINE/A100 = ' ';
END
 
TABLE FILE SYSTABLE
SUM
MSGLINE1  AS ''
OVER
BLANKLINE AS ''
OVER
MSGLINE2  AS ''
 
&IMAGEFILE.EVAL
 
BY NAME   NOPRINT
 
WHERE RECORDLIMIT EQ 1
 
HEADING
&OURHEAD1.EVAL
" <+0>&RPT_COMPANY<+0>&RPT_ID_TX<+0>&RPT_ID"
" <+0>&RPT_TITLE<+0>&RPT_DATE_TX<+0>&RPT_DATE"
" <+0>&RPT_TITLE2<+0>&RPT_TIME_TX<+0>&RPT_TIME"
" "
FOOTING BOTTOM
" "
" "
"&FEX_NAME       <+0>&RPT_CONF_TX<+0> <+0> "
"&&SRVNAME       <+0>            <+0> <+0> "
 
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT &WFFMT &OPENCLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
&OURSTYLE.EVAL
TYPE=TITLE,  COLOR='WHITE', STYLE=NORMAL,
     BORDER-TOP-COLOR=WHITE, BORDER-BOTTOM-COLOR=WHITE,
     BORDER-LEFT-COLOR=WHITE, BORDER-RIGHT-COLOR=WHITE,
$
ENDSTYLE
END
-RUN

 
 


WebFOCUS 7.7.05 (Someday 8)
Windows 7, All Outputs
In Focus since 1983.
 
Posts: 103 | Registered: April 27, 2011Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Would the EMPTYREPORT setting be helpful?

This message has been edited. Last edited by: Dan Satchell,


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
SET NODATA = '' ???


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1110 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You will have to verify this still works in version 8


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1101 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]How to write NODATA to display empty report w/o using Master file/HTML FORM

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