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.
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.