Focal Point
Resource Layout Painter

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

January 13, 2005, 03:26 PM
Spence
Resource Layout Painter
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.
January 13, 2005, 07:32 PM
dhagen
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.
January 17, 2005, 11:56 AM
Spence
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?
January 17, 2005, 08:04 PM
dhagen
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.
January 19, 2005, 02:13 PM
Spence
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?
January 24, 2005, 07:49 PM
dhagen
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
January 24, 2005, 07:53 PM
dhagen
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!