This content has been marked as final. Show 4 replies
place the prompts in 2 different pages.
but they need to be on the same page to give the user the option to prompt by YEAR or FINANCIAL PERIOD
Create 2 views 1 for year and other for fiscal year.By using the view selector you can achieve your requirement.But you need to use the column filter.
mark if helpful/correct..
I think using code we may get this, and I'm not sure about results and I need to do in my local.
before going to coding is it possible to go with a single prompt using UNION to show both the Year and 'Financial Period' values.
Or else try to add one more column something link flag, and validate that in your report.