Hi folks,
For those you you that write SSRRS reports pulling data from Tessitura db stored procedures ... where do you do your calculations? In the Stored Procedure that gives you the datasetor in the Report
I like having most of my numbers counted in the Stored Procedure as it's easier to juggle in my head and plan. But in debugging an old report that is displaying differently in iOS and Android or Windows I'm working with a different style of build where a fair ammount is calculated in the Report (mainly column math).
Interested to hear your preferences.
Heath
Hi Heath,
I hope this finds you well!
I prefer to perform many calculations in the SP rather than the SSRS report. I haven't found any difference in the speed of processing and find it useful when debugging my SP.
It's also a time saver if you have a couple of reports based on the same SP.
Martin
Likewise...
I prefer to have the calculations in the DB especially around upgrade time as the upgrade scripts can usually pick up on where affected tables/columns have been referenced.
Perhaps this also goes back to my loathing of Infomaker and where it was SO much easier to check the SQL if it was in SPs rather than in the PowerBuilder reports 8-)