Nested subreports in a list

When I reference a nested subreport within a list, the subreport fails to
render. The preview page says "Error: Subreport could not be shown", and the
debug output says "An error occurred while executing the subreport
â'subreport2â': Object reference not set to an instance of an object." I have
already spent most of a day on this problem and I'm out of ideas.
I've managed to reduce it to the following simple case:
1) Create a new report called Report1.rdl. Put a text box on it with a
message.
2) Create anothier report called Report2.rdl. Put a subreport on it and
have it reference Report1.
3) Create a third report called Report3.rdl. Create a simple DataSet and a
list that references it. Within the list, add a subreport that references
Report2.
4) Go to the Preview pane for Report3. This is when I see the error.
Any idea on what might be causing this or how I might be able to work around
it?Hello Dave,
This is a known issue and will be fixed in SQL 2005 SP2.
There is a workaround for this issue now:
In "Report2", you could add a List control and bound to a dataset which
have only one record. Then put the subreport for "Report1" in the list
control.
Then in the "Report3", you could add the subreport and put it in to the
list control without any error.
You could refer this thread in the newsgroup which I have replied the same
issue.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/brow
se_frm/thread/d4a097536e77cb44/c210ed9fe6eb0f75
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Works for me.
Thanks.
"Wei Lu [MSFT]" wrote:
> Hello Dave,
> This is a known issue and will be fixed in SQL 2005 SP2.
> There is a workaround for this issue now:
> In "Report2", you could add a List control and bound to a dataset which
> have only one record. Then put the subreport for "Report1" in the list
> control.
> Then in the "Report3", you could add the subreport and put it in to the
> list control without any error.
> You could refer this thread in the newsgroup which I have replied the same
> issue.
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/brow
> se_frm/thread/d4a097536e77cb44/c210ed9fe6eb0f75
> Hope this will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>

Nested Subreports

Hi!

I have a report (A) that has a list where a subreport (B) is displayed. This subreport includes nested sub-reports (C) which have other nested subreports (D) (globally there are 3 levels of subreports). When I try to preview report A in Visual Studio I get the "Object not set to an instance of an object" but when I try to preview report B everything is ok. I have RS SP1 installed and I have already tried to include a dummy query in the subreports so that they always have a result....

Does any one had a similar error?

Thank you in advance

csr

Problem solved!

i seems someone had installed SP2 in Server and I did not have Client updated

Thank you and keep the good work!

nest subreport in a tables detail section

I'm running ssrs 2k and need to put a sub report in a table row. I ran a
simple test by creating a sub report with no data source and just has
textboxes with different colored backgrounds and named it zColors.rdl. I
dragged zColors into a table cell in the detail section. I also dragged a
valid data field into another table cell and ran the report. I can see the
data cell but zColors does not show. I even resized the table row big
enough to assure being able to see the contents of zColors.
Is this even possible in ssrs 2k? and if so, how do I do this?
Thanks.
--
moondaddy@.newsgroup.nospamHello moondaddy,
It is possible.
Instead of increase the main report table cell size, you could reduce the
subreport body size to only include a textbox.
This will be OK.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks its working now.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OWtVsdm%23HHA.5604@.TK2MSFTNGHUB02.phx.gbl...
> Hello moondaddy,
> It is possible.
> Instead of increase the main report table cell size, you could reduce the
> subreport body size to only include a textbox.
> This will be OK.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Moondaddy,
My pleasure. If you have any questions, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.