Subtotal in Matrix SSRS 2005 - 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)

Subtotal in Matrix SSRS 2005

Author

Topic

SKP
Starting Member

34 Posts

Posted - 2008-06-02 : 07:25:25

hi guys,

I have added a subtotal on a column, but the report shows the total at the end of the report, anyone knows why this is happening?

The structure i am getting is as follows:
C1 C2 C3 C4
A1 B1 Y 0
N 5
B2 Y 3
N 2
A2 B3 Y 0
N 5
B4 Y 2
N 3
Total 20

What I want is as follows:
C1 C2 C3 C4
A1 B1 Y 0
N 5
B2 Y 3
N 2
Total Y 3
N 7
A2 B3 Y 0
N 5
B4 Y 2
N 3
Total Y 2
N 8

The formatting is lost , i wonder if you can understand the structure.

Any help will be appreciated.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-02 : 07:33:37

Its the expected behaviour. If you want intermediate total you need to add the total column on the group footer of added group.

SKP
Starting Member

34 Posts

Posted - 2008-06-02 : 09:26:44

visakh,

i am not able to see the group footer in the designer,
i have got only one matrix , i can right click and i can add the group row but then in properties i cannot see anywhere group footer to add the total.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-02 : 11:07:29

See if this helps:-

http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources