all groups > sql server reporting services > april 2007 >
You're in the

sql server reporting services

group:

Error: Subreport could not be shown 2


Error: Subreport could not be shown 2 Andres
4/14/2007 8:12:51 PM
sql server reporting services:
Hi

I have a "master" report that has 10 chart sub reports that don't have any
parameter. I get a "Error: Subreport could not be shown" error if one of
them are snapshot based.

Any ideas?

Regards,

Andres
Re: Error: Subreport could not be shown 2 EMartinez
4/15/2007 10:54:37 AM
[quoted text, click to view]


You might be able to resolve this error by returning a default empty
resultset. Also, make sure that all the dependencies of the subreport
are available (i.e., if you are developing reports in a development
environment and then need to transfer them to the production
environment along w/all dependent stored procedures, tables, etc).
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant
Re: Error: Subreport could not be shown 2 Andres
4/15/2007 6:56:07 PM
Hi Enrique

Which report should return a default empty resultset?
And, what's a default empty resultset?

The main report don't have any resultset. I think sub reports have all they
need. They work fine when I use them directly in default mode (no snapshot)
and in snapshot mode.

Regards,

Andrés





[quoted text, click to view]
AddThis Social Bookmark Button