Server generates report when user connects

[Linux-Us]

Hello,
I use Reporting Services included in SQL Server 2005. I would like to make specific reports to each user who connects to the report server. It is a common example, every business that connects to see his work and his alone. Therefore I come to retrieve the credentials of the logged on user (Windows authentication method), and I pass the logon parameter in my query to filter. But I do not see at all how? Thank you.

[Zecho]

Hello,

I would like to make specific reports to each user who connects to the report server. It is a common example, every business that connects to see his work and his alone.

I think you can not retrieve the username of the windows session or switch element as a parameter to your report.
For both administrator and the user. I question I have for you, what will you do with the generated reports, that is what is the use of the reports for the user's connecting the server.

[Linux-Us]

Hi,
I know how to declare it in Visual Studio, a parameter and integrate it in a query, but I do not see how to retrieve the name of the Windows user and integrated into the application. Thanks for your reply.

I question I have for you, what will you do with the generated reports, that is what is the use of the reports for the user's connecting the server.

I want this because I want to keep a track on the users work. So, I think concept like this or similar to this will help me.

[Zecho]

Hello,
Property System.Environment.UserName enables you to retrieve the name of the user. Then just as you create a parameter of type string in your report and in it "calls", you pass the user previously recovered. Hope this method helps you. Just try this method and then if you have any problem then do post back.

[Linux-Us]

Hi
OK, it works, thank you!
EDIT: there is also another way to retrieve the logon user login:

User UserID

I prefer this method because the value returned by this field there is the domain name, which suits me.
So the method for those who have not integrated whole:
- Create a report parameter of type String, and check "Hidden".
- In Default Values, check "Non-queried" and put "user =" UserID "in field
- In the dataset query, filter using this setting:

WHERE usrLogon = @ loginreport

[Zecho]

Hello,
In my report if I put System.Environment.UserName get an error when generating the report.

Error while processing the report parameter "Usern. (rsReportParameterProcessingError)

in deferring to the user parameter set default value = System.Environment.UserName.
What is strange is that his works very well in the overview report. But not once deployed. If I put User! UserID its course but I have the username and domain name. How do I get only the user name without the domain name before. Thank you.