I need to set up a report generation system for a SharePoint list. The report will display all items within the date range that is specified by the user with a start and end date. The requirement for this is that the user must just enter a start and end date (preferably with a date picker) and have a report gereated for them automatically.
Can SQL Reporting Services be set up to generate a report automatically with just a minimum of entering a start and end date from the user?
I have not set up SQL Reporting Services yet so I cannot test this myself. If SQL Reporting Services cannot do this or if there is an easier way, please advise. The server is SharePoint 2007 Standard, not Enterprise.