Please forgive me since I am probably not doing this correctly (posting that is) but I am new to the forum and new to Visual Studio 2015 / ASP.NET MVC5.
I have created a database in SQL\SERVER2012 named ‘deposit3’ with a table named ‘both’ and have created a web application in C# (using Visual Studio 2015) then put a reportviewer on the webpage. I also put a reference to the ‘both’ table of the database and bound it. In visual studio when I hit F5 it runs and displays the table on the web page.
My problem is that I don’t want all the data to display when the page loads, only the last 30 days. I just can’t figure out how to get that constraint in the reportviewer.
I also coded in 2 jquery input boxes that have a drop-down calendar to choose a ‘from’ and ‘to’ date option (along with a basic ‘submit’ button) so the user can select certain dates to view in the reportviewer based on data in the table.
Like I said, I’m a newby and don’t know how to get the submit button to search the database table called ‘both’ and display the results in the reportviewer.
It’s probably a pretty simple tasks, but I just don’t know how to make it work. I have Googled my heart out and have had no luck with this.
I would appreciate any help with this matter. Thank you.