How to generate parameters daynamically

Hey,

I have a quick question. In my current report, I would like to implement a feature to generate the possible values for a parameter dynamically.

For example, user may select a begin date (first parameter) and an end date (second parameter), then the third parameter should be generated dynamically by querying database to fetch all the assets that were purchased during this period of time, and create a new list for user to select.

does anyone has similar experience? please help. Thanks

Find more posts tagged with

Comments

bhanley

Add each parameter you need to the report first. Then open the data set for editing. You can simply add a question mark (?) to your query as a place holder for each dynamic value. Then look at the Data Set parameters (a group on the Data Set properties window) and you will see a parameter added for each question mark in the query. From here you can bind each Data Set parameter to a report parameter. Look at the "Linked to Report Parameter" column.

Good Luck!

temphan

Hey thanks a lot for your reply. But I think your answer is not for my questions. My goal is like this,

(1) user first selects the begin date and end date
(2) then the third parameter in the parameter list should automatically refresh to fetch all of the product names purchased during the begin date and end data
(3) user select a product name, click the ok button in parameter page
(4) then we generate a detailed report about this particular product.

What i really want to implement is the automatically refreshing function to fetch product name from database, any idea? Thanks again

cypherdj

you can achieve what you're looking for with a cascading parameter group, which will perform the refresh based on the selected values of the other parameters in the cascading parameter group.