question

jim158 avatar image
jim158 asked

SSRS Calculate diffence between report column values?

I have a reasonably simple report which shows school results for three terms, Christmas, Easter and Summer. I'm trying to calculate the difference in results between terms (per student), but I'm struggling with this one. My first thought was to add some columns to the right, and add calculations which referenced the results boxes. It looks like an easy task when you look at the layout of the produced report, but then looking at it in design mode make this task seem very difficult. Should I instead, re-write the SQL to show 6 separate columns (I know how to do this), and then just base the report on that dataset? Design mode and preview mode screenshots are attached (Names are anonymised). Many thanks in advance :) ![alt text][1] ![alt text][2] [1]: /storage/temp/3593-report9-design.jpg [2]: /storage/temp/3594-report9-preview.jpg
ssrscalculated column
report9-design.jpg (25.5 KiB)
report9-preview.jpg (64.2 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.