By using this website, you agree to our Terms of Use (click here)
I have not yet figured out how to handle this in the Parameter Selection screen of a Report.
We have a report with a Start Date and End Date so we only show transactions in those date ranges. We set the initial values to 2/17/15 for the Start Date and today for the End Date. Since we span several years, it has occurred where the user forgets to change to the year and the report has a negative date range, like 12/1/17 to 1/1/17.
Is there a way to check the value of the End Date and ensure it is greater than the Start Date? Have the report show and error if the range is bad?
Not sure. Never tried it before. The Sales Order report restricts the RefNbr options based on what the user puts in the OrderType field. Maybe you could do something similar, but with the Input mask field?
If it were me, i would just return no results and train the users.
or alternatively, i am sure you can come up with conditions which automatically adapt depending on how the user enters the dates. That way, rather than return an error or no results at all, return the data regardless of the order in which the dates are entered.
Online Members
