<div>
its dependancy issue.., first create the &quot;Quick Select&quot; using query &amp;&nbsp;based on the selection, populate your From &amp;&nbsp;To Date.
</div>


its dependancy issue.., first create the "Quick Select" using query & based on the selection, populate your From & To Date.

<div>
Cheers ValentinoV, Ive decided to simplify it and do away with the To and From.
</div>


Cheers ValentinoV, Ive decided to simplify it and do away with the To and From.

<div>
<div class="content wysiwyg-content">
Hi,<br />
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.<br />
(@From and @To are in my SQL code)<br />
<br />
<br />
I would like to have, alongside this, a drop down list with &nbsp;Current Month, Previous Month, and maybe some other common selections.<br />
<br />
How can I go about this? &nbsp;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. <br />
I tried to make a text variable called 'Quick Select', with available values of &quot;current month&quot;, &quot;Previous month&quot;, &nbsp;etc, but it is greyed out until the calendar boxes are filled in, which defeats the purpose of it.<br />
<br />
The screenshot shows an example of what I am after, this one was made in Crystal though.<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/04_w14/565697/dates.jpg" target="_blank" class="file-inline" title="Date Range Selector (18 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>dates.jpg</a>
</div>
</div>


dates.jpg

Hi,
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.

Date Selector in SSRS Report

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.