Hello friends. I have a table with two columns and I wish to generate a simple report which will have two parameters. It will be a cascading parameter wherein the second drop down box will be highlighted only when I select the first drop down box. However I am new to SSRS 2008 and facing some problems while setting up new dataset queries. I am mentioning the details as follows. Could you please put a light on where I am going wrong. The table structure is as follows : Designer watch_types -------------------- ------------------------------ Tony Timex Tony Omega Jason Rolex Jason Tagheur Jason Ceiko Now I need a report which will have two parameters Designer and Watch_Types. Watch_Types must be greyed out initially and show up values only when one of Tony or Jason is chosen as a drop down option from Designer parameter drop down. Solution: I have created a dataset named "InitialQuery" wherein the query is Select Designer,watch_types from tb_WatchDetails where Designer = @Designer and watch_types=@watch_types second dataset : "Designer" Select distinct Designer from tb_WatchDetails I'm not getting the desired result as I am conceptually unable to understand how many datasets I need and how to write an appropriate query and what values to set for available values(Dataset and value and field and label values for the parameters @Designer and @watch_types). I am new to SSRS 2008 and any help in this regard will be highly appreciated Thanks in advance, Jason J.

Hi Jason, Totally we need to have 3 datasets for this requirement The Report Query would be Select Designer,watch_types from tb_WatchDetails where Designer = @Designer and watch_types=@watch_types The Dataset1 to populate Designer parameter Select distinct Designer from tb_WatchDetails The Dataset2 to populate Watch_Types parameter Select Watch_Types from table where Designer = @Designer You can set the value and label values as same for both the parameters if there is no ID columns available in the query result. Hope this helps you... Thanks M.MahendraPlease click the 'Mark as Answer' button if my Reply helped you to solve your problem! Thanks M.Mahendra

Thanks much M.Mahendra. Worked like a charm. Regards, J