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
Heath Wilder said:I like having most of my numbers counted in the Stored Procedure as it's easier to juggle in my head and plan.
Agreed. Always in the sproc for the above reasons, as well as troubleshooting. The final output report for formatting only.