nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to skip second param based on first param value?

Mani Kandan

I am designing a report, in which i have two parameters such as country and state. I need to give "select all" option in country, so if user select this all option, then without selecting a state the report should be executed.
 
I have tried by creating cascading parameters with multipledataset, but after selecting the first param an ajax is passed to get second param inputs, so i need to avoid this ajax if user choose "select all" option, can we do this way for my problem?
or any other way to do this?

Find more posts tagged with

Comments

micajblock

Check this out <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1068-simple-example-of-select-all-parameter/'>http://developer.actuate.com/community/forum/index.php?/files/file/1068-simple-example-of-select-all-parameter/</a>

Mani Kandan

actually i have two param, country and state, if user choose all in country list i need to show all country and so that the state param should not be shown, if user select any country i should show state param to select state..
so how to disable another param based on a param value.

micajblock

What version of BIRT?

Mani Kandan

BIRT version is 4.4.2.

micajblock

Attached is an example using Classic Models. Hope this helps.

Mani Kandan

Mr.Block, i have two parameters, and also i would like to skip second param if the user choosing "all" for first param.But the report you have given has a single param.Please help me , how can i avoid second param when a use choose "all" from first parameter list.

micajblock

My report has 2 parameters. Just set the default of both parameters to 'All'

Mani Kandan

I can see only one report parameter named as "office" only in your report, but i need to have two report parameter that should be cascaded, because second parameter depends first parameter value, so if first reportparam is chosen to all, then second should be avoided.

micajblock

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="138235" data-time="1438729672">
<div>
Attached is an example using Classic Models. Hope this helps.
</div>
</blockquote>
In this post I changed it so it uses 2 parameters. Here it is again.

Mani Kandan

yes it solves the problem and the report <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?app=core&module=attach&section=attach&attach_id=12056' title="Download attachment">Cascade All.rptdesign</a> has two parameters.
 
The expected solution i got from your report is here,
 
setting default value to 'All' in both parameters, so when user just click "ok", so 'All' is the selected(default) value for both parameters, so it matched with the query params. In query itself has the real solution for my problem.
<pre class="_prettyXprint _lang-sql _linenums:1">
select country,city,customername
from customers
where (('All' = ?) or (country = ?))
and (('All' = ?) or (city = ?))
</pre>
so when a param has 'All' selected, then it should become the boolean because('All'='All'). so the query becomes ,
<pre class="_prettyXprint _lang-sql">
select country,city,customername
from customers
where true
and true
</pre>
so it shows all customer details,.I think this is the scenario where i have failed to think.
 
Mr.mblock please correct me if i am wrong.

micajblock

No you are not wrong.

Mani Kandan

Thanks mblock.