Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     color=white trick for fields you don't want to display

Read-Only Read-Only Topic
Go
Search
Notify
Tools
color=white trick for fields you don't want to display
 Login/Join
 
Pam Kratt
Platinum Member
posted
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.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
 
Posts: 179 | Registered: November 10, 2004Report This Post
Jim_at_LM
Gold member
posted Hide Post
Have you tried:

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

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


WebFOCUS 7.6.11, WINDOWS, HTML, PDF, EXCEL
 
Posts: 77 | Location: Baltimore | Registered: May 31, 2006Report This Post
Pam Kratt
Platinum Member
posted Hide Post
same results. It still shows when printing, but it does not show if you just have it up on your screen.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
 
Posts: 179 | Registered: November 10, 2004Report This Post
Tony A
Expert
posted Hide Post
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


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Prarie
Virtuoso
posted Hide Post
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


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Jim_at_LM
Gold member
posted Hide Post
Thanks Tony - we'll try it here too. Smiler


WebFOCUS 7.6.11, WINDOWS, HTML, PDF, EXCEL
 
Posts: 77 | Location: Baltimore | Registered: May 31, 2006Report This Post
Mikel
Platinum Member
posted Hide Post
For HTML display/print only, in order to hide columns, I prefer use CSS styles.

In the following example:

- Browser don't show SALES when COUNTRY EQ ITALY.
(class nodisplay with visibility css property set to "hidden")

- DCOST & RCOST columns are not displayed on printer.
(class noprint with display css property set to "none" when media is printer)

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

Regards,
Mikel


WebFOCUS 8.1.05, 8.2.01
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Report This Post
Pam Kratt
Platinum Member
posted Hide Post
I love the suggestion of:


It worked great. Thanks.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
 
Posts: 179 | Registered: November 10, 2004Report This Post
susannah
Expert
posted Hide Post
Pam, each users' browser settings determine whether 'print background colors and images' get displayed. if that switch is off, then you print black and white.
if that switch is on, then you get the nice invisible white font. But it is user-desktop-specific. Tools/Internet Options/Advanced..and scroll down;



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
TexasStingray
Master
posted Hide Post
Tell me why cannot you use NOPRINT?




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
Pam Kratt
Platinum Member
posted Hide Post
We can't do noprint because we need the field to print normally. It's only when a certain row is printed that they don't want to see the amounts in one column. Noprint would cause the column to never print. They want to see 9 out of 10 rows and some accounts may not even have that 1 row of data that they don't want. Of course, they want to see some of the columns for that 1 row, so you can't eliminate the data completely.

The solution of class=nodisplay suggested by Mikel worked great.


webfocus 8.105M; os: windows; pdf, html, exl2k, csv
 
Posts: 179 | Registered: November 10, 2004Report This Post
susannah
Expert
posted Hide Post
applause, Mikel.
what a really neat trick.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
TexasStingray
Master
posted Hide Post
If you can determine what row it should and should not print on could you not set the computed field to missing and before the report runs set SET NODATA = ''.




Scott

 
Posts: 865 | Registered: May 24, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     color=white trick for fields you don't want to display

Copyright © 1996-2020 Information Builders