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
 Development Tools
 Reporting Services Development
 how to insert group ?

Author  Topic 

sunny9
Starting Member

4 Posts

Posted - 2008-04-01 : 22:02:03
My report contains 2 tabs ... 1 tab should contain all columns and the other tab should be grouped and the group has a nested if with all branch names , i have taken 2 resultsets and 1 result set shows all columns and now how can i use the second resultset and group statement together for ex: in group expression
=iif(fields!resultset.value=2,then i want that group statement
(iif(fields!bno=111," ",iif(fields!bno=222," " ......)))))

can any one help with this
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-02 : 04:41:27
You can have a conditional expressions inside edit group tab. just give like

IIF(fields!resultset.value=2,,<your grouping condition>,Nothing)
Go to Top of Page
   

- Advertisement -