Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor statement causing duplicate records in report
Message
 
 
À
04/06/2008 14:46:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01321649
Message ID:
01321681
Vues:
12
>>In the browse window does the cursor look OK? If yes, then something is wrong in the report itself.


Did you verify the cursor? Do you have the duplicates in the cursor?

If not, add

select * from curResult into table myDataTable.

Close the form.

Open the myDataTable. Examine it.

Now run the report against this table. If the report shows incorrect information, verify, that the report doesn't use private DS. Also verify the report itself, may be you setup it wrongly.

>Still the report prints duplicate records if I leave a combobox blank which is what the customer is looking for is to be able to pull up reports by user only or be able to pull up strain only (All based on the date function)
>
>I hope this time I was clear. It's easy to get lost when you are already halfway there.
>
>Thanks,
>
>Fred W.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform