User selects 'From_date' and 'To_date' and based on these conditions Report should be generated after clicking the 'Generate button on the same page.
We create a store procedure in sql server DB having 'From_date' and 'To_date' as input parameters.
How do we get input from user in the dashboard and once the input is given the Sql Stored Procedure shoud be executed and the result should be displayed How do i do that.
Hi @Preethika T - yes I can try to help for sure! Please can you describe your data and requirements a little more? That'll help me (and potentially others) to make some suggestions. For example if you're using a stored procedure because there is some data preparation required before selecting the results then it's possible that we can solve that in another way (e.g. some data prep; initial SQL on the connection; ...). Post back with a bit more info - maybe some example data and sketches? And I'll try to give you some more ideas. Ta, Steve.
