Summing Values from Subreports 1

[Bonediggler1]

Hello -

I am new to SSRS and am trying to do something that is extremely simple in Crystal...but so far seems very obscure in SSRS (at least as far as web based info is concerned):

I have 2 subreports on a main report. The first report sums revenue by month, the second sums adjusments by month. I would like to add a field that sums these 2 by month.

So for example in June Revenue is $10 and Adjustments are -$5. The calculated field will be $5.

How to do this?

Thank you!!

 

[xlbo]

Unless this is a new feature in 2008 I don't believe this an be done

the stock way of approaching this in SSRS would be to have 1 report that has revenue and adjustments with an indicator as to which each is then have 3 tables - one with no filters which will give you your overall sum and the other 2 with a filter on each to filter for either revenue or adjustments...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Bonediggler1]

Thanks Geoff -

This will take some getting used to...

 

[xlbo]

no worries - basic rule of thumb in SSRS is get clever with the SQL to make the reports as easy as possible. There's a fair amount you can do with formatting but data wise whilst the latest version allows you to calc data from other data sets int eh same report, I would always try and get all your data back in 1 block

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question