Parameter Validation

[jakecolman]

We have a requirement that report parameters be validated against each other. For example, given a report that uses two date parameters, I need to validate that the second date is greater than the first date. Is there a way to implement this using formulas?

Thanks!

...Jake

 

[lbass]

Create a formula:

{?enddate} > {?startdate}

Or, to return a message, try:

if {?enddate} > {?startdate} then "Valid Date Selection" else "Invalid Date Selection"

-LB

 

[jakecolman]

Yes, I realize I can write a formula. But where do I put this formula on the report so that it executes before the report actually does anything?