Sage 100

Sage Intelligence question. Is it possible to have desperate repositories by workstation? We have a client with many companies, and Sage Intelligence security does not allow Report Manager security by company - it's all or nothing. The client wants to be limit reports and design changes to only those reports within their company. I thought a way around this limitation would be to create unique repositories for each company. So I'm wondering, if the path to the repository is stored locally, would this be possible?

Bill, to answer your question, you could have separate repositories, I found this by accident about a year ago. However, Security Manager does allow for the same report to be used by a person for only the company they have access to. You have to log into Security Manager under each company code and set up the users and the reports they can access. It's a bit cumbersome but I have the same thing - 20 companies, utilizing the same reports, but users are only able to run the reports for the company they have access to in Sage.

Thanks @NancyHanson. The issue I'm having is not 'running' or 'viewing' the reports, but editing them. I've found it's impossible to give Report Manager security by report by role. I though seperate Repositories might work to overcome this limitation.