Data Security in reporting services - rounding/masking rules

• noxidjkram

  SSC Veteran

  Points: 227

  More actions

  March 31, 2022 at 1:12 pm

  #4008813

  Hi,

  I'm evaluating the best design for providing reporting at various levels of aggregation, where the data needs to be masked/rounded to ensure data protection is respected.

  If i supply line item data to SSRS and only enable drill down to summary level in the report (with masking/rounding rules applied), would there be any way in which someone with report access could get to the underlying data, or is this protected within the report server?

  Thanks in advance.

  M

  SQL Novice - Here to learn.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  April 1, 2022 at 2:10 pm

  #4009341

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.