October 23, 2015 at 2:03 pm
I have a column in my report user_name, which consists of the usernames of each individual. When the report is run I only want the user to see their own information. Does it have to be some kind of parametrized stored procedure? or requires some kind of adjustments on the report builder under parameter properties.
heres some sample data, when TomJ runs the report from his computer (username) I only want him to see his records.
CREATE TABLE TEST_TABLE_App_tracker
(
UID INT,
network_user_name varchar(20),
Event_Des varchar(30),
)
INSERT INTO TEST_TABLE_App_tracker(UID, network_user_name, Event_Des)
Values (1001, 'TomJ', 'Maintenance')
INSERT INTO TEST_TABLE_App_tracker(UID, network_user_name, Event_Des)
Values (1001, 'TomJ', 'Data')
INSERT INTO TEST_TABLE_App_tracker(UID, network_user_name, Event_Des)
Values (1002, 'JerryT', 'Data')
Any ideas or suggestion would be highly appreciated.
October 23, 2015 at 3:49 pm
I even tried this, still not getting the result set specific to my userid
Under data set properties -> Filters
Expression: network_user_name
Operator = 0
Value =User!UserID
October 23, 2015 at 4:10 pm
It gives me no records, although I have records specific to my username in there, when I remove the filter it works, I am sure there is something wrong with the filter I am putting
October 25, 2015 at 1:56 pm
My domain username happens to be 'DMG\Paine while under the network_user_name it is only 'Paine' would that make a difference?
October 25, 2015 at 8:43 pm
Report level permissions within SSRS are in the format domain\user unless you have implement custom authentication.
In this case the value in the table should match the same format or atleast you need a mapping table in between so that Domain\user value can be mapped to the username value in your table. It will require a paramterized procedure which filters the dataset based on the userid. Your approach is correct its only the values that your using to compare that do not match.
Also did you know row level security is coming in 2016 , will it be worth waiting for ? Have you tried powerbi and Arure , row level security i already available there
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply