Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reports showing only......
Message
From
13/05/2008 19:21:46
 
 
To
13/05/2008 17:15:50
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01316516
Message ID:
01316846
Views:
21
Based upon this code there is no need to create an index. Your data cursor looks as if it is created properly. As has been suggested elsewhere, just before you issue the REPORT FORM, stop the program and examine (BROWSE) the cursor (strainreport). If the order of records in the cursor does not match the order of the records in the report then there are different kinds of problems.

Guess #1. Make sure that NONE of the field expressions in the report have an alias. Since this was mentioned to you earlier, my guess is that you already done this.

Guess #2. Make sure the data environment is not included in the report. I'll need to defer to somebody else on exactly how to do this as I'm pretty sure this is one of the changes from the VFP 8 report writer.

>So here is the code I am using and calling up the report from a command button for now do not know a better way yet, anyway here goes.
>
>
>SELECT strain, quantity, location2, userid, date, notes ;
>	FROM Veg ;
>	ORDER BY strain ASC, date DESC ;
>	INTO CURSOR strainreport
>SELECT strainreport
>REPORT FORM report1cutt.frx  TO PRINTER  PROMPT  PREVIEW
>USE   && closes the cursor
>SELECT Veg
>USE   && closes the table
>
>
>
>What happens with this code is the report gets pulled up but it does not sort date descending and if I leave the last 2 lines of code in this snippet I get the error after closing the report preview Alias Veg is not found. It finds Veg in the beginning of the code but not at the end.
>
>Thanks,
>
>Fred W.
Previous
Reply
Map
View

Click here to load this message in the networking platform