Hi
I'm wondering if anyone can help me with the following for which I'm
considering using SharePoint for but am not sure if it's possible or
what is the best approach.
I'd like to setup sharepoint to deliver sets of management information
reports with access based on roles and the reports grouped by customer.
My idea is to have a list of all customers which anyone can see and
click on to see the reports associated to that customer. What actual
reports are seen would be dictated by the logged in role the user has.
The data source is mostly SQL, so I'm wondering how I can get the data
from SQL into something presentable in sharepoint. I was thinking that
I could possible set up a template in sharepoint then all i would need
is a customer id to indicate which reports are required, but would this
mean development or are there web parts out there for this?
Any help/advice would be greatly appreciated.