Can you delete a column using the stylesheet? Something like:
TYPE=REPORT,
COLUMN=N5,
DELETE... or something,
$

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

What are you trying to do, Mark? The answer to your direct question is no. Maybe you can make it invisible with font color or something.

But if you don't want a column to appear on your report, you can use Dialogue Manager to bypass it. There are a number of ways to do that.

Or use NOPRINT in the report.

Or conditionally use NOPRINT as in:

TABLE FILE CAR
PRINT CAR
      MODEL &NOPRINT
   BY COUNTRY

Just have logic to set &NOPRINT to NOPRINT or blank.

If the intention is to mask data in specific rows of a column and not the entire column, here is one way -

TYPE=DATA,COLUMN=COL1,COLOR=WHITE,BACKCOLOR=WHITE,WHEN=COL1 EQ 0,$

or

TYPE=DATA,COLUMN=COL1,COLOR=SILVER,BACKCOLOR=SILVER,WHEN=COL1 EQ 0,$

Sandeep Mamidenna

Thanks for the response. I set the columnwidth to 0 in the stylesheet. That basically just hid the column in the excel output, instead of getting rid of it, but it'll work.

quote:

columnwidth

And how did you do that? Neither WIDTH nor WRAP behave as you suggest?

Thanks,

Can you unhide these column if you ever want them back..... I am using noprint and it hid the columns but I cannot unhide them later on.

Does your site have a license for Active Reports, i.e. AHTML output? That output allows you to show and hide columns.

If you don't have that, you'd have to make the NOPRINT an amper variable in the program and rerun it to get the column to show up.

Hello Ginny, Our site does have a license for Active Reports..... and I am able to hide and unhide columns. However I cannot unhide the columns that were initially NOPRINT items.

Scott,

Are you new to WebFOCUS? Question asked based on # of posts..

Here is an example to Hide/Unhide a column. It is a very simple example, but, gives you a concept to begin with:

  
-SET &ECHO=ALL;
-DEFAULT &HIDE = 'Y'
-SET &X_HIDE = IF &HIDE EQ 'Y' THEN 'N' ELSE 'Y';
DEFINE FILE GGSALES
 SYEAR/YY=DATE;
 DUMMY/A10 = ' ';
 XDOLLARS/P9C = DOLLARS;
END
TABLE FILE GGSALES
SUM
-IF &HIDE EQ 'Y' GOTO DO_DUMMY;
     UNITS  AS 'Click to hide,  Units'
-GOTO DO_VAR
-DO_DUMMY
     DUMMY AS 'Click to Un-Hide'
-DO_VAR
     XDOLLARS AS 'Amount'
BY STCD
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=TITLE,
COLUMN=N2,
FOCEXEC=Hide_UnHide.fex (HIDE = '&X_HIDE.EVAL'), $

TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     COLOR='BLACK',
     STYLE=NORMAL,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     ACROSS=1,
     STYLE=BOLD,
$
TYPE=ACROSSTITLE,
     ACROSS=1,
     STYLE=BOLD,
$
ENDSTYLE
END

hth

Hello Tom....

Yes, I am pretty new at programming in Webfocus.. about a year... I kinda got hooked into this question because one of our users saw a list of columns hidden in a report that I supply.... I never intended for them to show up as hidden, I just used them to help with selection. He is now challenging me to let him see the columns.... I am thinking of revoking his computer privileges.