Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 06, 2012 10:30 AM by sohrabus
Nov 02, 2012 11:51 AM|LINK
I use SQL Server, WinForm & Crystal 11 R2
I use SqlDataReader To Retrieve around 1 Million Rows from SQL Server.
My Query Executed Successfully.
BUT when Fill DataTable From SqlDataReader it display
My Code is as Follows:
I use all this to display Report in Crystal Report.
Your Help is higly appericiated.
Nov 02, 2012 12:18 PM|LINK
In Cristal report there are option to direct binding with SQL Server, so you can bind your SP or table with Crystal report, you do not need to load your record into data table
let me know if any query
Nov 02, 2012 12:38 PM|LINK
how much data is returned by your query. definietly it is huge. that is the reason you are getting this error.
Nov 03, 2012 04:41 AM|LINK
From Front End I Pass Several Where Condition thats why I Execute Query & Bind with
Pls advise me if u know some alternative.
Nov 03, 2012 05:00 AM|LINK
You can create a SP and and SP you can pass the parameters, based on that params you can filter data and Report is binded of that SP, you you will get filted data.
Nov 03, 2012 05:23 AM|LINK
How you are going to show your 1 million records on a window? Will some scroll to 1 million records? No.
a) So why not you are applying paging to your crystal report.
b) Also you can directly pass the result set of your query/stored proc.
For limiting the records - http://pankajlalwani.wordpress.com/2009/07/31/limiting-the-number-of-records-to-be-displayed-in-crystal-report/
Nov 03, 2012 07:20 AM|LINK
Let me try SP and I'll get back about the output.
Nov 06, 2012 10:30 AM|LINK
I Created CR Report Using SP and Passed Parameters.
It worked and able to retrieve around 2 Million Records ON Test System.
Thanks Alot. For the First Time I used SP with Crystal and it is working fine and solved my Purpose.
Can I ask 1 More Question.
There is a Option in rptDocument.SetDataSource that I can Bind
BUT When i BIND IDataReader, It does not work.
My Code is as follows:
IDataReader idr = clsDAL.ExecuteReader("Select * from Tablename");
Could u pls guide.