PDA

Click to See Complete Forum and Search --> : next paging in data report


popodc
May 1st, 2006, 07:49 PM
Set rsDis = New ADODB.Recordset
sql = "select chkname, chkdate, chktotal, chknumtoword from checktable"
rsDis.Open sql, cn
Set DataReport1.DataSource = rsDis

DataReport1.Sections(1).Controls("lblAccount").Caption = rsDis(0)
DataReport1.Sections(1).Controls("lblDate").Caption = rsDis(1)
DataReport1.Sections(1).Controls("lblTotal").Caption = rsDis(2)
DataReport1.Sections(1).Controls("lblNum2Wrd").Caption = rsDis(3)
DataReport1.Show

i want the next row of my recordset in the next page of the datareport. how? i am using vb 6. thanks!