Hi,
just like to know if there is anyway to make the option lookup screen restricted to select only 1 value. Currently it allows to select multiple values.
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hmmm, no I don't think there is a way to restrict multi-select in the lookup form.
You can do validation on the option value which doesn't allow the user to run the report if the value doesn't validate. So if you wanted to prevent a user from multi-selecting, that would mean you probably don't want either the | or the .. character in the value. To do that, make a column on the report options sheet with the tag "Valid" in row 1. Then you can write formulas in your option rows which return either TRUE for a valid option value or FALSE for an invalid option value. In this case, the formula might look something like this (where C2 contains the Value column value):=AND(ISERR(FIND("|",C2)),ISERR(FIND("..",C2)))
Then you can add a column with the tag "Message" in row 1 and type whatever message you want the user to see if they try to run the report and the Valid column returns false.
Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi,
this is a good work around. I've already tied out in my reports.
Thanks for your suggestion. :D
Please sign in to leave a comment.