How can I get the SET NODATA command to work for a "grouped by" report? Here's a snippet of my code:
.....
SET NODATA = 'N/A'
.....
TABLE FILE QSACUS
SUM
DESCRIPTION
CNT.counter AS 'COUNT'
PCT.CNT.CTRLNBR AS '%TOTAL'
COST/D12.2CM
BY TOTAL HIGHEST counter NOPRINT
BY &GROUPBY
....
To clarify, the DESCRIPTION field will display "N/A" if the table value is null, but the &GROUPBY isn't doing the same thing. It will just be a blank. The &GROUPBY field is being used as the link to another report. In HTML, the blank is fine - the link still works. But the PDF DrillThrough version of the report doesn't display anything for the link so users cannot drillthrough on the null values. Please excuse my ignorance as I am new to WebFOCUS and just about ready to throw in the towel.
.....
SET NODATA = 'N/A'
.....
TABLE FILE QSACUS
SUM
DESCRIPTION
CNT.counter AS 'COUNT'
PCT.CNT.CTRLNBR AS '%TOTAL'
COST/D12.2CM
BY TOTAL HIGHEST counter NOPRINT
BY &GROUPBY
....
To clarify, the DESCRIPTION field will display "N/A" if the table value is null, but the &GROUPBY isn't doing the same thing. It will just be a blank. The &GROUPBY field is being used as the link to another report. In HTML, the blank is fine - the link still works. But the PDF DrillThrough version of the report doesn't display anything for the link so users cannot drillthrough on the null values. Please excuse my ignorance as I am new to WebFOCUS and just about ready to throw in the towel.