CR10 Parameter Question

[Timmkatt]

Using CR 10
Creating a report for our CFO and she would like to be able to run it by either of two parameter values "Run Date" OR "Paid Date". Is there a way to create the parameters so that she can choose which way she wants to run the report without having to create two reports? Thank you in advance

 

[pmax9999]

Hi Timmkatt

Assuming there the report would have a date parameter (lets call it {?DATE}) and a date "type" parameter {?TYPE}, create a selection formula like this:
(
(
{?TYPE} = 'Run Date' and
{table.run_date} = {?DATE}
)
or
(
{?TYPE} = 'Paid Date' and
{table.paid_date} = {?DATE}
)
)

where {table.run_date} and {table.paid_date} are replaced by your actual names from your database, and the parameter {?TYPE} is set with options of 'Run Date' and 'Paid Date'


Cheers
Pete

 

[Timmkatt]

Works Great! One more question can I make the date parameters a range for each Type? Thanks again in advance!

 

[pmax9999]

Absolutely. Changing the date parameter to a range will not require a change to the record selection.