Here is the SQl that gives my base data;

SELECT

[Cost] = Sum(Case

WHEN JobInvoiceCostQuery.InvoiceCost >0 THEN JobInvoiceCostQuery.InvoiceCost

WHEN Jobs.JobStatus = 'X' THEN 0

WHEN Jobs.JobStatus = 'B' THEN 0

WHEN Jobs.JobStatus = 'D' THEN 0

WHEN...

I'm sorry but I do not have those things you are asking, I basically have a sql query that gives me;

Period

AssetCategory

Spend

No Jobs

Average (£)

I have 8 periods worth of data, and...

Perfect with the exception of I wouldnt want the time on the end

Thats genius, thanks so much!

My column names are not [2009] and [2010] my column name is PeriodYear and then I have 5000 records for example that are 2009,2010 along with an asset so for...

SSRS R2 2008

Not quite, I want a variance in a matrix type report for 2009 vs 2010 by asset!

Ive tried a matrix

Asset [PeriodYear]

[Asset] [Count)TaskID)]

Total [Count(TaskID)]

But no matter what I do when adding a total it only...

I have Year Field, Asset Field, and Count(Asset) as data, Ie:

Year

...

Can you give step by step instructions, I dont know how to do that!

file attached

I want the percentage of each visit status against each total within the period number ir period 1, period 2 etc

This is my matrix:

...

Even doing COUNT(Fields!TaskID.Value, "dataset1") in a text box gives the same error!