This post is sort of a continuation/new question from my initial post Original Post. So we now have Dev Studio and are in the process from moving from our mainframe environment to a windows environment. In doing so I am having to create new launch pages and what not for reports. I build a page using the HTML composer tool in dev studio, but I am not able to pass a variable to use it for the dynamic selection of reports. This is where things are similar to my original post, where I was able to handle this with a DM loop. However, I cannot seem to have dev studio not automatically make the control box pass with an 'OR' between each of the values. Am I just missing something here or is this something that the composer cannot do and I have to look at coding this manually?This message has been edited. Last edited by: Kerry,
WebFocus 7.7.03 - 7703_hotfix - Gen: 284 Dev Studio 7.7.03 - Gen: 06062011 Mainframe Focus 7.7.03 Windows WF Client Server zOS Reporting server (hub-sub config) Windows Reporting server Windows RC Client Server
October 23, 2012, 07:18 AM
David Glick
We allow a control to be populated with procedure names in release 8.
David Glick Director WebFOCUS App Studio and WebFOCUS Developer Studio WebFOCUS Division Information Builders, Inc. Direct (917) 339-5560 Voice Mail (212) 736-6250 x3560 Fax (212) 947-5168 Email david_glick@ibi.com
October 23, 2012, 09:31 AM
rfbowley
My 'standard technique' over several clients has been to use a 'router.fex'. Populate a dropdown with a static list something like:
Value Display
RPT01 Cars by Country
RPT02 Employees by Department
Now set up your button/autorun to call the 'router', not the actual report. My clients seem to like the ease of maintenance and the ability to add new items into the 'router'.
Robert F. Bowley Jr. Owner TaRa Solutions, LLC
In WebFOCUS since 2001
October 23, 2012, 09:41 AM
j42p11
Thanks Robert. I was thinking something along the lines of your example but how did you handle if the users want to run the reports to create a compound report and not just one report option? Using your example, if the multi-select is set to yes and they choose RPT01 & RPT02? When I did this before through our mainframe connection, I was able to set up the DM loop and check for the number of selections and loop through them all to create the compound or bypass the loop if only one selection was chosen. I am not seeing that I will have the ability to give the users that type of flexibility.
@David - We are still in the process of implementing 7.7.03 here, so I do not see us moving to release 8 any time soon. But that is good to know that the feature is there.
WebFocus 7.7.03 - 7703_hotfix - Gen: 284 Dev Studio 7.7.03 - Gen: 06062011 Mainframe Focus 7.7.03 Windows WF Client Server zOS Reporting server (hub-sub config) Windows Reporting server Windows RC Client Server
October 23, 2012, 10:22 AM
rfbowley
I would just change the Dropdown to a multi select list box and use GETTOK to parse out the list of reports. Then use the same looping technique.
If you want to get real fancy, use a double list box. The left side holds the list of available reports, and the user just selects the ones they want that way.
Robert F. Bowley Jr. Owner TaRa Solutions, LLC
In WebFOCUS since 2001
October 23, 2012, 10:28 AM
j42p11
Thanks Robert. I will give those a shot.
WebFocus 7.7.03 - 7703_hotfix - Gen: 284 Dev Studio 7.7.03 - Gen: 06062011 Mainframe Focus 7.7.03 Windows WF Client Server zOS Reporting server (hub-sub config) Windows Reporting server Windows RC Client Server
October 24, 2012, 09:38 AM
George Patton
Oooooooh! Robert, I like this a lot! It saves an enormous amout of hassle creating a main page with dozens of links to the individual launch pages.
It will also allow me to create not just one but probably 3 or 4 list boxes according to the sort/selection criteria and to put an explanation of those sorts/selections beside each list box.
The one problem with a "router" fex is running it in deferred mode. We have 8 parameter screens with exactly the same parameters - just different reports. I wanted to use a "router" idea but soon realized that the report name in the Deferred Reports window is the name of the router fex.
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