Validate request form input in Report

janpieter
Member Posts: 298
Probably this is a verry stupid question but i can't see to figure out how user input on the request form of a report can be validated before the report is run .. #-o
The problem is when i put testing code in the OnPreReport trigger and generate an error the whole report closes :roll:
After validation of user input in the requestform i want to be able to go back to the request form so the user can correct his mistake but everything i try result in the report being closed ... :-k
Anyone ideas ... ?
The problem is when i put testing code in the OnPreReport trigger and generate an error the whole report closes :roll:
After validation of user input in the requestform i want to be able to go back to the request form so the user can correct his mistake but everything i try result in the report being closed ... :-k
Anyone ideas ... ?
In a world without Borders or Fences, who needs Windows and Gates?
0
Comments
-
Click on the textbox on your request form and hit F9. You will find the code there. I believe you can error out there without the report closing out.0
-
Thanks Denster.
Maybe i wasn't clear;
I want to validate empty input. Unfortanly the textbox validate trigger then is not usefull because it won't get executed when the user does not input something in that textbox. And that is the whole point.
I must test if a user has put a value in a textbox.In a world without Borders or Fences, who needs Windows and Gates?0 -
Why not create a form which accepts these values and then call the report from the form only if your conditions are met?1
-
wonmo,
thank you.
That would be a possibility though it will be my last alternative as i would then trade in other functionality.
Not a nice way but it will work.In a world without Borders or Fences, who needs Windows and Gates?0 -
What other functionality can you not recreate in the form level?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions