<div>
Hi.. Could you explain a little more about this parameter? Do you want just one dropdown with the option of year to date, month to date and current date or are these 3 different parameters. Also when you say year to date, are you talking about the current year from 1st of Jan or financial year meaning from 1st of Apr?<br />
<br />
Rob<br />

</div>


Hi.. Could you explain a little more about this parameter? Do you want just one dropdown with the option of year to date, month to date and current date or are these 3 different parameters. Also when you say year to date, are you talking about the current year from 1st of Jan or financial year meaning from 1st of Apr?

Rob


<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; &nbsp;I want to create a parameter in ssrs(having drop down like YTD,MTD,currentdate) for my report.I dont even have a &nbsp;table in database for date field.Please some one suggest how to create a table(in what format and what values we got to populated into it) and get these values to the parameter field.Any help is &nbsp;appreciated<br />

</div>
</div>


Hi,
   I want to create a parameter in ssrs(having drop down like YTD,MTD,currentdate) for my report.I dont even have a  table in database for date field.Please some one suggest how to create a table(in what format and what values we got to populated into it) and get these values to the parameter field.Any help is  appreciated


SSRS YTD,MTD parameters

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.