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...