Hide a sub report from view

Is there any way to make a subreport hidden on the report server. For
instance report "A" contains subreport "B". I want the user to be able to
run report "A" that runs report "B", but I only want them to be able to see
report "A" in the report server folder.
Thanks,
--
JasonOn Mar 19, 7:38 am, JasonDWilson
<JasonDWil...@.discussions.microsoft.com> wrote:
> Is there any way to make a subreport hidden on the report server. For
> instance report "A" contains subreport "B". I want the user to be able to
> run report "A" that runs report "B", but I only want them to be able to see
> report "A" in the report server folder.
> Thanks,
> --
> Jason
You can try not letting the users have access to subreport B (via the
Report Manager permissions) and see if they can still access subreport
B via report A. If this does not work, then you will need to create
something custom that passes the User ID and another item/parameter to
the subreport to let it know that it is being called from report A:
The expression =User!UserID.ToString will get the current user and
then you would need to pass maybe a hidden parameter to subreport B
from report A (one that is not intuitive). That way, when subreport B
is called on it's own, the user will not know the parameter value it
needs. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer