I have built a report with 2 date parameters, @From and @To. They are of data type date/time, so the user can select start and end dates from a calendar box, which works great.
(@From and @To are in my SQL code)
I would like to have, alongside this, a drop down list with Current Month, Previous Month, and maybe some other common selections.
How can I go about this? I want to set the value of @To and @From based on what is chosen in the drop down, if possible. That way I wont have to do anything with my SQL code.
I tried to make a text variable called 'Quick Select', with available values of "current month", "Previous month", etc, but it is greyed out until the calendar boxes are filled in, which defeats the purpose of it.
The screenshot shows an example of what I am after, this one was made in Crystal though.