Hi,

Run the below code,

DEFINE FILE CAR
TEST/I1 MISSING ON = IF COUNTRY EQ 'ENGLAND' THEN 1 ELSE MISSING;
END
TABLE FILE CAR
SUM
SALES
TEST
BY COUNTRY PAGE-BREAK
END


Can the Empty column(TEST) be hidden when the column(TEST) has no data?
In the output, i want the column "TEST" to appear only for ENGLAND and not appear in other pages. The output format is PDF.

Thankyou

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

You either print or NOPRINT a whole column, but not choose which one depending on a particular record.

You may need to break your request in 2, HOLDing 2 sets of results: with those with a value and those without it. Then you can run 2 reports out of each HOLD (one would include the column, the other wouldn't) and use the compound layout to put them together.

Unless there is some magic in 7.7 that would allow something to happen but it doesn't make sense to me.

Suppose you were not doing a PAGE-BREAK, what would the information flow in your page if you hid a columns for some records and not for others? alignment would be nuts as everything would shift to the left for each record where a column disappears!

Here's an old trick that might work, depending on your requirements:

DEFINE FILE CAR
 TEST/I1 MISSING ON = IF COUNTRY EQ 'ENGLAND' OR 'ITALY' THEN 1 ELSE MISSING;
END
-*
TABLE FILE CAR
 SUM
  SALES
  TEST
 BY COUNTRY PAGE-BREAK
 ON TABLE SET STYLE *
  TYPE=REPORT, COLUMN=TEST, COLOR=WHITE, WHEN=TEST EQ 0, $
 ENDSTYLE
 ON TABLE PCHOLD FORMAT PDF
END

You could also control the column titles your self.

DEFINE FILE CAR
TEST/I1 MISSING ON = IF COUNTRY EQ 'ENGLAND' THEN 1 ELSE MISSING;
HEADTEST/A4 = IF COUNTRY EQ 'ENGLAND' THEN 'TEST' ELSE ' ';
END
TABLE FILE CAR
HEADING
"COUNTRY<+0>SALES<+0><HEADTEST"
SUM
SALES    AS ''
TEST     AS ''
BY COUNTRY PAGE-BREAK   AS ''
ON TABLE SET STYLE *
TYPE=HEADING, HEADALIGN=BODY, $
ENDSTYLE
END

Two more thoughts:

1) Add SET NODATA = ''
2) Keep in mind that the text can still be seen when the ol' "color=white" trick is used.

What about the new set command:
SET HIDENULLACRS=ON
it is supposed to suppress the column on the sort groups where it is all null. I haven't had a change to try it yet. Is it just for 7.7.03?

Thanks everyone.

The "COLOR=WHITE" cannot be used in the report, as the numbers of columns displayed is dynamic based on the user's selection. The last 3 columns in my report are static showing the Row totals.

Selph,
SET HIDENULLACRS=ON works well for the ACROSS report. However, i need to display some columns with really long titles after the ACROSS columns. Since the across values and the normal column titles do NOT appear horziontally on a single line, i converted ACROSS into columns and displayind them.

The HIDENULLACRS=ON will do the job if the report does not have any other columns to be displayed after the Across columns.

I think i will have to wait for HIDENULL=ON

SET HIDENULLACRS=ON

works great - but only with ACROSS not with BY fields.