There are a SSRS report and stored procedure to record new rows into SQL server table by using few parameters. So, basically we have users actions in SSRS report, where they choosing options from few lists with given options, then record it with a button, then we got new rows with data in SQL database.
I got an issue as a BI developer, have to add more parameters to be recorded by report/form, so trying to figure out how to make this process more flexible and optimised.
Came with an idea to use some web-form for this goal. But i’ve never worked with web/page coding. So far discovered there are many ways to achieve it, like ASP.NET application in Visual Studio, node.js, Power Automate/Apps.
What solution might be optimal to that type of task?