SSRS 2008 Subreport changes parent report
I am running into a strange problem in SSRS 2008. I have a report that is in the form of two page summaries: Lots of manual field layout, two pages of information per row in the initial dataset, a list of projects.
I created two other reports to use as sub reports which both take a single parameter from the "parent": the first is simply a chart. This works fine.
The second is a list of key tasks for the project. When I add this subreport to my report, some of the data fields on the parent disappear. Not all fields: maybe half. Static text fields continue to show fine. The fields that disappear are consistant, but I can't figure out what they have in common.
If I then remove the sub report, the data fields show up fine. The subreport causing the problems shows up fine, and is not in the same rectangle, but these are all in a row in a Tablix.
I tried changing the names of most of the elements of the sub report, thinking there might be a name conflict of some sort.
No error messages. This happens both with in Visual Studio, and running from the report server.
Where can I look to identify the problem? or what can I change to get both the sub report and the data to display?
I have a suspicion that my next step should be SQL Profiler, but I'd love any advice or pointers...
Thanks....
James Fraser
I created two other reports to use as sub reports which both take a single parameter from the "parent": the first is simply a chart. This works fine.
The second is a list of key tasks for the project. When I add this subreport to my report, some of the data fields on the parent disappear. Not all fields: maybe half. Static text fields continue to show fine. The fields that disappear are consistant, but I can't figure out what they have in common.
If I then remove the sub report, the data fields show up fine. The subreport causing the problems shows up fine, and is not in the same rectangle, but these are all in a row in a Tablix.
I tried changing the names of most of the elements of the sub report, thinking there might be a name conflict of some sort.
No error messages. This happens both with in Visual Studio, and running from the report server.
Where can I look to identify the problem? or what can I change to get both the sub report and the data to display?
I have a suspicion that my next step should be SQL Profiler, but I'd love any advice or pointers...
Thanks....
James Fraser
ASKER
Yeah, a lot of us james fraser's around. I'm a James B Fraser. (Just after your brother?)
I've moved the sub report to other spots within the tablix, tried top and bottom of the cell that I'm using. No change. I've also deleted and recreated (several times) the sub report element in the parent report.
James Fraser
I've moved the sub report to other spots within the tablix, tried top and bottom of the cell that I'm using. No change. I've also deleted and recreated (several times) the sub report element in the parent report.
James Fraser
ASKER
And I just tested creating a sub report outside of the tablix of the parent. The data fields all show correctly then, but my subreport isn't helpful, since it's only included once, not once per dataset element.
jf
jf
Is it at all possible your running into some sort of duplicate data issue with only using the one parameter?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I don't get any error message, just empty cells. I'm attaching screenshots. I've cut out _a_lot_ of the fields, so that we can focus on a single field that isn't working. I also grayed out client and personal information.
One screen shot is of the design view: you can see where the two subreports are.
The next shows what happens when I run with the bottom subreport included. The third shows what happens when I delete the subreport item. The red circles were added in MSPaint.
Design.jpg
WithSubreport.jpg
withoutSubreport.jpg
One screen shot is of the design view: you can see where the two subreports are.
The next shows what happens when I run with the bottom subreport included. The third shows what happens when I delete the subreport item. The red circles were added in MSPaint.
Design.jpg
WithSubreport.jpg
withoutSubreport.jpg
ASKER
Good call. I added another row to the parent Tablix, and put the sub report in the new cell. Voila! All worked. Thanks for the responses.
For others benefit to see what solved the problem:
Author Comments:
Good call. I added another row to the parent Tablix, and put the sub report in the new cell. Voila! All worked. Thanks for the responses.
Author Comments:
Good call. I added another row to the parent Tablix, and put the sub report in the new cell. Voila! All worked. Thanks for the responses.
What happens if you include the subreport "somewhere else" in the report?