Crystal Reports problems loading

[former_member212657]

Hi all

I want to ask about a couple of problems I have.

I creed several reports with crystal reports, these reports are displayed after a few minutes (2 minimum) may be because they are associated with a Stored Procedure?, and if so how I can optimize it, any advice?.

Another problem that occurs is given after which some reports have shown, you enter the data required by the parameters, start doing the work want to show the report and then get a message that says "The application has suffered a failure and closed.

To resolve this somehow delete the temporary files but this is only a momentary solution then the error appears again.

Thanks to everyone for the help.

Angel Uribe

[former_member183750 · Accepted solution]

One issue per thread. See the [Rules of Engagement|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement].

Pick which issue you want to work on here and cerate a new thread on the other issue.

- Ludek

[Former Member]

Helloo

I m facing the same problem (time issue). Report takes too much time to load. i m using the dataset instead of stored procedure. and my code sample is as follows:

ReportDocument ReportDoc = new ReportDocument();
            Database crDatabase = null;
            Test_DataSet testdataset = new Test_DataSet();
            ReportDoc.Load(@"c:\myReport.rpt");
            SqlConnection conn = new SqlConnection(conectionString);
            SqlCommand command = conn.CreateCommand();
            crDatabase = ReportDoc.Database;
            foreach (Table crTable in crDatabase.Tables)
            {
                string strQuery = "SELECT ";
                for (int i = 0; i < crTable.Fields.Count; i++)
                {
                    strQuery += crTable.Fields<i>.Name + ",";
                }
                if (strQuery.EndsWith(","))
                {
                    strQuery = strQuery.Substring(0, strQuery.Length - 1);
                }
                strQuery += " FROM " + crTable.Name;
                command.CommandText = strQuery;
                SqlDataAdapter da = new SqlDataAdapter(command);
                da.Fill(testdataset, crTable.Name);
            }
            ReportDoc.SetDataSource(testdataset);
            this.crystalReportViewer1.Visible = true;
            this.crystalReportViewer1.ReportSource = ReportDoc;

i need it urgently as i m running out of time please.

Thanx

Edited by: umeryounas on Jun 9, 2011 8:59 AM

[former_member183750]

Dataset \ stored procedure. Different issue. Kind of like, my diesel car does not start. Your gas car does not start. Both cars must have the same issue...

Create a new thread.

- Ludek