InScope Function help - SQL Server Forums

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 2005 Forums

Analysis Server and Reporting Services (2005)

InScope Function help

Author

Topic

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-10-07 : 09:08:58

I read through the tutorials that I have found here regarding InScope but I was trying to get the "full" definition of what it can be used for. Unfortunately even the MSDN page is pretty much useless. The one I found is:
http://msdn.microsoft.com/en-us/library/ms156490(SQL.90).aspx
It is maddening that this is all Microsoft uses to describe.

Is there a better description of using InScope? I have tried the example from another blog:



=Iif(InScope("matrix1_ColumnGroup1"), 
Iif(InScope("matrix1_RowGroup1"), 
                                "In Cell", 
                                "In Subtotal of RowGroup1"), 
            Iif(InScope("matrix1_RowGroup1"), 
                                "In Subtotal of ColumnGroup1", 
                                "In Subtotal of entire matrix"))

I am just trying to understand how (and why) it works for both Totals/Sub-Totals but also as the MSDN example of calling another report.

John

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources