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     How to hide fields in Reporting Objects?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to hide fields in Reporting Objects?
 Login/Join
 
stuey
Gold member
posted
Susannah (#402) mentioned in August 2004 with regard to trying to hide fields in Reporting Objects......

"Dear NewTo;
What version are you in? if you are in 526, its possible. if you are in 525, you need a download.
Art Greenhaus at ibi has written this routine and your salesperson or tech rep should be able to help you contact him, or get the add in file and the documentation from him for you.
What you'll get is a replacement for the ibiapplets.txt (if you're in 525), then you have to make an edit to your site.wfs
Basically, you'll specify some field name characteristics (for ALL files) that you want to exclude(hide) from Reporting OBjects, then you just make new masters, with the hidable fields named with, say, 'xxx' if thats the field characteristics you've decided to hide.
Clear as mud, i know; we all wish it were easier. But we're happy to have a workaround.
(This is for Focus Reporting Objects.)"
.....

We're running 526, but I cant see any mention of this within doc. Does anybody know if this is available? - and if it is, how it works ?
Thanks
Stuart
 
Posts: 55 | Location: UK-London | Registered: January 27, 2005Report This Post
TexasStingray
Master
posted Hide Post
If this is for reporting objects only. 1 option I could think of off the top of my head that is: Is you could create a seperate MASTER FILE with only the fields that you want and use it in the reporting object. I do not think this will work for NON-RDBMS table because some of them may be positional like FIX format and they need it for positioning.
 
Posts: 865 | Registered: May 24, 2004Report This Post
susannah
Expert
posted Hide Post
1. here's the entry in my site.wfs on client52/wfc/etc
_site_profile = \\=
\n -SET \&\&IBI_IF_FLDS = 'd:\\ibi\\apps\\excludef.fex';
2. here's the excludef.fex
WHERE NAME OMITS 'x'
WHERE NAME OMITS 'KEY'
WHERE NAME OMITS 'key'
3. all my reporting objects have been edited to have fieldnames containing these things if i want to hide them. remember you can't change the fieldname of an indexed /key field ... icky stuff happens. but i put an x in the name of any datafield i don't want to show.
Note also that this fex is not in mre but is 'on the backend', as they say (whatever that means!)
4. get your sales rep to go to art greenhaus and get the doc for this procedure. i'm in 525 and i have no idea how this works in any newer version...upgrades are peril!
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
stuey
Gold member
posted Hide Post
Not sure if this is what Stingray was eluding to above, but found that if you blank the fieldname and alias from the mas, then Report Assistant ignores that field in the field list. So therefore i've generated a Report assist mas with descriptions and nulled out fieldnames allied with the USE command for the data.
Thanks for your comments.
Stuart
 
Posts: 55 | Location: UK-London | Registered: January 27, 2005Report This Post
TexasStingray
Master
posted Hide Post
Cool OK There is an undocumented feature. Cool If you put 3 @ signs in the field DESCRIPTION or the HELP text of a master file WebFOCUS will ignore it for some things like Report Assist. Be careful using this. I am not sure is this is supported by IBI or no.
 
Posts: 865 | Registered: May 24, 2004Report This Post
TexasStingray
Master
posted Hide Post
You must also edit the ibiapplets.txt file located in the ibi_html/javaassist directory. Look for

StringArray,FIELDS

following the lookup string above in the TABLE FILE SYSCOLUM add this where statement

WHERE (TITLE OMITS '@@@');

so every field that has @@@ in the title will no longer show up.
 
Posts: 865 | Registered: May 24, 2004Report This Post
TexasStingray
Master
posted Hide Post
If you want you could use HELPMESSAGE instead of TITLE
 
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     How to hide fields in Reporting Objects?

Copyright © 1996-2020 Information Builders