This is a question for any experienced developers and coders out there. Our system has a custom report. A a part of our upgrade testing, we noticed that some of the numbers didn't make sense. If I run the command code in SSMS as a new query, the numbers are correct...Why would the report in Tessitura give different results than the command code in SSMS? I'm completely stumped.
Joshua,
This is a bit of a complex question, but let us start with some basic things. It sounds obvious, but one of the main reasons a database run could produce different results than a database run is if the inputs you think you are giving it do not match up exactly. You could run a trace to verify that the report parameters are in fact matching those that you are running in the command code in SSMS. If there are any differences, then start there.
If there are no differences, the next step is to check if the data is being weirdly manipulated inside of the report output (e.g. in Visual Studio or InfoMaker).
If you can verify that neither of those two things are happening, that would serve as a good starting point for further investigation.
John
Last time I saw something similar at a friends org... I noticed it was was pulling data from test not live. He was on RAMP and the ssrs connection setup was incorrect. Something to check if you think it applies.