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>,

There are some system tables, such as SYSTABLE and SYSCOLUM.

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

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

 
 

Would the EMPTYREPORT setting be helpful?

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

SET NODATA = '' ???