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-06 : 09:50:20
|
| I have a problem in controlling the report 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, and I deployed the Model.Using report Builder application I created a report that contain in the first column the user name (UserName) from entity “Users”, and in the remaining columns data from other entities related to table users, I saved the report on the report server.I logged in into report manager with user “User1” and I ran the report, the result was the same as expected (in the first column “User1” appeared and in the remaining column other data related to this user appeared) every thing went goodAfter that I logged in with the user “User2” and I ran the report and here was the surprise the same data that appeared for "User1" appeared for "User2". but what was Expected is different data that belong to "User 2"After some research that says 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 IIS and I logged in with “User2”, and I ran the report the correct data for “User2” appeared So it may be a session issue.My question is: Is there any way to control the session content and the session expiration?Please note I used all the solution provided in my research such as URL parameter rs:ClearSession = true, and the Report Execution Options in report manager but non of this helped me.I will be thankful for any one who could help me in this urgent issue.Thank youBOB |
|
|
srilatha5
Starting Member
2 Posts |
Posted - 2008-02-01 : 17:36:36
|
| Hi Bob,I have the same problem as you faced? Was it solved, if so can you please post the solution?Thanks,Sri |
 |
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-02-04 : 08:16:17
|
| I don't know if this will help, but there is a parameter called ClearSession of type boolean, which I use to reset the session. However I have my report deployed via website so I just pass it as one of the parameters in the URL (rs:ClearSession=true)Hope this helps |
|
|
|
srilatha5
Starting Member
2 Posts |
Posted - 2008-02-04 : 20:33:45
|
| Unfortunately not, the GetUserID() function gets the first logged in userid and unless IIS is reset it cannot get any other user ids. |
|
|
|
|
|
|
|
|
SQL Reporting Services Session problem