x

Subreport can not be shown

Hi, In SSRS 2008R2, i have a main report which is using shared datasets and i am using a sub report in it. The subreport is also using same shared datasets. When i ran the report, i got an error "subreport can not be shown". Once i removed the shared datasets of subreport the report is working fine. i didn't get any error on subreport. Can anyone help me what is the reason for this. Is this the drawback in SSRS 2008R2?
more ▼

asked Aug 30, 2012 at 09:18 AM in Default

sanjeev.matte gravatar image

sanjeev.matte
31 8 8 10

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Are sure that all the parameters of the subreport have been assigned a value during design?
more ▼

answered Aug 30, 2012 at 05:21 PM

eghetto gravatar image

eghetto
2.1k 15 17 23

(comments are locked)
10|1200 characters needed characters left
Yes...I have assigned values to each and every parameter.
more ▼

answered Aug 31, 2012 at 06:41 AM

sanjeev.matte gravatar image

sanjeev.matte
31 8 8 10

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x83

asked: Aug 30, 2012 at 09:18 AM

Seen: 872 times

Last Updated: Aug 31, 2012 at 06:41 AM