We are tasked to migrate an access application with dashboard for reports to
Sharepoint.
The users want to be able to enter/edit /update the data and generate a couple
of reports.
I am trying to get the best approach for this.
These are my thoughts and would like to hear from you any better approach.
1. Store the data in a Sharepoint list as the data growth only about 10% max in
a year and there are about only 150 rows with about 10 coumns right now, mostly
test fields.
2. create a custom asp.net form to enter and update the data in Sharepoint list.
ANd write custom code to update teh Sharepoint list.
3. Not very sure about the reports. if a Dashboard, SQl reporting services
would be better.
I would like to hear your opinion on 1 nd 2 . And especially which approach has
worked for you for the reporying and any issues you had with it.