Focal Point
Multiple Reports - Same Parameter fileds - One HTML Page

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9381027292

July 23, 2008, 06:54 PM
<Pants>
Multiple Reports - Same Parameter fileds - One HTML Page
I am trying to create an HTML page (using HTML Layout Painter) with a list of reports that a user will launch with a push button. The issue is that each report has a common parameter and data source. I would like to show the parameter drop down for each report. Right now when I bring in report 2 the parameter already exist so report 2 runs with report 1's parameter selection. Is there a way around this without renaming the value in report 2's procedure?

Thanks!
July 23, 2008, 07:28 PM
susannah
Dr Pants,
are you wanting to use 1 single HTML Launch page to launch several different fexes?
How are you specifying the 2nd fex now?
1 FORM has 1 action..
so if you want 2 fexes to run with different parm selections, you need 2 FORMs in your launch page. that means 2 sets of dropdowns, 2 actions, 2 separate submit buttons.
If you have MRE, do a PUBLISH on your fex from MRE to see what a launchpage looks like with FORM tags, rather than using HTML Layout Painter.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
July 24, 2008, 11:25 AM
<Pants>
Yes, I am wanting to use one HTML page to launch several different fexes.

I tried adding a pushbutton and creating a hyperlink for each report, which does not allow me to create a second set of drop downs because they do not appear in the "New Parameters dialog box"...

How would I create 2 FORMS in the launch page?

I did a PUBLISH of the fex, but I am not sure what I am looking for in regard to FORM tags.

Thanks!
I really appreciate you taking the time to respond
July 24, 2008, 11:48 AM
Tony A
Change your button from type of "submit" to type of "button" and then write some javascript to be actioned via the "onclick"event for each button.

As the final part of the onclick event javascript include document.forms[1].submit() to action your form.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
July 24, 2008, 11:59 AM
Danny-SRL
Dr.,

What about having a drop down box from which you choose your fex? The fex gets put into an &variable which you then execute.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

July 24, 2008, 12:23 PM
<Pants>
the type is currently "button" and each on-click event runs the correct report...the problem is the parameters value/drop down "Claim Year" for example, is associated with both reports...I would like to create a second, identical "Claim Year" drop down that applies to report 2
July 24, 2008, 02:26 PM
PBrightwell
Are you wanting to run 1 report at a time or are you wanting to run the reports and have them side by side (or one over the other)? If it is one report at a time, you probably don't need different parameters (you may want to add options for sort/sum etc and even use one program). If you are wanting to run 2 programs at the same time, try an IFRAME.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
July 24, 2008, 02:40 PM
susannah
ok, you have to get this...
one button -> one form -> one report.
If you really want one go button and 2 fexes, then you have to have 2 dropdown lists,
they can have the same stuff in them, but they've got to have 2 different &VAR names.
Fex 1 uses &var#1 and ignores #var #2
Fex 2 uses &var#2 and ignores #var #1.
this is a goofy design, but it'll work.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
July 24, 2008, 03:13 PM
<Pants>
Obviously I haven't done a good enough job explaining the isuue, thanks to everyone for your suggestions. I will try a few and see what I come up with