Link to home
Start Free TrialLog in
Avatar of netian
netian

asked on

Can we have dynamic parameters

Hello,
I have a report in which i have a dropdown which contains all the customer names. Is it possible to use another dropdown to control the data for my customer dropdown.

If i can have another dropdown that contains the customer type (Corporate and normal customers)
If i select corporate customer from this dropdown then my second dropdown should display only corporate customers similarly if i select normal customers then it should only display normal customers.

Any help highly appreciated,

Regards,
Mubashir Afroz.
==================
Avatar of CoyotesIT
CoyotesIT

Of course you can.

If you have something in the table that differentiates the two types of customers you can populate the second drop down list.

For this since you have two options maybe a radio button list would work but basically you can construct your query to just include the where clause

i.e.

Form
Corporate   Normal

based on the selection
SELECT (LAST_NAME + ', ' + FIRST_NAME) FROM CUSTOMERS WHERE CUSTOMER_TYPE =  ORDER BY LAST_NAME

populate your drop down list with the results and that should take care of it.


~CoyotesIT
Avatar of netian

ASKER

I cannot use the Forms. As all the reports are being displayed within the default reporting viewer.
So i think it will not be possible to use radio button, because the reporting services only allow textbox,dropdown as parameter input within its viewer.
ASKER CERTIFIED SOLUTION
Avatar of CoyotesIT
CoyotesIT

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of netian

ASKER

Excellent!.. Thanks..it worked, i really appreciate your timely and accurate response.
Cheers.