Can I use a dataset to control access to a report?

• m.v.turner

  Newbie

  Points: 1

  More actions

  December 15, 2010 at 3:45 am

  #232096

  Our Active Directory does not yet contain all the nuances of who works where in the organisation but our HR database does.

  Since we already have database tables that tell me who works in the Payroll office can I use them to prevent access to a payroll report with an appropriate message?

  Thanks in advance

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  December 15, 2010 at 5:20 am

  #1262753

  Using dataset you cannot restrict users to access reports. Though using your Report manager or Sharepoint you may achieve it with ease

  Raunak J