>>>>>>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.
>>
>>
>>Yes, I have tried close then open, and movefirst. We did find what may be causing the problem but do not know where to fix it. We set the cursor to be client side static. However, after the execute command is issued we can see using the VB debugger that the cursor location is being switched back to server side. Why does that happen?
>>
>>Thanks for your help.
>
>Can this new article help you: http://support.microsoft.com/support/kb/articles/Q300/3/87.ASP

Thanks for the help. If we use the open method of the command object it accepts our setting of client side static cursor and the first record is not skipped. The article you pointed me to was very helpful.