June 2, 2008 at 3:07 am
Hi there,
I have a report that has some code in the underlying stored procedure to drive the report depening on who is logged in. For Example when a super user logs in they see all the data and when a standard user logs in they see a restricted data set. I also have an optional parameter which can specify the user for subscriptions, so i have all my bases covered.
What i want to be able to do is have one report that can be run at any time or on a subscription basis. So I need to use stored credentials with windows authentication. I only seem to be able to set one at a time.
I thought about cloning the report with two different data sources, but for maintenance, just want the one report
Any one got any ideas?
June 3, 2008 at 7:03 am
If you're going to use subscriptions, you won't be able to use NT Authentication on the data source as the report runs under the system account for a subscription. Can you set the report up to use stored credentials and then pass the user name into the report as a parameter?
June 3, 2008 at 7:16 am
How would i pass the windows login as a parameter?
June 3, 2008 at 7:27 am
It's available as a Global in the report, User!UserID. The tricky part will be for the subscription as I assume it will pass the system account in. What I do is save the parameters to a database table and then retrieve them when the report runs by an ID that's passed as a parameter.
June 4, 2008 at 9:36 am
Fantastic... Just what i wanted...
Thanks for your help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply