Hi,
I have two questions regarding K2 reports.
1. Is it possible to have dynamic role access to Reports. Report User list should be able to change through code dynamically.
2. Is it possible to Generate reports based on the user who access it? Like one should be able to see only reports relevant to him.
Please help me. Thanks.
Vinoy
Got the solution, Thanks if anyone looked into this.
We have edited the report in SSRS and got the logged in user by "=User!UserID". The report access was given to everyone and the report data was shown accroding to the logged in user.
Tnks
Hi,
I'm trying to get a report to run and display data only related to the logged in user. Saw this post, and have tried to use the "=User!UserID" option, but having no luck. Having exported the report to SSRS, I'm amending the query in Visual Studio, and adding a clause to the select statement to just return data where a field in a smart object =User!UserID, but this is returning a syntax error. If you wouldn't mind helping out a new user in this area, could you be specific on how you have done this? What data items have you used?
many thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.