July 11, 2008 at 10:42 am
I have a report with a LIST that contains 2 subreports. The report returns 83 pages, one for each employee. Everything is fine except for one employee on page 26. It displays one subreport fine but the other displays the error message and I have no idea why. I ran the subreport for that employee on its own and it displays fine. Any ideas? I am going crazy here.
July 14, 2008 at 9:17 am
Can anyone help? I still cant figure this out and need to deploy to production asap.
July 14, 2008 at 11:47 am
Just throwing some thoughts out for you to look at.
What links the reports? Particularly the 2nd sub to the first and the parent report.
When you're running the problematic 2nd sub independently, are you inputting the parameter(s) exactly as they would come from the 1st sub and or the parent?
I know the "Error: subreport could not be shown" isn't helpful at all but sometimes there's more info in the output window at the bottom of VS/BIDS. Anything there?
I realize this isn't much help but I hope it helps a little.
toolman
[font="Comic Sans MS"]toolman[/font]
[font="Arial Narrow"]Numbers 6:24-26[/font]
July 14, 2008 at 12:07 pm
Both subreports get parameters from the parent report. The 2nd sub receives 4 parameters and yes, when i run it independently, i am passing the exact values from the parent. What is weird is today when i re-ran it, it now errors on 10 employees instead of one.
The message in the Output window is...
Build complete -- 0 errors, 0 warnings
[reErrorExecutingSubreport] An error occurred while executing the subreport 'subreport2': An error has occurred during report processing.
[rsNone] Query executin failed for data set 'Calculations'.
Preview complete -- o errors, 1 warnings
July 14, 2008 at 12:49 pm
is250sp (7/14/2008)
Both subreports get parameters from the parent report. The 2nd sub receives 4 parameters and yes, when i run it independently, i am passing the exact values from the parent. What is weird is today when i re-ran it, it now errors on 10 employees instead of one.The message in the Output window is...
Build complete -- 0 errors, 0 warnings
[reErrorExecutingSubreport] An error occurred while executing the subreport 'subreport2': An error has occurred during report processing.
[rsNone] Query executin failed for data set 'Calculations'.
Preview complete -- o errors, 1 warnings
I take it that dataset Calculations populates your 2nd sub, correct?
What happens if you try to execute the query for Calculations in the Data tab?
Could you post your SQL code for that dataset?
Is this the same report you were having performance issues with that Nigel helped you with?
[font="Comic Sans MS"]toolman[/font]
[font="Arial Narrow"]Numbers 6:24-26[/font]
July 14, 2008 at 1:54 pm
Yes, this is the same report Nigel was helping me. As a matter of fact, I took his script, reworked it to join to the parent dataset so I wont have to use a 2nd subreport and now it seems to be displaying everything. Thank you all!
July 14, 2008 at 1:57 pm
Excellent!! The fewer subreports the better I always say.;)
[font="Comic Sans MS"]toolman[/font]
[font="Arial Narrow"]Numbers 6:24-26[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply