Forum Discussion

sshweky's avatar
sshweky
Icon for Helper III rankHelper III
10 years ago

hard filters

I am pulling data from an Access database (I do not have SSAS). I want to know if there is a filter I can use that the user cannot edit. For example, I want a specific salesperson to see only sales r...
sshweky's avatar
sshweky
Icon for Helper III rankHelper III
10 years ago

Thank you! So there is no way to make an uneditable filter? Say I make a specific report for a specific salesperson that filters only his sales code. Is there a way I can make that filter uneditable? This would be really bad for me!

pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hey,

 

This sort of restriction should be best implemented on the server side (i.e., database). You can play tricks on the client to make it appear to be uneditable, but that is never reliable given that the server is wide open.

 

Regards,

PQ