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     Resource Layout Painter
Go
New
Search
Notify
Tools
Reply
  
Resource Layout Painter
 Login/Join
 
Platinum Member
posted
Can this be done in resource layout painter?

I have a report and a graph that displaying on the same page, side by side. They are iframes.
The both use the same three variables. The three variables are displayed on the top of the page and are drop down boxes.
I would like to have one run button execute both the report and graph. I would settle for two run buttons one for the graph and the other for the report. Can both reports use the same set of variables? I have not been able to get this to work.
 
Posts: 188 | Location: pgh pa | Registered: October 06, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The easy way to do this is to:
1) create the report and graph.
2) create a new layout.
3) add a report (from the icon list) to the layout. Right click and choose to import an existing report (see step 1). It will then get the parms and add them to the top to the page.
4) add a graph (from the icon list) and import the already existing graph.

There will now only be one run button that will execute both iframes.

Note: When you do this, the report and graph are imported into the new procedure. Therefore, if you need to change the report or graph, you must open the layout procedure in procedure viewer to see the report and graph icons.
 
Posts: 1100 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
That worked for me. Both the report and graph are running from one button. Now is there a way to have the report and graph execute as soon as the page is opened using the default prompt values?
 
Posts: 188 | Location: pgh pa | Registered: October 06, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Yes, there is a way to run with the defaults. When you created the new layout, there should be an htm file and a fex file. Put the defaults in the fex, and uncheck the "Prompt for parameters" in the properties. Execute the fex.
 
Posts: 1100 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I have not been able to get that to work. I am running with version 5.26. When you say put the variables in the fex, should I just use a -SET command to set the variables to the defaults?
What will happen when a user selects viarables other than the defaults?

Do I uncheck the "prompt for parameters" in the page properties?
 
Posts: 188 | Location: pgh pa | Registered: October 06, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Sorry for the lateness of this.

In the .fex file, set the defaults values like:
-DEFAULT &parm1='value1'
-DEFAULT &parm2='value2'
Put the defaults at the beginning of the fex file using the "Other" icon to get a text edittor.

When you save you report, right mouse click the report (.fex) name and select "Properties". From the resulting dialog box, uncheck "Prompt for parameters"

Hope this helps.

Darryl
 
Posts: 1100 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Sorry, one last thing:

When you initialize a parameter with a -DEFAULT, this tells webfocus to use the default value only when a user does not send a value for that parameter. If the user sets a value (like from a drop down box), the the default is ignored, and the user's selected value is used instead.

If you were to use a -SET instead of a -DEFAULT, then the users selected value would be ignored!
 
Posts: 1100 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Resource Layout Painter

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