Query database before finalizing report
I have a memo control that takes a customer number to query the database to create a report. Is there a way to query the database and give the user the option to reenter the number if it does not exist? The data is displayed in a MasterData band along with a group heading. Currently when no data is found, the report runs and displays a message if there is no result. Then the user has to run the report again. It would be helpful if the user input section of the report was more interactive.
Any suggestions? Can that be done with FastReports?
Thanks
Any suggestions? Can that be done with FastReports?
Thanks
Comments
if none set the mrok button to false and show a message.
at the choose records to print demo for another idea.
Now I'm trying to verify if the number exists in a date range. A start date and end date are entered in DateEdit controls. Querying the database each time the user scrolls through each calendar might be too much, so I am trying the OnExit event for those controls. The problem with that approach... exiting one control to change the other can cause a message to pop up.
Is there a way to query the database after the user clicks the mrok button, and then stop the report from running if there are no results from the query? I am guessing there is not.
Your answer is still helpful, and I'll still come up with a workable solution regardless.