Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reports showing only......
Message
De
13/05/2008 19:21:46
 
 
À
13/05/2008 17:15:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01316516
Message ID:
01316846
Vues:
23
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform