Hello,
I am trying to get my (first ever) report running in Tessitura. The stored procedure is fine. The report previews in visual studio just fine and looks as I want it to.
I built the report in Tessitura only to get an execution error:
Has anyone encountered this before? I set permissions to be the same as other reports. And as I said the SQL code is fine so I'm at a loss. I tried to track down the error on the report server (as per the error message) but I couldn't find log, or I don't have permission.
For what it's worth I am very new to Tessitura. I've attached a screenshot of my setup in Tessitura, in case that comes into play (apologies for quality, hopefully it's legible).
Thank you for any help or leads you can provide,
Ian
Not sure if this might be the issue but have you granted execute permissions on the stored procedure for imp users?
Hi Thomas, thanks for your reply, but yes imp users have execute permissions for this SP. 'tessitura_app' also has execute permissions.
Are your SSRS Names (far right column) exactly matching what you have in SSRS (Visual Studio)?
Hi Heath, yes, they are cut off in my image but they are 'season' and 'perf_no'. In Visual Studio and SQL they are of course prepended with @, but I don't think the symbol needs to be in Tessitura.
If you have @ in the name of your Visual Studio datasets field name then you may need it in the SSRS Names column as it needs to match exactly as Heath mentioned.
Sorry that was unclear, I was referring to my parameter names, which start with @ in SQL, and this seems to automatically carry over to the parameters in Visual Studio when I add the dataset/stored procedure. My dataset field names do not have @ at all.
Back to troubleshooting...
Okay it's working now. Your suggestion(s) to check the variable names helped. I think the problem was that I had a field and a parameter with the same name (perf_no). I changed the parameter to perf_num and left the field as perf_no, and now it's working.
Thanks for helping me see that,
Congrats!