Ok I am new to SSRS 2008 took a course last month and finally got a chance to start working on reports. I am creating eports off of a cots system CRM Dynamics, the issue is I based my dataset on a view. The reason view displays the ;abel to the numberic value of a customized from from an entity. So 1 - email, 2 -phone 3 - letter when I try to set a parameter to show a list of values, it brings back the list of values (of the actual data) rather than just EMAIL, Phone, Letter. So each value of each record is showing , also it doesn't matter what value I select when I run the report it shows me all the data. If I select email I just want to qualify the data that are associated by email, same with phone or letter. Not sure what I'm doign wrong.

Try following Go to Report parameter property Go to Available values Select the label field, label field is what going to be shown on you report, value filed is what will be pased when you select a label. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi Gaurav Gupta, This worked well, thank you so much. It does pose another issue that I need to think about. Unfortunatley this means I am hardcoding the list of values in the report. so if any changes in the list of values are done in the system, those changes have to be reflected in any reports based on those values. unless... if I generate a view (my own independent view) that will give me my full list. Can I somehow in the parameter properties use that list from my own view to qualify the query of the data being pulled? do you think this is possible?

I am not sure what exactly you are asking, but if you have a view you can use it in parameter data set, and than configure you parameter to use your view, int hat case when ever if you change values in your view it will automatically reflect in your Parameter as long as you are not creating a new column and want that column in parameter. PS Marked as ANS if it helped you. Thanks.Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

thank you Gaurav, sorry I am new to this forum. I have marked it as answered. I guess my question is aside from creating a view. You're example showed me how to add static values and being used them as a list of values for the paramaters and run the report against them. How would I set it up if I wanted to pull the list of values dynamically from a view? For one thing I imagine i need to include the view in the dataset, and I would need to adjust teh paramater properties somehow?

ok, Create a data set, with DB where you have view SELECT * FROM YourView Suppose this out put ColumnA ColumnB 1 Email 2 Phone Now Go to parameter properties --> Available Values--> Select Data set As you have created, and than select value field as ColumnA, and Column B As label Field, value filed is one which is going to pass and Label filed is one which is going to display in Parameters drop down. Thanks....... PS mark ANS if helped. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/