sql server reporting services: Problem InScope in tot Totals (View in Courrier Font for table format) -- sql server reporting services

Problem InScope in tot Totals (View in Courrier Font for table format)

Harry Leboeuf
11/2/2007 12:02:45 PM

sql server reporting services:

Hi,

I'm having a Matrix with 5 RowGroups and 2 (+static) ColumnsGroups

The Rowgroups 1-4 are a kind of dummy groups that always have the same =
value (expression =3D1) so that i can play with the values printed in =
the totals.
I'm having this expression to test my values ..

=3DIif(InScope("MRG_D_1"),

Switch(InScope("MRG_D_4"), "W",

InScope("MRG_D_3"), "4",

InScope("MRG_D_2"), "3",

InScope("MRG_D_1"), "2"

),

"1")

Example Country 1 Country 2

Site 1 Site 2 Tot Site 3 Tot Grand T

Week1 W W W W W 2

Week2 W W W W W 2

Total W W W W W 2

Tot_4 4 4 4 4 4 2

Tot_3 3 3 3 3 3 2

Tot_2 2 2 2 2 2 2

Tot_1 1 1 1 1 1 1

This prints W for the weekly data and the first total, then a countdown =
4 to 1 on the other totals. Working fine at a detail level, in the first =
Colmun Total it still works fine.

But in the grand total column the InScope function goes completelly =
crazy ..

Any Remarks / Ideas / Suggestions

Kind Regards

Re: Problem InScope in tot Totals (View in Courrier Font for table format)

Harry Leboeuf
11/2/2007 1:01:19 PM

For people that want to have a closer look, i've prepared a sample that =
runs without data, just mail to hleboeuf (the-at-sign) kinepolis.com =
and i'll mail you the sample.
[quoted text, click to view]
Hi,

I'm having a Matrix with 5 RowGroups and 2 (+static) ColumnsGroups

The Rowgroups 1-4 are a kind of dummy groups that always have the same =
value (expression =3D1) so that i can play with the values printed in =
the totals.
I'm having this expression to test my values ..

=3DIif(InScope("MRG_D_1"),

Switch(InScope("MRG_D_4"), "W",

InScope("MRG_D_3"), "4",

InScope("MRG_D_2"), "3",

InScope("MRG_D_1"), "2"

),

"1")

Example Country 1 Country 2

Site 1 Site 2 Tot Site 3 Tot Grand T

Week1 W W W W W 2

Week2 W W W W W 2

Total W W W W W 2

Tot_4 4 4 4 4 4 2

Tot_3 3 3 3 3 3 2

Tot_2 2 2 2 2 2 2

Tot_1 1 1 1 1 1 1

This prints W for the weekly data and the first total, then a =
countdown 4 to 1 on the other totals. Working fine at a detail level, in =
the first Colmun Total it still works fine.

But in the grand total column the InScope function goes completelly =
crazy ..

Any Remarks / Ideas / Suggestions

Kind Regards