I want to use Reporting Services in a web intranet application I'mdeveloping. In the application, I'm using forms authenticationagainst a SQL database that stores the username and "filter values"among other things. These are loaded as Session objects at login.
The "filter values" determine what data is retrieved, since users onlyhave rights to view specific data. Stored procedures run a querystatement to include "WHERE @.filterValue", and the .net code grabs theSession object's filtervalue, ie "Division = 'Admin'" as the sqlparameter. This works great on the other pages in the application.
But I have not a clue how to grab the filtervaluse Session object and plug it into Reporting Services..
Any help/direction will be tremendously appreciated! I work forthe local sheriff's office and am the "Lone .NET / Reporting Services"Ranger".
Thanks!
Lynnette
So no one has any ideas?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment