SSRS YTD,MTD parameters

Hi,
   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
srirama_raoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shorakCommented:
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
0
srirama_raoAuthor Commented:
I found the answer myself,thanks for the inputs
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.