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; } } }

Providing all option in input parameter

kushal2605

Hi all,
I am using cascading parameters like country, state, city now i wants to allow user to provide all option in listbox. so that he can choose all cities by choosing all option. Please help me.

Find more posts tagged with

Comments

mwilliams

Using "all" as the default doesn't work? What is your BIRT version?

kushal2605

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="98651" data-time="1333655795" data-date="05 April 2012 - 12:56 PM">
Using "all" as the default doesn't work? What is your BIRT version? </blockquote>
NO providing default option as all dosen't work because as soon as i choose state it will be disappear. and i am using birt 3.7.0. 
Thnx.

mwilliams

You may have to find a way to add "All" as a city, in your result set, for all states.

kushal2605

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="98844" data-time="1334157266" data-date="11 April 2012 - 08:14 AM">
You may have to find a way to add "All" as a city, in your result set, for all states. </blockquote>
where i should add the script i.e. like in parameter script i should write script in getParameter or getDefaultParameter or anywhere else..??

CBR

Hi,

the easiest way is to use a UNION in the database select statement like:

SELECT city, state from myTable
UNION
SELECT 'All' as city, state from myTable

kushal2605

<blockquote class='ipsBlockquote' data-author="'cbrell'" data-cid="98918" data-time="1334300278" data-date="12 April 2012 - 11:57 PM">
Hi, 
 
the easiest way is to use a UNION in the database select statement like: 
 
SELECT city, state from myTable 
UNION 
SELECT 'All' as city, state from myTable </blockquote>
 
Thank you very much cbrell. You solved my problem in just 2 minutes. what i was trying to do since last week. 
Thanks again.