Validate request form input in Report

janpieter

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 ... ?

DenSter

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.

janpieter

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.

wonmo

Why not create a form which accepts these values and then call the report from the form only if your conditions are met?

janpieter

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.

wonmo

What other functionality can you not recreate in the form level?