I occasionally use the white out trick where we white out a field we don't want to display.

i.e.
TYPE=DATA, SIZE=8, COLUMN=CARRY_VL,COLOR=WHITE,
WHEN=DISPFEDTAXFLAG EQ 'N', $

We found out today that when you go to print html (or print preview), those fields that are "whited" out actual print out on the report. Has anyone found a work around for this? I'm hoping I don't have to try and blank out all the numeric fields they don't want to see.

Thanks.

Have you tried:

BACKCOLOR=RGB(255 255 255),
COLOR= RGB(255 255 255),

(White on White) - not sure what output you'll get.

same results. It still shows when printing, but it does not show if you just have it up on your screen.

Pam,

Try setting the font size as small as you can so that even if it does print, it will just be an obscure mark on the paper.

T

Guess it could work for HTML

IBI says:
You cannot
use Conditional Styling to hide the Column based on a color (white). This
is because Excel will still recognize the column as having data, and
the Grid Lines will still surround that column.

What needs to be done is to utilize two TABLE requests where the first one
establishes the condition which is saved to a HOLD file. Then, using a
-READ, capture that value to an Amper Variable. That Amper Variable is
then used within a -SET with another condition. That condition is then used
within the second TABLE request to screen out the column if that condition is
met.

Example:

TABLE FILE CAR
PRINT COUNTRY
WHERE DEALER_COST EQ 6000
ON TABLE HOLD
END
-RUN
-READ HOLD &CNTRY2.A12.
-SET &NOP = IF &CNTRY2 EQ 'W GERMANY' THEN 'NOPRINT' ELSE ' ';

TABLE FILE CAR
PRINT DEALER_COST CAR MODEL &NOP
RETAIL_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END

TABLE FILE CAR
  SUM SALES DCOST RCOST
  BY COUNTRY
  ON TABLE HOLD FORMAT HTMTABLE
  ON TABLE SET STYLE *
    TYPE=DATA,  COLUMN=SALES, CLASS=nodisplay, WHEN=COUNTRY EQ 'ITALY', $
    TYPE=TITLE, COLUMN=DCOST, CLASS=noprint, $
    TYPE=TITLE, COLUMN=RCOST, CLASS=noprint, $
    TYPE=DATA,  COLUMN=DCOST, CLASS=noprint, $
    TYPE=DATA,  COLUMN=RCOST, CLASS=noprint, $
END
-RUN

-HTMLFORM BEGIN
<style type="text/css">
  .nodisplay {visibility: hidden;}
  @media print {
    .noprint {display: none}
  }
}
</style>
!IBI.FIL.HOLD;
-HTMLFORM END