December 14, 2009 at 3:02 am
I have a simple report which is split down by department.
I am a real novice to SSRS and this is the first report i have produced. I am willing to learn, but i can't even find any reference to start with.
At the moment, when a user runs the report they get a department per page, and can flick through to theirs. I would like to ensure that when a user runs the report it only displays data based on the department the PC is located in (I have a seperate database that lists all pc's in the organisation, and what department they are in). This will obviously involve pulling the hostname from the client in some way.
Does anyone have any suggestions as to where i might start ?
Thanks
Andy
December 14, 2009 at 7:26 am
Don't know how to do this because SSRS doesn't expose a HostName() or ComputerName() property/ function. If you have a user associated with a PC you could use the UserID function in SSRS to get the department name.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 14, 2009 at 8:05 am
Jack Corbett (12/14/2009)
Don't know how to do this because SSRS doesn't expose a HostName() or ComputerName() property/ function. If you have a user associated with a PC you could use the UserID function in SSRS to get the department name.
Thanks Jack
Unfortunately, the PC's are logged on with generic usernames, and there's no way of linking a user to a department. They could potentially work in several departments on the same day. Hence they would need a different view of the report based on their pyhsical location.
Maybe there isn't a solution. Like i say, i am a complete novice. I was hoping there might be a way for SSRS to use the Hostname variable somehow.
Thanks
Andy
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply