Hi all,
I am creating a jet report and having an issue. Below is the issue description.
Suppose i am creating a JET report with Item Ledger Entry table and in the option Sheet i have filters say -
a) Item No.
b) Start Date
c) End Date
Now i want that user should get an error message if he/she tries to run the report without specifying Start and End Date.
I know there are workaround for same but just wanted to know, IS IT possible with JET Reports?
Regards,
Saurav Dhyani
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
i think i would try it via "Excel/menue/data/data tools / data validation" , and not via Jetreports.
Regards
jetsetter -
Jet Reports Historic Posts There is a possibility to validate the user input in the option sheet.
Normally you have to use the columns Title, Value and Lookup to define the option window.
But you can add a column labeled Valid and put a calculation in it that results in true or false.
When false, Jet will display a message and doesn't run the report.
Just found out myself via this post: http://community.jetreports.com/viewtopic.php?f=6&t=1949&p=5601
Seems to be a 'hidden' feature…
HTH
rmw
Please sign in to leave a comment.