As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
I need to do create a HTML with two graph element where each graph call the same procedure X (reference existing procedure). The procedure X receive one parameter. I could create a hidden value to pass to X using the composer. But, what I couldn't do, was create two different hidden values to pass to the two distinct graph element. As the procedure has one parameter, the same hidden value is passed to all procedure calls, even though each chart needs its own value.
Is there a way to differentiate hidden variables to each procedure call in the same HTML page?
ChristianThis message has been edited. Last edited by: <Kathryn Henning>,
yes you can do this. The simplest and easiest way to do this is to make sure that your variable in each report is unique between them. say &var1 and &var2. When using the HTML composer it should prompt you whether you want to create an input for each one. Just select both of them to hidden and you should be good to go. Also, you can add new input elements to the html and using the parameter tab in the html composer, you can associate those hidden inputs to variables in your report. If you are new to this process, I would recommend using the tool for as much of this as possible as there is a lot of xml that gets generated and if you don't understand what is going on with the xml, it is very easy to break things.
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 22.214.171.124
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013
Hi Eric. I think the situation you described is not the same as mine.
There is only one HTML page with two Graph element. Each graph reference an existing external procedure. The external procecure receive the parameter X. I can create a hidden variable to set the parameter. When i do that, the two procedure call booth receive the same value. I couldn't create two hidden variables to set two different values to the two different procedure call.
Another thing you could do, if you look at the FORM call, you will see the OnExecute(this) command in the OnSubmit. You could call a function in the OnSubmit of the FORM that updates the input before it fires off the execute function. That would be another way do it.
here is an example of an anchor tag where I do that. The FORM element should have something similar in the onSubmit you can change.
The composer creates just one OnSubmit function (as it creates just one form with one hidden variable even I having inserted two graph element). So, there is only one execution of the OnSubmit and how can I make distinction of values passing to the first procedure call and the second?
The composer only creates two forms with two buttons when I choose the option "do not create controls" in the "reference existing external procedure" dialog box. But in that case the hidden variables are not cretaed.
This way will work. The problem is that I will have several HTMLs each calling the procedure several times. What I precisely whant to avoid is have to write to many procedures to treat this issue. Something like two forms with two hidden variables submiting twice to the same procedure. But seems that I won't have other option.