Report Security and Locations

Question

Report Security and Locations

briantallon

SSC Veteran

Points: 212
More actions
November 26, 2014 at 8:14 am

#298849

We have many office locations. I need to build SSRS reports that will be the same for each location -- except that users in that location can only see data from their location. Is there a smart way to do this or do I need to build a report many times with different options for parameters?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Black_T SSC Veteran Points: 259 More actions · Answer 1

For your requirement, you need to do Extranet or Internet Deployment for Reporting Services so that users from different location can access report server via internet. Please refer to a similar thread below:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/87568a64-d3c9-4c6f-8a07-751e83ca65d0/ssrs-reports-global-access?forum=sqlreportingservices

piotrka SSCrazy Points: 2031 More actions · Answer 2

Are you using T-SQL or MDX for your datasets? There will be different approaches based on different SQL services.