Hi Experts,
I am looking for a SharePoint functionality to implement in our reporting project.
I have a SQL server database table which has City Hierarchy data. Now I want to build a Reports Access Site which should have the City arranged in hierarchical order (Country->Region->State->City).In order to view the data for respective cities, the user need to go to this site and create an access request by selecting the cities/state/region/country he needs access to and then submit for approval.
This request should then go through various approval levels and then store this request along with approval details/status in another database table in SQL SERVER so that it can be used by system to provide access.
Is this doable and if yes then is there any links/videos which can guide me on how to do it.
Thanks
Nivi
