Search results for query: *

Geoff, Here it is, the NIRVANA answer!!! - You can use the "=User.UserID" function to return the User ID in Reporting Services. 1 - I created the [UserCountry] table. This table has two fields [UserID] and [CountryName]. I linked the table with the rest of my data in the query using the...

Hi Geoff, Someone provided me with this code: ======================== create Function dbo.UserCountry() returns varchar as return (select CountryName from UserCountry where UserID = suser_sid() ) End Function ======================== I have followed your suggestion as per above and created a...

Geoff, This looks great, please hang on in there with me so I can nail this SOB!! To answer your Q, I have a policy in place for the user list to be updated as and when users come/go/change. I can create and install the list of countries by user, to the sql server. Lets suggest the table is...

Hi again Geoff, I wouldn't be sure how to use the active directory (to be perferctly honest). If there is no straight forward solution, howzabout if I create a data table of users and their countries and we could reference that. If we use this method, how do I refernce the country name with...

Hi Geoff, Yep, agreed - parameter on the CountryName is the way to go. (BTW, I have a fair grasp on using parameters within reports.) Only, I am stuck on how I carry the users' country name to the query parameter invisibly, preventing the user being able to access another country's...

Hi there, Can someone please put me out of my misery!!!!!!!!! - I am using Reporting Services to deliver business reports over our Intranet to the world. However, I simply need to restrict the report information to the user's country...: E.G. If the user is from Australia, he only sees the...