Check user's group for default parameters

• maniqwils

  SSC Enthusiast

  Points: 187

  More actions

  December 1, 2021 at 6:40 am

  #3958958

  I have a request to change the default value of a parameter based on the user's group membership e.g. Group A members run the report, Group A's data is in the report, Group B members run the report, Group B's data is in the report.

  Currently the parameter is set based on a user's select ion fro https://vidmate.onl/m a drop down. I think that it should be a trivial, but my google-fu returns a lot of report-level permissions.

  I am an accidental report writer. I was volun-told that it's a DBA job.Does anyone have any advice, or keywords to aid my search?

  Thanks in advance!

  • This topic was modified 2 years, 11 months ago by  maniqwils.

• PB_BI

  SSCoach

  Points: 17463

  More actions

  December 1, 2021 at 9:00 am

  #3958985

  Here's a resource with some answers

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/199769c2-25c1-4077-9e64-bd95a16c8535/ssrs-get-current-logged-in-user-to-be-used-as-parameter?forum=sqlreportingservices

  Essentially though the User!UserID property is what you need to get you started. You can just pass whatever you need from that into the parameter which controls what data is shown - I'm assuming that is what is happening - and then hide it all from the user if you want.

  ---

  I'm on LinkedIn