Focal Point
[SOLVED] Change Static Parameter to Dynamic in HTML Composer

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

May 09, 2017, 05:36 AM
JazBar
[SOLVED] Change Static Parameter to Dynamic in HTML Composer
Hi All,

We've built a HTML form with controls from a fex containing a number of variables. The HTML form creation process created all of the listboxes for us to be able to make selections at runtime. All of the listboxes are set to be Dynamic with multiselect and are chained. All of these work great.

A requirement to add an additional variable has come along, so we've added it to the fex, and created the parameter, and an associated listbox. We've then added this to the chain of listboxes. On the properties of the listbox, we've assigned the value in the fex to be correct field to be associated with it, and selected Dynamic as the Data Type.

The issue is that although the chaining all works as expected, the settings for the parameter state that it is Static, not Dynamic. This means that Multiselect does not work.

How can I change the settings for the Parameter to be Dynamic as opposed to Static?

I've tried deleting and recreating the listbox from the Design Canvas, and deleting the Parameter from the Parameters section of HTML composer, but you can't delete the parameter once it's created. It just sits there as unbound.

Any help would be greatly appreciated.

This message has been edited. Last edited by: FP Mod Chuck,
May 09, 2017, 10:35 AM
eric.woerle
JazBar,

First, Dynamic/Static does not control whether a listbox allows Multiselect. That is an attribute. Look under the properties of the element. There should be a "Multiples" option.

Dynamic/Static defines how the element is populated. Dynamic means that it will be loaded at run time, Static will have the values hard coded in the HTML.

How you handle this is slightly different between Dev Studio and App studio. Which one are you using?


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
May 09, 2017, 11:48 AM
JazBar
Hi Eric,

I'm using App Studio, V8.1.05.

Things have move on since in that I noticed that the new parameter wasn't associated with a WHERE statement in the fex. As this as the case, when the control and parameter were created, App Studio didn't know which field in the Master file it was associated with, and just created it as a Static parameter.

After adding the WHERE statement, and creating another HTML document, App Studio knows immediately the field it's associated with and creates it as Dynamic, thus also allowing multiselect functionality.

Now if my original HTML document, which has a large number of animations and styling, can be reused then I'll be very happy. I can't delete the parameter as it stays there as unbound, and refreshing the Parameters pane in App Studio doesn't change the new parameter to be Dynamic from Static. Is there a way to either delete the parameter from the Parameters pane, or make the unbound parameter Dynamic as opposed to Static?
May 09, 2017, 12:31 PM
eric.woerle
Parameters themselves aren't dynamic/static. Its the element that you attach to the parameter that will be dynamic/static.

what you want to do in your original HTML file is go to the requests tab on the right and find your report request, then refresh your paramaters. It should update accordingly.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
May 10, 2017, 04:21 AM
JazBar
Hi Eric,

That's done the trick!

Thank you very much for your help.

Jason