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 ...
No, if the ref_no is being passed to the sub from the data set of the main report, it most likely not passing it correctly. I would review your parameter setup for the sub report. Example, of passing values below.
Thanks, Travis!
It is indeed being passed properly:
It works fine in Visual Studio - it is only in Tessitura that the subreport doesn't render. That makes me wonder if there is a step in the Tessiture setup that I am missing.
I have always had to pass the usergroup, company name, requestId, and what to the sub reports too. I will look at one of my news ones, but deploying and parameters are really the only thing.
Hmm ... this is my first time adding a custom report to Tessitura. I was under the impression that company name was only necessary for consortium's.
If you used the default template they're required parameters unless you deleted them. Are they still listed in the report data window in the sub report? Are you sure you're not seeing any odd rending error(s) in the sub report within the studio? Those would be my last guess' and things to check. I would be willing to do a teamveiwer session if you like tomorrow.
Here are two cases:
1. I was lazy and did not delete the default parameters.
2. One where I delete the the default.