Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Deepak1983
Starting Member
23 Posts |
 Posted - 2010-12-27 : 05:38:02
|
I have ten types of categories in one column. In which one category named as "Open". I have added parameter where I can see records which are either Open or ALL the records. I named parameter as "Is Open" with two values ALL - "A" and Open = "O"Now I am going into dataset in Filters tab. Filters has three columns in it. Expression where i selected =Fields!Category.ValueSecond one is Operator , I selected "Like" and third one is Value where I write one expression =IIF(Parameteres!IsOpen.value="O","Open",Nothing) -- by nothing I mean I want all the records, but in practical it is not helping me out.so here I need your help. I dont want to write all the 10 Categories name into my IIF expression.what can be the solution? Deeps |
|
|
Deepak1983
Starting Member
23 Posts |
Posted - 2010-12-27 : 12:02:19
|
| Answer is :- Under Filter Tab For Expression click on fx -- Type =IIF(Parameteres!IsOpen.value="O",Fields!Category.Value,Nothing)The under Value type = IIF(Parameteres!IsOpen.value="O","Open",Nothing)How this works is --If you Select 0 in parameters it will opt to filter on Fields!Category.Value or else NothingDeeps |
 |
|
|
|
|
|
SSRS Reporting - Expression Related Query