>>>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