From: Bebot Chan
To: jac humbert
Visual FoxPro 5
Reports and Printers
Thursday, April 03, 2003 4:58:16 PM
This message was rated by:
> if i remember correctly, maybe your report has either no records to be shown OR you have a variable that is being used in your report that isn't being properly initialized...
> > I have a form with an option button named preview & a combo box & text box containing from & to grinno. Onclick of preview option button the combo box & the text boxes are enabled. The combo box contains two options named 'Before approval' & 'After approval' & 'Fromgrinno & Togrinno text box' .
> > 1. Onchose of 'Before approval' my report based on tabled pendgrin should be displayed .
> > 2. onchose of 'After approval' my report based on rcdgrin should be displayed.
> > 3. Both the reports are the same reports with both the tables added in it but depending upon the selection certain fields will be displayed in 1 report & certain other in another report.
> > My problem is onclick of ok command, the preview page is seen but runs out immediately. Can anybody help me.
> > Regards
> > Vijayendran S
Jac and Yuri are right. You may not have any records in the cursor you want to report on. One test would be to check if you would get any report if you do not enter anything in the textboxes FROM and TO. That should give you the entire records. If not, then there must be something wrong with the SQL statement or SET FILTER command that executed.
Posted by Vijayendran @ 4/3/2003 3:32:49 PM
Posted by Yuri Rubinov @ 4/3/2003 3:45:15 PM
Posted by jac humbert @ 4/3/2003 3:50:05 PM
Posted by Bebot Chan @ 4/3/2003 4:58:16 PM