Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data report skips first record
Message
 
To
31/05/2001 17:16:16
General information
Forum:
Visual Basic
Category:
Other
Miscellaneous
Thread ID:
00513256
Message ID:
00513509
Views:
12
>>>VB 6.0
>>>I am using the datareport to print a report. The ADO recordset is set for client side static. The report skips the first record from the recordset. Records 2 through eof print correctly. Can someone help me include the first record.
>>
>>Can this help: http://support.microsoft.com/support/kb/articles/Q190/6/07.ASP
>
>In my case the recordset is not bound to anything...below is the syntax.
>
>set rs = cmd.exectute
>set rpt1.datasource = rs
>rpt1.show
>
>All the data returns into the report except the first record.

have you tried something like MoveFirst? Also, I would try to use the Open method of the recordset object instead of the Execute method. Open a Static, ReadOnly, Client-sided cursor.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform