keshav_nitrkl (1/23/2015)
Hi ,My report is having three fields : NAME || Level || ID .I have a single dataset and a filter to my dataset. The dataset filter should work like , if ID = 101 is selected show only LEVEL=30 students, if ID 102 is selected show students of LEVEL= 1,2,3 . The first scenario works but the second doesnot
🙁
i would like to achieve something like :
Filer on Filed ID
=iif(Parameters!ID.Value=101,"30",
iif(Parameters!ID.Value=102,"1" or "2" or "3",
Parameters!ID.Value))
As mentioned you should work this logic into your stored procedure or embedded query, rather than in the report itself. It is more efficient that way. If you have test data to play with then I can illustrate better.
----------------------------------------------------