Month and Year options parameter in SSRS report
<p>--Hello,</p>

<p>I would like to know if there is a way that the user can have a choice
to select the date range in month (mm/dd/yyyy) or in year (yyyy)...(e.g. using drop down list)</p>

<p>For example......</p>

<p>If the user select "DateByMonth" from drop down list in the Preview mode, then the user can enter the date range in month.</p>

<p><strong>Start Date:</strong> 1/1/2014    <strong>End Date:</strong> 1/1/2016</p>

<p>The output should be something like this.</p>

<pre><code>    1/2014  | 2/2014 | 3/2014 | .... | 10/2015 | .... | 1/2016|
qty   1         6        9                3               6
rev   2         3        2                12              0 
</code></pre>

<p>If the user select "DateByYear" from drop down list in the Preview mode, then the user can enter the date range in year.</p>

<p><strong>Start Date:</strong> 2014    <strong>End Date:</strong> 2016</p>

<p>The output should be something like this.</p>

<pre><code>    2014 | 2015 | 2016
qty 16     3      6
rev 7      12     0
</code></pre>

<p>You might have a better solution.</p>

<p>Thanks.</p>