Skip to Content

Month and Year Parameter Fields

May 02, 2017 at 06:39 PM


avatar image

I'm creating a report with a month range and a year range parameter. The year parameter works fine, but the month range is not pulling the correct data. When I select months 1-5, year 2012-2017, my output is giving me months 1-5 for the selected year range. What I need is data for months 1-2 for years 2012-2016, months 1-5 for only 2017. Can anyone help? Any assistance would be greatly appreciated. Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Jun 08 at 03:36 PM

Please show your selection formula so we can see how parameters are being used.

Seems odd you only want months 1-2 for years 2012-2016. Need some logic. What happens when you get to July and want months 1-7 will it still only be 1-2 months for prior years?


10 |10000 characters needed characters left characters exceeded