January 7, 2013 at 8:52 pm
Hi, the subject doesn't exactly explain what I am after so let me explain:
I have a report solution, kind of like a dashboard, but without graphs/charts. In it are a range of small reports (10 in total), each of which has a total. Is there a way to add these totals up and present the user with a "grand" total?
Hope this makes sense.
Thanks
January 7, 2013 at 10:14 pm
Each report has different parameters I would assume (to at least query different data from the database). Why not add an additional query that sums all data being summed be each of the subreports. Just query the database direct for all of that data. with ten different reports, I might even consider a drill down report that queries all of the data for the 10 reports and then let them drill down into the ten different areas (eliminate the ten reports).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 7, 2013 at 10:58 pm
Hi Jason,
Thanks for the speedy reply.
That solution was considered but the problem is that the reason why I have had to split the one report (ie: the end user doesn't see that there are 10 reports... it looks like one report) into 10 reports is that each of the "sub" reports has some fairly complex expressions and hidden columns to get to the output. Simply summing the records would be a very complex process.
I am working through the Code functionality in SSRS and it seems to be the way to go for the moment. It seems like I have gotten it to work with a couple of fairly straightforward functions:
Dim myTotal as Integer
Function SetMyTotal(ReportTotal as Integer) as string
myTotal+= ReportTotal
SetMyTotal = " "
End Function
Public Function GetMyTotal as Integer
GetMyTotal = myTotal
End Function
Then, in the Summary line of each tablix, I have inserted a new expression in the format:
=Code.SetMyTotal( <repeat expression used to calculate tablix total> )
Finally, at the bottom of the Report, I have added a new Textbox with the expression:
=Code.GetMyTotal
Only a couple of minor frustrations - I wanted to set the visibility of the row that contains the SetMyTotal expression to hide, but this stops the process from working (the function seems unable to return the value to a hidden row). So I thought I'd change the function to a subroutine... but I haven't yet figured out how to call a subroutine.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply