Hiding Subtotal in Matrix -- sql server reporting services

sql server reporting services : Hiding Subtotal in Matrix

Bruce Johnson [MSFT]
7/15/2004 11:46:22 AM

You will need to control the Visibility of the textboxes that makeup the
column by using an expression similar to
=iif(InScope("MatrixColumnGroupName"), false, true).

The scope portion of the Inscope() can be the name of a DatasSet, Grouping,
or DataRegion.

--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Chris Hays [MSFT]
7/15/2004 11:54:00 AM

There's no good way to do this in the current version.
But for a sleazy hack workaround, take a look at my reply on the thread from
yesterday titled "Matrix SubTotal"

--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
[quoted text, click to view]

Samuel
7/15/2004 6:50:41 PM

Hi,

I have one column group and 3 columns under it in a matrix. I added subtotal
to that column group and now all the 3 columns are summarized and shown. Now
I want to hide one column summary(The other 2 column summary should be
shown). How to do that?

TIA,

Sam

Samuel
7/16/2004 10:19:50 AM

Hi Chris and Bruce,

Thanks - It works

Samuel

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn