Hi All
I have created a Report via BAQ Report designer which looks at a BAQ I have created. I need to add some custom parameters where users can select from a userdefined list on the first parameter, which will show a list and if they select option 1 from the userdefined list then they need to select the fiscal year and period in the next parameter, if they select option 2 then this filters the report to show data for the current fiscal year and fiscal period.
Ive followed help guides, but unable to see if you can create customer and complex prompts/parameters within Report builder or BAQ report designer. Any advice please?
Thanks
RRuss
Welcome! You came to the right place. I think you would have to do this by customizing the form that calls the report. The built-in BAQ report options dont allow for complex criteria like you want. So I think you need to modify the form. Turn on developer mode, and then right click on the form to customize it. After that I am not sure exactly what you need to do, but essentially you want to create those custom option selections. I think you could do it with custom combo boxes.
Another route might be to have two reports. One report is hard coded with this fiscal year, and another report lets you run for any FY. Use the built in BAQ report options as parameters. This would mean you don’t have to customize any forms, and you could probably get there in an afternoon.
The other approach might work too, but it will take longer and be more difficult.
Good luck!