SAP Crystal Report stuck on "Please wait while the document is processing" but not hang

[Former Member]

My Sub Report works until I add stored video parameters and linked it to my Main, It got stuck on "Please wait while the document is processing".

The Main Report Preview Works but if I run the report it doesn't

Here's my stored procedure for both reports:

ALTER PROCEDURE[dbo].[usp_MainReport]
            (                      
                @StartDate DATETIME,
               @EndDate DATETIME
            )
            AS
  BEGIN
select * from users
END

ALTER PROCEDURE[dbo].[usp_SubReport]
            (               
                @StartDate    DATETIME,
            @EndDate      DATETIME
            )
            AS
  BEGIN
select * from users
END

Is there a problem with my SAP Crystal Report?

[former_member11696 · Accepted solution]

If they are the same SP why have 2 separate ones?

Remember also, if your subreport is in the detail or group every record returned runs the SP for the subreport, so for 1000 rows returned in the main report the subreport will run 1000 times.

Have you tried waiting to see and monitor the DB server to see if it's still running the SP?

How many rows are returned in the main report?

Don

[Former Member · Accepted solution]

Thanks for the reply, it's not the same stored procedure. I just put an example, but they have the same idea..

Also the subreport is on the report footer section. I'm using C# with VIsual Studio 2015.

This is the code I use to pass values to my stored procedure in my main report which works..

private DataTable GetData()
        {
            DataTable dtData = new DataTable();


            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CSPOSWare.Reports.Properties.Settings.testConnectionString"].ConnectionString))
            {


                using (SqlCommand cmd = new SqlCommand("usp_MainReport", conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    conn.Open();

                    cmd.Parameters.AddWithValue("@StartDate", this.StartDate);

                    SqlDataReader rdr = cmd.ExecuteReader();

                    dtData.Load(rdr);
                }  
            }




            return dtData;
        }

Yes DB Server is running I have attached an picture on my question regarding how it looked like and how it is running on Report Preview. Is this limitation to unregistered crystal report?

[former_member11696 · Accepted solution]

Ah, good to know.

Try my Parameter test app, you can set the parameters for the main and subreport in the Log on routine. Search for DOC-70646

Because it's a Stored Procedure with Parameters you need to set the parameters first before logging on.

Don

[Former Member · Accepted solution]

What do I do with it? I checked the Kbase article 2281780

This site can’t be reached

i7p.wdf.sap.corp’s server DNS address could not be found.

gave me this..

[former_member11696 · Accepted solution]

Try again, there was a problem with the site yesterday...

[Former Member · Accepted solution]

same, I'm loosing hope

[former_member11696 · Accepted solution]

Ah, sorry, my links are hooked into my account, you should be able to find that KBA number but here's the link to the DOC:

scn.sap.com/docs/DOC-70646

Don

[Former Member · Accepted solution]

Hi, can you please check this link.. c# - Crystal report with linked subreport only working on Report Preview - Stack Overflow

my question is the same but I put there more details like screenshot etc.

[former_member11696 · Accepted solution]

Are you using a CURSOR?

See the attached Doc on how to write a Oracle SP for CR to use.

Download the file and save it, then rename and remove the .txt extension.

Don

scr_oracle_stored_procedures.doc.txt.zip

[Former Member · Accepted solution]

Hi, I rename it to scr_oracle_stored_procedures.doc.zip then extract. but all I see is a text file ..

[former_member11696 · Accepted solution]

Unzip the first file you download. Then rename the scr_oracle_stored_procedures.doc.txt to scr_oracle_stored_procedures.doc

Should open in Word now..

Don

[Former Member · Accepted solution]

thanks btw may I ask what's the difference between the Crystal Report Registered vs Unregistered?

[former_member11696 · Accepted solution]

It won't prompt you to register the product.