[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1097
  • Last Modified:

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
1 Solution
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?

srirama_raoAuthor Commented:
I found the answer myself,thanks for the inputs

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now