composing report on recovery aging

[raiders12]

hello,
I am composing a report to calculate the dollar amount of recovery. I have a dataset in detail level. My user want a report that groups by month and year of the transation date (rows),columns we need the dollar amt for : 0 - 30 days recoveries, 31 - 60 days recoveries until 365 days recoveries...

My question is can I just use different grouping to calculating the column values?? I have not problem to write scripts in sql like stored procedures to get the report done but I want to know what can I do within the reporting service to do finish the report. I don't know if I gave out enough information. Please let me know if there is more information needed. I am using sql 2008.

thank you for any inputs and suggestions.

 

[Crowley16]

sorry, I'm not clear on exactly what you are trying to do...

so you have something like:

Date Amount
10-01-01 5
10-01-02 7
10-03-05 6
...

and you want to convert that to:

Jan Feb Mar
12 0 6

is that correct?
If so, then it is possible using a matrix, but you'd need to work out the date range periods beforehand.
However, I'd just re-write the base query to extract the data in this format, a pretty straight forward pivot would do it...

--------------------
Procrastinate Now!