Do not use on any
shared computer
August 30, 2008 04:39am pdt
 
[x]
Attachment Details

matrix report in SQL Reporting Services

Tags: matrix, reporting, services, sql
Hi,

I am working on this report which is very complicated  and also new to SRS Reporting and had to use two matrices in one report. One is for revenue and one for cost of services, both the reports are displaying the data without any problems, the only problem i have is to calculate the gross profit, mentioned below is the look of the report.

This is how the report looks and has one datset of its own

1st Matrix
                       classA          ClassB         ClassC          ClassD         ClassE
New                      0                   0                    0                      0                  0  
Renew                10                 10                 10                   10                 10
Rev Deff             20                 20                 20                   20                 20
Less Sales          30                 40                  50                   60                 70
Total                   60                  70                 80                   90                100

2nd Matrix and also has a different dataset
                       classA          ClassB         ClassC          ClassD         ClassE
New                      0                   0                    0                      0                  0  
Renew                 10                 10                 10                   10                 10
Rev Deff              20                 20                 20                   20                 20
Less Sales          30                 40                  50                   60                 70
Total                   60                  70                 80                   90                100

Gross Profit     120               140               160               180                200
I want to add this Gross Profit below the second matrix, if you could kindly let me know how do we do this that will be really great and appreciate it,

Thank you very much in advance.
 Thanks Help Much appreciated

Far.

Start your free trial to view this solution
Question Stats
Zone: Database
Question Asked By: farquest786
Question Asked On: 05.04.2007
Participating Experts: 2
Points: 500
Views: 0
Translate:
Loading Advertisement...
 
[+][-]Expert Comment by PFrog

Rank: Wizard

Expert Comment by PFrog:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by PFrog

Rank: Wizard

Expert Comment by PFrog:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by farquest786
Author Comment by farquest786:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by PFrog

Rank: Wizard

Expert Comment by PFrog:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by farquest786
Author Comment by farquest786:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by PFrog

Rank: Wizard

Expert Comment by PFrog:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Author Comment by farquest786
Author Comment by farquest786:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by PATKIRSCH
Expert Comment by PATKIRSCH:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
[+][-]Expert Comment by PFrog

Rank: Wizard

Expert Comment by PFrog:

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
20080723-EE-VQP-34