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     Drill on a duplicate field ... any workaround?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Drill on a duplicate field ... any workaround?
 Login/Join
 
Silver Member
posted
hi everybody,

i'm having a problem with a report that is heavily parameterized.

one feature of this report is the ability to sort by clicking on the column header. it works by re-running the report passing that column name as a variable so the PRINT statement ends with "BY &SORTFLD NOPRINT". the problem is, any drills i have set up on that field no longer work. i suspect it is applying the drills to the NOPRINTed column now and not the other instance of that field. here's an example:

TABLE FILE WHATEVER
PRINT
FNAME
LNAME
SSN
BY &SORTFIELD NOPRINT
...
TYPE=TITLE,
COLUMN=LNAME,
JAVASCRIPT=sortColumn('LNAME'),
$


if &SORTFIELD equals 'LNAME', it correctly sorts by that field, but any drills i have set up on the LNAME column don't show up anymore.

when the drills are set up, i know you can reference them by their sequential number instead of by name, but that won't work for me in this particular instance because i have other code in there that allows the user to switch up the order of the columns.

i tried making the sortfield a computed field but you can't do that either.

my question is, is there any way to make it apply the drills to the visible column and not the hidden NOPRINT one? i'd appreciate any ideas, as i'm kind of stumped.


---------------------
WebFOCUS 7.6
 
Posts: 41 | Registered: August 05, 2005Report This Post
Guru
posted Hide Post
You can access the second column by placing a (2) after the field in the style sheet

Ex:
..., COLUMN=LNAME(2), drill stuff ...

However, I suspect since you have everything as a parameter you will need 2 style entries. One without the (2) and one with it.

So if they pick a field not in the by they get the first and when they pick one in the by they get the second.

Ex:

..., COLUMN=&SORTFIELD, drill stuff ... happens
when &SORTFIELD is not in the print list

..., COLUMN=&SORTFIELD (2), drill stuff ... happens when &SORTFIELD is in the print list

Fernando


Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
 
Posts: 278 | Registered: October 10, 2006Report This Post
Silver Member
posted Hide Post
ah, perfect! would there happen to be any way to reference multiple fields with a single "COLUMN="? (like say "COLUMN=&SORTFIELD(1) &SORFIELD(2),"? the drill section is already super-long, i'm not eager to double its size.

thanks for the response!


---------------------
WebFOCUS 7.6
 
Posts: 41 | Registered: August 05, 2005Report This Post
Expert
posted Hide Post
TYPE=TITLE,
COLUMN=LNAME(*),
JAVASCRIPT=sortColumn('LNAME'),


will work - the * applies the drilldown to all columns named LNAME including whether or not there's a BY LNAME NOPRINT

Working example:

-DEFAULT &SORTBY = 'COUNTRY';

TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
SALES
BY &SORTBY NOPRINT
ON TABLE SET STYLE *
TYPE=TITLE, COLUMN=COUNTRY(*), FOCEXEC=CARTEST111 (SORTBY='COUNTRY'), $
TYPE=TITLE, COLUMN=CAR(*),     FOCEXEC=CARTEST111 (SORTBY='CAR'    ), $
TYPE=TITLE, COLUMN=MODEL(*),   FOCEXEC=CARTEST111 (SORTBY='MODEL'  ), $
TYPE=TITLE, COLUMN=SALES(*),   FOCEXEC=CARTEST111 (SORTBY='SALES'  ), $
ENDSTYLE
END
-RUN


PS. Interesting hairdo, GreenspanDan.

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Silver Member
posted Hide Post
beautiful. and thanks! Smiler


---------------------
WebFOCUS 7.6
 
Posts: 41 | Registered: August 05, 2005Report This Post
Expert
posted Hide Post
greenspandan, what is the .js 'sortColumn' ?
is that home grown or is it something from a 76 gui world?




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
Silver Member
posted Hide Post
oh, that's my own javascript. it'd be a nice built-in feature, though!


---------------------
WebFOCUS 7.6
 
Posts: 41 | Registered: August 05, 2005Report This Post
Expert
posted Hide Post
would you share your .js?
we'll applaud.

did you try
ON TABLE SET HOLDLIST PRINTONLY
to see if you get only 1 instance of your drillfield name?
761, btw, has some swell new features for refencing columns. Noreen's webinar from yesterday will be posted soon.




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
Silver Member
posted Hide Post
i'd gladly post it if it was a quick and easy thing, but it uses .jsp and frames and javascript, it's really pretty messy!


---------------------
WebFOCUS 7.6
 
Posts: 41 | Registered: August 05, 2005Report 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     Drill on a duplicate field ... any workaround?

Copyright © 1996-2020 Information Builders