CODEWITHSUNDEEP
sqlsql-serverreporting-services
mistun
mistun

Reputation: 11

Fiscal year and month parameters

I'm working on a report that reports on a month that a user can select from a drop-down and also reports on the cumulative data for the fiscal year up until the month selected.

How would I go about setting up the parameters so that they can select this fiscal year first from the drop-down and then the second drop-down list with automatically populate which months in that fiscal year has completed or is currently in?

For example, I choose '2019' for my fiscal year, the month date should only show the following choices: October, November, December.

Upvotes: 0

Views: 152

Answers (1)

Roma Ruzich
Roma Ruzich

Reputation: 752

You may create table with such fields: Year, Month. Run such code

select distinct Year from table order by Year desc

to select all fiscal years. Add change event listener to drop-down (fiscal years), on fire run such code:

select Month from table where Year = @year

to select months (@year - chosen fiscal year)

Upvotes: 1

Related Questions