I have been requested to create a report that will give the user a choice either a default date range of 12 months ending from Current Month - 4 months or give them the ability to select their own date range.
I know I can use a parameter in my select expert and that a parameter field can't return a database or formula-field name.
I know I can create a parameter that has two options Default or Select for example. I can also create parameters for my user selected begin and end dates. Then I can call those parameters in my begin and end date formulas. But how would I use that in the select expert? Can I call a formula in my select expert? Or is there another way to approach this?
Please help!
I know I can use a parameter in my select expert and that a parameter field can't return a database or formula-field name.
I know I can create a parameter that has two options Default or Select for example. I can also create parameters for my user selected begin and end dates. Then I can call those parameters in my begin and end date formulas. But how would I use that in the select expert? Can I call a formula in my select expert? Or is there another way to approach this?
Please help!