SSRS YTD,MTD parameters

Posted on 2008-11-17
Last Modified: 2012-05-05
   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
Question by:srirama_rao
    LVL 11

    Expert Comment

    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?


    Accepted Solution

    I found the answer myself,thanks for the inputs

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now