(Single) Subscription and security filtering

Hi,
I have a report (created in Report Builder) which has a security
filter in it (based on userid). I would like to be able to have users
subscribe to it and get only the data they ought to see. However,
since I have to save the credentials in order to render the report
automatically (in subscription) - security filtering doesn't work
right, because the users' credentials aren't use.
Is there any way I can make this work?
Thanks in advance,
R. GreenAnyone please?
On Jul 3, 7:36 pm, Ronald Green wrote:
> Hi,
> I have a report (created in Report Builder) which has a security
> filter in it (based on userid). I would like to be able to have users
> subscribe to it and get only the data they ought to see. However,
> since I have to save the credentials in order to render the report
> automatically (in subscription) - security filtering doesn't work
> right, because the users' credentials aren't use.
> Is there any way I can make this work?
> Thanks in advance,
> R. Green|||Ronald,
Did you ever get an solution for this? i am trying to do something similar.
Ryan
"Ronald Green" wrote:
> Anyone please?
> On Jul 3, 7:36 pm, Ronald Green wrote:
> > Hi,
> >
> > I have a report (created in Report Builder) which has a security
> > filter in it (based on userid). I would like to be able to have users
> > subscribe to it and get only the data they ought to see. However,
> > since I have to save the credentials in order to render the report
> > automatically (in subscription) - security filtering doesn't work
> > right, because the users' credentials aren't use.
> >
> > Is there any way I can make this work?
> >
> > Thanks in advance,
> > R. Green
>
>