Hi all,
i want to know how to use the NODATA .i.e;if my report has '0' records i want to display in the output as NODATA available.so want to know how to start of with....

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

i tried:--->
-IF &RECORDS EQ 0 THEN GOTO ENDFEX;

-ENDFEX
-EXIT


WHEN I RUN my code and if the records are equal to 0 i get EDA NO DATA.i want the text as nodata available ,so where can i modify the text...
PLEASE add incase i missed any..........

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

please close it,the problem is solved....

FYI

NODATA is used for data that is missing/null

Hi Swati,

Sample CAR File:

TABLE FILE CAR
PRINT
COMPUTE SPC/A1=''; AS ''
WHERE RECORDLIMIT EQ 1
BY CAR NOPRINT
ON CAR SUBHEAD
" "
" "
"No Data is available"
" "
END
-RUN

quote:

ORDLIMIT

Hi

After you write the data into SQLOUT

just checn &LNS = 0
then write HTML tag
" No data found for this selecton"

This method is working fine for me

Thanks
Gobinath Velusamy

As said before : Nodata -> Missing / Null
After the End of the Request ( -RUN to synchronise Focus and DM -DM of the Machine that fills the Data-) the System Variables &LINES etc .. are available.
And the SET EMPTYREPORT = ON / OFF used to do the Job under Focus
Cordially and Focusely
PS : Precise answers or a friendly push towards really getting into the '$Focus$' world ?

Hi guys,
i am not looking for NODATA OPTION.i am looking for is ---->
if i have '0' records in the output then i want to print saying that "there is no data".if there are any records i will get a report but if there are no records,i want to display a good msg saying "there is no Data".so need a start off for this.......

btw GOBINATH,can you please pass me the code for the HTML tag,which you have written.

Swati,

Do you see the </> on the toolbar when you Reply? Put your code between those, and VOILA!, the code is displayed...

To cortrect the exaple from shakila25 which would return the SUBHEAD
when data was retrieved

 
TABLE FILE CAR
PRINT
     CAR
WHERE COUNTRY EQ 'USA'
END
-RUN 
-IF &LINES EQ 0 GOTO NODATA;
-EXIT
-NODATA
-HTMLFORM BEGIN
No Data is available
-HTMLFORM END

You can any styling you want into the HTML

But do get some basic training.

The usual method is to extract and hold the data rows for the report, then use dialog manager -IF (or -SET) to sense whether &RECORDS (or &LINES) > 0, and branch (or adjust the report request) accordingly.

I thought about it, and came up with a "pure Focus" alternative, avoiding the Dialog-Manager part:

Convert the TABLE FILE ... HOLD data-extraction section to a MATCH FILE. In the data extraction leg of the Match include a leading column with a row count (equivalent to &LINES); that involves multiple verbs, which is allowed in MATCH FILE. Use the other leg to assure that the merged HOLD file will have at least one row; that enables you to run a TABLE FILE request against the HOLD file, even if the data extraction leg came up empty-handed. Use DEFINE FILE HOLD before the formatted report, to provide a "no data" message in the heading, based on whether COUNT is zero. To avoid displaying zero for numeric columns when the report is "empty", you can redefine them as well, using "S" to suppress display when zero, or making them MISSING when the COUNT column is zero.

As an illustration, run this fex with &LETTER=A (which produces a normal report) and &LETTER=Z (which generates an "empty" report).

-DEFAULT &LETTER='Z'
MATCH FILE CAR
 COUNT ENTRIES
 WRITE SEATS
  BY COUNTRY BY CAR BY MODEL
 IF MODEL CONTAINS '&LETTER'
RUN
FILE CAR
 WRITE FST.COUNTRY AS IGNORE
 AFTER MATCH HOLD OLD-OR-NEW
END

DEFINE FILE HOLD
 NOTE/A30=DECODE COUNT(0 '(No matching records found)' ELSE '');
 SEATS/I5S=SEATS;
END
TABLE FILE HOLD
HEADING CENTER
"<NOTE</1"
 PRINT SEATS
  BY COUNTRY 
  BY CAR SKIP-LINE
  BY MODEL
 ON TABLE PCHOLD FORMAT PDF
END

This message has been edited. Last edited by: j.gross,

thanks all........