Filter on specific value of Group value.

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.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Filter on specific value of Group value.

Author

Topic

sachya45
Starting Member

25 Posts

Posted - 2011-01-31 : 17:01:53

Hi,
I have a group created for each processor in the system.
Now what i want is if processor ID =0, i want to filter the records of particular status.

so my Group expression is =Fields!ProcessorID.Value
so when i go for filter setting in group properties,
i try to give expression with IIF(Fields!ProcessorID.Value=0,"Filter this",Nothing)
Please help me how can i make this work.

Thanks for help in advance

sachya45
Starting Member

25 Posts

Posted - 2011-02-01 : 09:57:08

Please help,
How can I put filter for only one particular group value.
I have group identified on single field.
Ex. I have a group on ProcessorID
ProcessorID could be any Integer No.0 to 1000

Now what i want is In grouping,only for ProcessorID=0
I want rows of certain StatusID's
EX: IIF(ProcessorID=0, Include (StatusID=2 OR StausID=3), Nothing)

Please help how can I do this in my SSRS 2008

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources