Cascade Params

Is there anyway to create a simple drilldown param list? I noticed cascading params group, but can't get that to work for it. It has to be very simple. First dropdown gets list from dataset, second dropdown the same but it has to filter based on the first ones selection, and the third drop the same.

Is there anyway to do this using BIRT's params or do I have to create a PHP page before I launch the report?

Find more posts tagged with

Comments

mwilliams

Hi jfreak53,

A cascading parameter from within BIRT should do this fairly easily. What issue are you having with doing it that way?

jfreak53

Hmm, well I created a cascade param group then added two dropdowns and linked them to two datasets I created. But I couldn't get dropdown number two, call it grade, to only show DB items that have IdSC_Car from dropdown one, or call it Career. Do I have to add a "WHERE IdSC_Car = param1" Or something else?

Maybe you could walk me through it, I tried to find things on the documentation but couldn't find anything regarding cascading dropdowns from two different datasets. I've also searched this same term on Google and this forum and though I found a lot of things, none have regarded what I am trying to do.

I've got my reports doing some of what I need, like changing DB name from a param I pass it in the URL and other such things. But I would rather do a param window than to have my PHP script before the report comes up.

Thanks for any help.

jfreak53

Never mind I finally figured it out ha ha 
 
Here's what I did, tell me if I did it right. 
 
I created a cascading param group with two dropdowns and I then created two datasets. The second dataset grad I didn't filter at first, I just let it select all. Then on the beforeOpen sequence of the dataset grad I put this: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>if (params["cars"].value > '') {
this.queryText = "select IdSC_Grado, CONCAT(Codigo,' ',Nombre) AS Nombre, IdSC_Carrera from sc_grado WHERE IdSC_Carrera = " + params["cars"].value;
}</pre>
 
Which now filters based on that param and everything works great. Thanks for the help.

mwilliams

Not a problem. Always glad to help!