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.)
People at my organization are also FAR too used to the "style" (i.e. rigorous efficiency and exactness) that I put on my own custom reports that when I give them a standard report they are like "ugh, make it look better", so I just start everything from scratch these days anyway.
John A. Moskal II said:so I just start everything from scratch these days anyway.
Similar here. As we move away from printing reports on paper (yay!), we seem to be moving away from fancy, formatted reports altogether. Conduits to Excel are the new/old normal (boo!).
Remember when Chuck used to grumble at conferences about Excel being the "bane of his existence"? That bane is alive and well, more so than ever. :-)
Oh yeah. My development department is talking about taking Excel classes; Excel is going NOWHERE. The good news is that, before they do those, they have had me doing a full on 7 part series on List Manager and Output Sets so that they can REALLY learn them, and they have been really good and attentive students, too. So, hopefully at least, there is a marked decrease in the number of "I am having trouble doing this" requests that I get. But yeah; people like their reports so that they can crunch their data... even if they have no idea what they are doing with it.