Hi,
I have what is probably a simple question about report criteria forms, but can't seem to work out how best to do it?
I have several reports each with a criteria form which typically request date ranges and then do some validation.
In the event of an error, I popup an alert to the user and the report exits.
If the input is ok, I apply the criteria to the query in the "PHP Used to Create #TABLE_ID#" and it retrieves all records.
What I would like to do (presumably again in PHP?) is to detect if the number of records is greater than a certain value and if it is then popup a message to the user asking them to reduce or narrow the date range.
I have already added PHP code to get the record count but not sure how to: (a) popup a message to the user from the PHP and (b) exit the report cleanly without generating an empty report or any error messages.
Thanks in anticipation.
Cheers,
Peter
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.