February 14, 2020 at 4:47 pm
Hi,
I have produced a report in report builder. During the month the report runs ok, however when
the report crosses into a new month e.g. January to February, it seems to split on the number of referrals whereas it should be a total number.
Within my SQL code it shows the split with the Year-month.
See example attached.
In report builder template my number of breaches is a summed and so is the reason for breach.
I have tried to sum my number of referrals but it is giving me 17 as the top line and then 184 as the bottom.
Are there any expressions I can use to give me the correct sum for both rows which would be 63
Thanks.
February 15, 2020 at 12:58 pm
I only have limited SSRS knowledge but it might help me or someone else help you if you could show your SQL code?
From your comment "Within my SQL code..." it sounds like the problem might in that SQL.
February 27, 2020 at 8:37 pm
You have a grouping that is segmenting the data by number of breaches
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply