We have about 30 reports a month to publish. Each report will have a different set of security rights. (For example, office manager x should only be able to see his/her report. But there are a few people who should be able to see all of them.)
Is it practical to use SharePoint for this? If so, what's the best strategy? Could it be automated?
We thought of using SSRS for this instead, but we need to review the PDFs before publishing them and that seemed to be an issue.