I inherited a SharePoint (2007) website that my former co-worker was managing for our company. I only have limited experience with SharePoint.
A bit about how the system is designed as far as I understood:
This is a client-facing system that is available for a few internal users too. The site's primary function is to allow users to run reports (SSRS). The input for the reports are entered via a user control (.ascx) that has a few drop downs. The reports are common for several clients, but values available in drop down for Client X should not be available for Client Y. I suspect this is why he went with the User Control based inputs. All users have a domain account on our side. This domain is solely for the purpose of having user accounts to access this SharePoint Site and not our everyday domain. The Data for the drop downs must come from the database.
Now, everytime there is a request for a new report, I have to not only design and deploy the report, but also create the respective user control and deploy it. It is cumbersome. Is User Control the only reasonable way to achieve this? Are there any better way like InfoPath etc?
Please forgive me if I used the wrong terminology. Thank you for all advice.