marinajogy
March 21st, 2009, 08:20 AM
I am using Net 2.0 & crystal reports 11 version (seperately installed ), my sql 5.0
reports preview shows only 20 pages, I copied and pasted the sql query (Crystal Reports->Database-show SQL query)
and created a datatable, as follows.
Dim ds As New DataSet, adp As New MySqlDataAdapter(sql, con), dt As New DataTable
adp.Fill(dt) : Report.SetDataSource(dt)
when the report displayed from .Net application it shows around 1000s of pages
I treid same query from MY SQL query browser also, shows only few hundred records(744 nos) only
reports preview shows only 20 pages, I copied and pasted the sql query (Crystal Reports->Database-show SQL query)
and created a datatable, as follows.
Dim ds As New DataSet, adp As New MySqlDataAdapter(sql, con), dt As New DataTable
adp.Fill(dt) : Report.SetDataSource(dt)
when the report displayed from .Net application it shows around 1000s of pages
I treid same query from MY SQL query browser also, shows only few hundred records(744 nos) only