Hi. I am fairly new to reporting. I have a report that currently displays queried data in both a table and a matrix. I'd like for the data that is displayed to be based off of my report parameters. I have three, all of which are multivalue. Currently, I am able to display the report, based on the only the first value of TWO of the three parameters. I tried using the dataset parameters, but was not successful with linking them to my report parameters. Please help! In addition, is there a way to setmultivalue parameters to only display distinct values? Thanks, in advance, for any help.

Couple of things: 1. When I use multi-valued parameters, I usually base them off of a dataset and I have my dataset return 'distinct'. Not sure how you are doing it, but look into that. 2. When you are using multi-valued parameters, are you calling a Sproc or is the sql in your dataset? If you are calling a Sproc, you need to make the parameter type a string and have your Sproc extract the values. There are lots of threads in this forum about how to do that. Good luck. Mike

Starting with your last question, Yes! you can display distinct values in your multivalue dropdown parameter. Use Group by in your sql query. For cascading parameters, it is a good practice to create separate datasets for each parameter. 1st parameter would be a simple query which will fetch distinct results from a table. 2nd parameter would be a query which selects distinct col with a where clause . Select.... Where parameter1 IN (@parameter1) 3rd parameter Select.... Where parameter2 IN (@parameter2) Right click on parameter dataset, go to Available values in left pane & bind the value & name field with the col that you have used in select query. I hope this helps. Thanks.-Nitin Pawar

This is an old post, but still of interest. A workaround was used at the time, but I will go back and explore this. Thanks!!