SSRS YTD,MTD parameters

   I want to create a parameter in ssrs(having drop down like YTD,MTD,currentdate) for my report.I dont 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
Who is Participating?
srirama_raoConnect With a Mentor Author Commented:
I found the answer myself,thanks for the inputs
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?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.