Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Pass a parameter from radio button to a drill down report on dashboard
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Pass a parameter from radio button to a drill down report on dashboard
 Login/Join
 
Member
posted
I have not found this exact case yet on Focal Point. I'm using InfoAssist Dashboard WF 8.1.05. I have a dashboard with 4 radio button controls that controls 2 graphs and a report. However, the report also has a drilldown that goes to more detail. I need to pass one of the values from one of the radio button controls (value not available in the report) to a drilldown on the report along with some additional columns of the report to bring up the drilldown report. I can't figure out how / where I can specify sending that radio button value to the drilldown report... example... my radiobutton control is called "radiobutton_5"

This message has been edited. Last edited by: FP Mod Chuck,


App Studio 8.2.03 Windows all formats
 
Posts: 24 | Registered: September 13, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
You need to pass the parameter to the report, then in the report add this parameter to the drilldown...


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, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Is there a way to display the parameter value in a column...


App Studio 8.2.03 Windows all formats
 
Posts: 24 | Registered: September 13, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Once the parameter value is available to the report you can do whatever you want with it. If you want the a column COL1 with the parameter value &PAR1, then you need to define a column like

COL1/A10 = &PAR1;


WebFOCUS
7703/7705/8105m/8201m/8202m

 
Posts: 100 | Registered: September 10, 2013Reply With QuoteReport This Post
Expert
posted Hide Post
If you don't want to use the parameter in the main report but only in the drilldown report, the parameter value does NOT have to be in a column, you add it to the drilldown with code something like this:

...
PARAM99=&PARAM99.QUOTEDSTRING \
...


If you do want the parameter value in a column, follow WF1326's advice. You can also put the parameter value in a report HEADING or FOOTING.

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, 2005Reply With QuoteReport This Post
Master
posted Hide Post
One thing I use from time to times is cookies. Cookies have to be enabled as WebFOCUS uses them.




Scott

 
Posts: 865 | Registered: May 24, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Pass a parameter from radio button to a drill down report on dashboard

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.