In need of some Tessitura friends who have spent WAY more time in SSRS reports than I...
I've copied and altered the canned Performance Seating Book report to fit some additional needs and I have it 97% working in TEST the way we want...BUT for whatever reason, it isn't running the subreport that is supposed to show the parameters used. What am I missing?
Here's the error:
Here are my subreport details:
Thanks in advance!
Madeline Dummerth (Past Member) said:What am I missing?
I would find the sproc associated with the subreport, and run it in its own with Log Viewer running. Save the output, and compare to a run of the whole report. Tedious work, but differences spotted there can be the key to digging below the meaningless surface of "subreport could not be shown".
(I pretty much gave up on copying-and-modifying standard reports years ago, FYI. I usually crib some code from the original and make my own SSRS report for the front end. E.g. you may not even need a composite report.)
Thanks! I've never written my own SSRS report (somehow I find it intimidating??). I started over again and somehow now it's working? *shrug*
Madeline Dummerth (Past Member) said:I started over again and somehow now it's working? *shrug*
Wouldn't be the first time. SSRS is weird. Take the win! :-)
Agreed. There are so many hidden quirks. But at least you can google solutions to some of then unlike infomaker. TLCC ssrs workshops changed my life