Matrix subtotal report problem

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

Matrix subtotal report problem

Author

Topic

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2012-04-23 : 06:38:41

Dear All Experts,

I am facing one problem in SSRS Matrix report.
In row group branch name is coming, and in column group Qty and Value is coming. Now i dont want to show Total in "value" column.
Only want to keep in Qty column.
(Please see the attached snap)

Regards,
AKM

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-23 : 12:04:22

you can set visibility property on value column to hide the value (set hidden property to true)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2012-04-24 : 01:15:42

Dear Visakh,

I am using matrix report and its subtotal coming automatically. How to use visibility property for the same, can you please guide me.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-24 : 01:22:02

you can use Inscope operator for that.

see

http://visakhm.blogspot.com/2010/01/inscope-operator-in-sql-reporting.html

just set an expression for hidden property like

=IIF(Inscope("Matrixcolumngroupname"),False,True)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources