I have three dropdownlists list1,list2,list3. My list1 selection is compulsory. Here I have two cases: case 1: I should allow null values in list2 and list3 and generate all the values of list2 and list3 which belong to the value selected in list1. I am able to allow null values but unable to generate report which displays all the list2 ,list3 values which fall under list1 case 2: if someone selects list2 i should make list3 as compulsory field. How can I do this. Please help me and I am new to SSRS Thanks a lot SandyNever frown, even when you are sad, because you never know who is falling in love with your smile.

Hi Sandy, I'm unable to understand your Case1 senario, Can you please elaborate it ( if possible with an example ). For your Case2, you can try this:- 1. Create a List2 & List3 based report level paramater. 2. Assuming below query for List2 to bring dropdown values:- SELECT ST FROM List2Table 3. Now your List3 values should bring up values something like below query:- SELECT ST FROM List2Table WHERE ST = @List2 Note:- Assuming List2 is the name of the report parameter for dropdown list2. Please let us know your feedback. Thanks KumarKG, MCTS

Hi Sandy, I'm unable to understand your Case1 senario, Can you please elaborate it ( if possible with an example ). For your Case2, you can try this:- 1. Create a List2 & List3 based report level paramater. 2. Assuming below query for List2 to bring dropdown values:- SELECT ST FROM List2Table 3. Now your List3 values should bring up values something like below query:- SELECT ST FROM List2Table WHERE ST = @List2 Note:- Assuming List2 is the name of the report parameter for dropdown list2. Please let us know your feedback. Thanks KumarKG, MCTS

Hi Sandy, For case 1, we can achieve the requirement by modify the dataset query. For example, if the original query is like SELECT ProductName, Color, SizeRange, Class FROM DimProduct WHERE (Color = @color) AND (SizeRange = @size) AND (Class = @class) We can modify it to SELECT ProductName, Color, SizeRange, Class FROM DimProduct WHERE (Color = @color) AND (SizeRange = @Size) AND (Class = @class) OR (Color = @color) AND (Class = @class) AND (@Size IS NULL) OR (Color = @color) AND (SizeRange = @Size) AND (@class IS NULL) OR (Color = @color) AND (@Size IS NULL) AND (@class IS NULL) After that, if we check allow null for both the Size and Class when execute the report, the query will all product under the specified Color. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.