SSRS 2005 Matrix Total column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » July CTP » SSRS 2005 Matrix Total column

SSRS 2005 Matrix Total column

Rate Topic

Display Mode

Topic Options

Author

Message

yheon_17 66014

Posted Monday, December 06, 2010 6:47 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, January 30, 2011 10:07 PM
Points: 4, Visits: 61

Hi,

I need help on using SSRS 2005 Matrix. I need to add the last 3 columns. Kindly refer on the diagram. Thank you very much.

Country Year
2001 2002 2003 2004 Total for last 3 Years
USA 12 5 3 4 12
CHINA 12 2 2 6 10
BRAZIL 12 1 7 8 16
SPAIN 12 3 4 4 11

Thanks,
Perry

Post #1030962

kamal.agarwala

Posted Tuesday, December 14, 2010 1:43 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, January 02, 2013 6:07 AM
Points: 12, Visits: 21

Hi,

As per my knowledge you can do it by two ways
1. from databse script where you write the storeprocedure.
2. you have to write the code for this in ssrs in which you will explictly add 3 columns only.

Post #1034236

yheon_17 66014

Posted Wednesday, December 15, 2010 8:48 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, January 30, 2011 10:07 PM
Points: 4, Visits: 61

Hi Grasshopper,

Thanks for your reply. Is there a way to this in SSRS 2005 with out doing it in Strored Proc?

Thanks,
Perry

Post #1035617

« Prev Topic | Next Topic »

Permissions