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     Specifying output type on drilldown

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Specifying output type on drilldown
 Login/Join
 
MTracker
Member
posted
I know there has been previous discussion concerning specifying the output type from a drilldown report. It looks like most of the proposed solutions would have you rerun the current report with a new output format. In our self service app we currently do that exact thing. Run a report; drill down to the detail your looking for; click a link that reruns the report to another format(i.e. pdf, excel, etc.).

What I would prefer to do is have the ability to change the desired output as part of drilling down from the report. I would incorporate the onClick event for the link to modify the link to include a variable to specify the output.

While webfocus allows you to specify a drilldown path or specify a javascript function to execute when the link is clicked, it doesn't appear to allow you to specify any code related to an event. I'm I correct on that or have I missed something in the documentation?

If anybody has an alternative idea I would appreciate your input. Thanks.
 
Posts: 21 | Registered: November 15, 2004Report This Post
dhagen
Virtuoso
posted Hide Post
I can think of multiple ways of doing this. The first one that comes to mind is to have all the reports drill to a common report that returns a dynamic FORM with the output type as a selection. Everything in that form, other then output type, should be dynamic and of type hidden (including the report to execute). This way, you can be looking at any format type, click a drill down, and select any format type for the next report.

Just a thought.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
MTracker
Member
posted Hide Post
I may not be following your message. My understanding is that when you click on the drilldown link all that you are passing back to webfocus will be the information in the link. If you have other variables set as input types on a form they would not be passed. You would need to do a submit, but then nothing in the link would be passed only the variables on the form. If the event onClick was available as part of the definition of the link you could basically take the this.href reference and add the value of the desired output type as indicated by a control on the form.

Maybe that could be an enhancement?
 
Posts: 21 | Registered: November 15, 2004Report This Post
k.lane
Platinum Member
posted Hide Post
Why not use multi drilldowns, assuming of course that your report is in HTML.

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=COUNTRY,
DRILLMENUITEM='HTML',
FOCEXEC=newfex(COUNTRY = COUNTRY \
OUTPUT = 'HTML'),
DRILLMENUITEM='PDF',
FOCEXEC=newfex(COUNTRY = COUNTRY \
OUTPUT = 'PDF'),
DRILLMENUITEM='EXL2K',
FOCEXEC=newfex(COUNTRY = COUNTRY \
OUTPUT = 'EXL2K'),$
ENDSTYLE
END

This will allow you to execute newfex.fex using the output format specified. newfex.fex could then contain:

-IF &OUTPUT EQ 'HTML' THEN GOTO SKIPTHIS ;
ON TABLE PCHOLD FORMAT &OUTPUT
-:SKIPTHIS

Very simplistic, but it does accomplish what you were looking for.

Ken


Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Databases: Oracle 10g, SQL Server 2000, DB2.
 
Posts: 177 | Location: Calgary, Alberta, Canada | Registered: April 25, 2005Report This Post
MTracker
Member
posted Hide Post
That is an interesting approach. Thanks.
 
Posts: 21 | Registered: November 15, 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     Specifying output type on drilldown

Copyright © 1996-2020 Information Builders