crystal reports preview shows 20 pages,report from .Net application shows 1000s pages

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