reporting services matrix subtotal

I have a matrix and have used the switch function to select the measure group that is displayed (based on selecting a report parameter). All works fine except the subtotal only shows the first row data.

e.g.

2005

2006

2007

Sales

Sales

Sales

a

2

2

2

b

4

4

4

c

6

6

6

TOTAL

2

2

2

The switch function used to select the measure is:

switch(Parameters!Measure.Value="Gross Sales",Fields!GrossSale.Value,Parameters!Measure.Value="Net Sales",Fields!NetSale.Value,Parameters!Measure.Value="Sales Quantity",Fields!SaleQuantity.Value,Parameters!Measure.Value="Sales Rebate",Fields!SalesRebate.Value)

Any idea why this would happen?

Thanks

Looks like you're not aggregating the applicable measure - how about trying this modified cell expression:

switch(Parameters!Measure.Value="Gross Sales",Aggregate(Fields!GrossSale.Value),Parameters!Measure.Value="Net Sales",Aggregate(Fields!NetSale.Value),Parameters!Measure.Value="Sales Quantity",Aggregate(Fields!SaleQuantity.Value),Parameters!Measure.Value="Sales Rebate",Aggregate(Fields!SalesRebate.Value))

|||

Deepak,

Thanks for your help.

all is fine now.

Reporting Services Installation.

We are installing Sql Reporting Services 2000 Evaluation Edition. During the
setup we are selecting the Remote Sql Server Instance (On the same network
and it is an enterprise edition) as the Reporting Server Database. Locla
system has IIS and ASP.NET installed, so it will be used as Report
Server/Manager. Doing so we are getting the following error during
installation:
Cannot access Sql server on instance ("Instance Name")
Login Failed for ("NT login name"). We are providing Sql login credentials
which has full permissions to create database on the remote sql instance.
What is the issue here. Any help will be of great use!!!Setup uses the user running setup to talk to the DB server during setup.
This user must have sa privileges. If you want you can use command line
arguments to have setup use SQL auth instead. These are documented in the
template.ini file.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"sqlchat" <sqlchat@.discussions.microsoft.com> wrote in message
news:17E31891-3D13-4F49-A109-E44538D6CC49@.microsoft.com...
> We are installing Sql Reporting Services 2000 Evaluation Edition. During
the
> setup we are selecting the Remote Sql Server Instance (On the same network
> and it is an enterprise edition) as the Reporting Server Database. Locla
> system has IIS and ASP.NET installed, so it will be used as Report
> Server/Manager. Doing so we are getting the following error during
> installation:
> Cannot access Sql server on instance ("Instance Name")
> Login Failed for ("NT login name"). We are providing Sql login credentials
> which has full permissions to create database on the remote sql instance.
> What is the issue here. Any help will be of great use!!!