cancel
Showing results for 
Search instead for 
Did you mean: 

Validate user input

Former Member
0 Kudos

How do I validate the data that the user inputs through the prompts? Example: End date is not earlier than start date, or End Date - Start Date <= 12 months?

Any direction is appreciated

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Denzil,

One way to "validate" the data would be to populate a back-end table that has the combinations of data you want users to invoke as they run a report. Another way would be to set up an alerter in the report and when the undesired condition is met than a cell would show up stating the problem, but this solution appears after the report runs and is handled within the reporting tool. Not very easy answers, just some choices for you to think about.

Thanks,

John

Answers (0)