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
Thanks all. I really agree. It was column math that was a capacity % that is failing on iOS. Even then I'd prefer to build it in sproc
Martin Keen (Past Member) will likely know the work I'm looking through ;)