I worked on a report/letter in visual studio, that has a sub report in it. I am able to run the report just fine is visual studio - main report renders and so does the sub report - but once I add the report/letter to Tessitura (via Reports and Utilities --> New Report) the report/letter runs but the sub report doesn't render, almost as if it doesn't even exist. Both the main report and the sub report have been deployed from visual studio to the reports location.
Any thoughts?
Ashley
Just to start with (because I'm not super great with SSRS). I assume you've built and deployed it to Live/Test since you've added the sub report (This happens to me on occasion). Is there a parameter the sub report relies on that is not getting passed on in the Tessitura setup?
Yes they were both deployed. There is a parameter that is only being used by the sub report (ref_no). That value actually comes from the data set of the main report. Do I need to add ref_no as a parameter in the report edit screen?
I wouldn't think so as the parameters sub report doesn't BUT because it's dependent on data ...