Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BOB_78
Starting Member
2 Posts |
 Posted - 2006-09-07 : 04:37:03
|
| Hello all,I am having a problem controlling the reporting session.I created a Reporting Model using SQL reporting Services 2005 with Forms authentication on which I implemented the security Filter based on the function GetUserID() to report only against data that belong to the login User. I then deployed the Model.Using report Builder application, I created a report that contains the user name (UserName) from entity “Users” in the first column, and data from other entities related to table usersa in the remaining columns. I saved the report on the report server.I logged in into report manager with user “User1” and ran the report. The result was just as I expected: in the first column “User1” appeared and in the remaining columns, other data related to this user appeared. Every thing went good.After that I logged in with the user “User2” and ran the report. Suprisingly, the same data that appeared for "User1" appeared for "User2". What I was expecting was to see different data, related to "User2".After some research, I discovered that this problem may be caused by a session issue (the session created for the first user who enters the report server will remain for the other users that enter after him). I reset the IIS, logged in with “User2”, ran the report, and the correct data for “User2” appeared. So I believe it may be a session issue.My question is: Is there any way to control the session content and the session expiration?Please note that I used all the solutions provided in my research such as 'URL parameter rs:ClearSession = true' and the Report Execution Options in report manager but none of these solved my problem.I will really appreciate it if anyone can help me with this issue.Thank youBOB |
|
|
|
|
|
Controlling the reporting session