sql server reporting services: Subreport cannot be shown when run by user who is not content mgr -- sql server reporting services

Subreport cannot be shown when run by user who is not content mgr

Blake Gremillion
3/7/2005 3:35:03 PM

sql server reporting services:

I have a report with a subreport attached. I've deployed both reports to a
folder that is governed by AD group permissions. When I run the report (I'm
a content manager) the subreport shows up but when I try to run from my test
user's account the main report shows but I get the "Subreport could not be
shown" error. Both report and subreport use the same dataset so that doesn't
seem the issue. I set up a test for the test user to run the subreport

RE: Subreport cannot be shown when run by user who is not content mgr

dajm
3/8/2005 6:59:01 AM

Hi Blake,

I got the same error by using a subquery.
Using the data view in the MDE, it returns an error, but when I use the
report view, no error at all anymore.

dajm

[quoted text, click to view]

RE: Subreport cannot be shown when run by user who is not content

Blake Gremillion
3/8/2005 8:53:12 AM

I have solved the problem. When a subreport is used and the report has to be
put into a new security folder it must be moved and not linked to the new
folder. Linking and trying to run the report from the new security folder
will result in a "Subreport could not be shown" error for users who are not
content managers.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.