Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor statement causing duplicate records in report
Message
 
 
To
04/06/2008 14:46:15
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01321649
Message ID:
01321681
Views:
11
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform