Using drop down to toggle between reports

<p>The solution that [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Michael Williams provided in a previous post ([/color]<a data-ipb='nomediaparse' href='http://www.birt-exchange.org/forum/index.php/topic/24443-refresh-table-on-click-of-button/'>http://www.birt-exchange.org/forum/index.php/topic/24443-refresh-table-on-click-of-button/</a>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]) is a great solution, but my particular situation involves connecting to TRIRIGA and that does not allow me to create data sets using SQL and replicating Michael's solution.[/color]</p><p> </p><p>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]I am trying to develop a report where I have two crosstabs that present data in different currency values. I want to create a drop down with hardcoded values (different currency conversions: USD, YEN, EURO, etc.) that are passed to a parameter. Using the visibility property in each crosstab, I want to show/hide based on the selection made in the drop down.[/color]</p><p> </p><p>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Being brand new to BIRT, I am struggling with creating a drop down list using html. The other challenge is how to pass that selected drop down list item to a parameter so that I can show/hide crosstabs. I think that if I can create the hard coded values correctly in html, then I can reuse that code that Michael has provided that re-runs the reports based on the selection.[/color]</p><p> </p><p>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Many thanks![/color]</p><p> </p><p> </p><p> </p><p> </p>

Find more posts tagged with

Comments

mwilliams

<p>All my example does is dynamically create the drop down values. With static values, you would just need to create the static html drop down list and the rest of how to pass the parameter could be the same.</p>

derf08

<p>so i replaced some of the content of your original script and it looks like this:</p><p> </p><div><script></div><div>function runReport(value){ </div><div> </div><div>window.location = "<a data-ipb='nomediaparse' href='http://127.0.0.1:61320/viewer/frameset?__report=C:\Users%user\Desktop\BIRT+samples\ListBoxParameterInReport.rptdesign&__format=html&__svg=false&__locale=en_US&__timezone=America/Chicago&__masterpage=true&__rtl=false&__cubememsize=10&__resourceFolder=C:\Users%user\Desktop\BIRT+samples&__dpi=96&24875668&Currency='>http://127.0.0.1:61320/viewer/frameset?__report=C:\Users%user\Desktop\BIRT+samples\ListBoxParameterInReport.rptdesign&__format=html&__svg=false&__locale=en_US&__timezone=America/Chicago&__masterpage=true&__rtl=false&__cubememsize=10&__resourceFolder=C:\Users%user\Desktop\BIRT+samples&__dpi=96&24875668&Currency=</a>"+value; </div><div> </div><div>} </div><div> </div><div></script> </div><div>Select Currency: </div><div><select onchange="runReport(value);"name="drop1" id="select1" size="1"> </div><div><VALUE-OF format="HTML"> </div><div><select></div><div> <option value="USD">USD</option></div><div> <option value="EURO">EURO</option></div><div></select></div><div></VALUE-OF> </div><div></select> </div><div> </div><div>I created a report parameter called "Currency" but when I run the report the drop down appears but the report visibility doesn't work as intended and the drop down values disappear. I've never touched HTML so I wouldn't be surprised if my syntax is all off.</div>

mwilliams

<p>So, what you're wanting to do is to simply have a static list that the user selects from to decide which crosstab they see? If so, what's your BIRT version? I'll create you a simple example.</p>

derf08

<p>Exactly! Using the visibility property to drive what crosstab to show based on the drop down selection.</p><p> </p><p>I'm using BIRT 2.6.2</p><p> </p><p>Thanks!</p>

mwilliams

<p>Dropping the crosstab from the design would make the report faster. Is that okay, too? The only reason you'd need both to run is if you wanted to do the swapping on the client-side without rerunning the report. Let me know.</p>

derf08

<p>I have to keep the cross tab reports based on requirements. The situation is that they "prefer" a drop down that would allow them to see the same report in different currencies. So my thought is that by creating multiple cross tabs and using the visibility function would be faster in terms of development hours and easier to implement than attempting to customize the report due to the limited experience I have with BIRT. In the end they will be only toggling between 3 currencies so I would only have 3 cross tabs. Performance is a great concern you bring up and something I'd have to address after I can determine if toggling is the way to go.</p><p> </p><p>Thanks!</p>

mwilliams

<p>For performance, dropping the unwanted crosstabs from the report based on the parameter would be the best, unless someone who runs the report will definitely be switching between all currencies after running the report. In this case, toggling the visibility client-side would probably be the best. Let me know.</p>