Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bebot Chan
  Where is Bebot Chan?
 Saudi Arabia
 Bebot Chan
 To: jac humbert
 jac humbert
Subject: RE: Reports
Thread ID: 21877 Message ID: 21885 # Views: 0 # Ratings: 0
Version: Visual FoxPro 5 Category: Reports and Printers
Date: Thursday, April 03, 2003 4:58:16 PM         

> Vijayendran,
> 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...
> jac
> > 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.



Reports Posted by Vijayendran @ 4/3/2003 3:32:49 PM
RE: Reports Posted by Yuri Rubinov @ 4/3/2003 3:45:15 PM
RE: Reports Posted by jac humbert @ 4/3/2003 3:50:05 PM
RE: Reports Posted by Bebot Chan @ 4/3/2003 4:58:16 PM