make the processing fast of crystal report while bind with dataset

See more:

ASP.NET

hello friends

I am bind a crystal report using dataset1.xsd, and write the following code :

//make object in class of crysta report - CrystalReport1 crRpt = new CrystalReport1();
                    SqlDataAdapter adp_Print = new SqlDataAdapter("select_bill_for_Print", con);
                   DataSet2 ds_Print = new DataSet2();
                    adp_Print.SelectCommand.CommandType = CommandType.StoredProcedure;
                    adp_Print.SelectCommand.Parameters.AddWithValue("@invoice", Convert.ToInt32(txtinvoice.Text));                        
                    adp_Print.Fill(ds_Print, "tbcitymaster,tbcompanymaster,tb_Temp_Bill_for_Print,tb_Temp_Customer_for_Print");                    
                    crRpt.SetDataSource(ds_Print.Tables[1]);
                   bill_Preview bill = new bill_Preview();                          
                   bill.crystalReportViewer1.ReportSource = crRpt;
                    bill.crystalReportViewer1.Refresh();
                   bill.Show();               

My crystal reportviewer is on another page, it working very well but problem is that the processing is very slow it take to much time when comes the line crRpt.SetDataSource(ds_Print.Tables[1]);
.

Is there any technique to make fast processing or whate i doing wrong so the processing is slow. pzl send if you have some knowledge.


Thanks & Regards

Parveen Rathi