Crystal Reports not displaying Correct Num of Records
-
Please correct me if i am in the wrong post i am pulling data from a db to populate a crystal report document. when i run the query in 'toad 4 sql editor'' or sql management studio' i get about 6800 records but when the report is generated i get only 4 records. I even test the rows of the datatable being passed to the reports and it says 6800 records but the report actually shows 4 records in the first and only page. no subsequent pages exist here is a samnple code 'creates a new instance of the report Dim DrvReport As New CRDrivers 'test the number of rows generated MsgBox(dt.Rows.Count) 'set the dataseource 4 the report DrvReport.SetDataSource(dt) 'set report source 4 da crystal report viewer CRViewer.ReportSource = DrvReport CRViewer.RefreshReport() DrvReport.Dispose() i have been using crystal but never experienced this before.Sorry for my long text Plz help..thank you all
-
Please correct me if i am in the wrong post i am pulling data from a db to populate a crystal report document. when i run the query in 'toad 4 sql editor'' or sql management studio' i get about 6800 records but when the report is generated i get only 4 records. I even test the rows of the datatable being passed to the reports and it says 6800 records but the report actually shows 4 records in the first and only page. no subsequent pages exist here is a samnple code 'creates a new instance of the report Dim DrvReport As New CRDrivers 'test the number of rows generated MsgBox(dt.Rows.Count) 'set the dataseource 4 the report DrvReport.SetDataSource(dt) 'set report source 4 da crystal report viewer CRViewer.ReportSource = DrvReport CRViewer.RefreshReport() DrvReport.Dispose() i have been using crystal but never experienced this before.Sorry for my long text Plz help..thank you all
what i understood from your post is 1) you might have restricted records accidentally in rpt file.... 2) or in crystal report viewer... if the dataset/datatable showing correct # of records..
Government Dyal Singh College Lahore.
-
what i understood from your post is 1) you might have restricted records accidentally in rpt file.... 2) or in crystal report viewer... if the dataset/datatable showing correct # of records..
Government Dyal Singh College Lahore.