• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

Matrix report - Cumulative data in each Fiscal Year

I have an SSRS report that currently shows transaction data that occurs each fiscal year.  Here is my dataset:

Select ClaimantID, 
'6/30/'+Substring(dbo.GetF<wbr ></wbr>iscalYear(<wbr ></wbr>r.Processe<wbr ></wbr>dDate),6,4<wbr ></wbr>) as ProcessedFY,
SUM(r.ReserveAmount) as TotalIncurred
FROM dbo.Reserve r ( NOLOCK ) 
LEFT JOIN dbo.ReserveType rt ON r.ReserveTypeID = rt.ReserveTypeID

WHERE r.ProcessedDate BETWEEN @FYStart AND @FYEnd

GROUP BY ClaimantID, '6/30/'+Substring(dbo.GetF<wbr ></wbr>iscalYear(<wbr ></wbr>r.Processe<wbr ></wbr>dDate),6,4<wbr ></wbr>)
HAVING SUM(r.ReserveAmount) >0.00

Open in new window


I need to change the report or query (not sure which) to total each FY cumulative.
So If I run the data from FY 2000 to FY2012 then FY will have the data from 2000 and FY 2001 will be a total of 2000 and 2001.

I would REALLY appreciate the experts help on this as I am stuck.  

Thank you in advance!!
Scott
0
Scott Williams
Asked:
Scott Williams
1 Solution
 
Scott WilliamsData AnalystAuthor Commented:
I found the RunningValue formula.  But it seems I can't replace my value in the matrix table with this.  Anybody know how to use this =RunningValue(Fields!TotalIncurred.Value,Sum,"Incurred") in a matrix?
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Try using

Null 

Open in new window


or

Nothing 

Open in new window


instead of

"Incurred"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now