Crystal Report export to CSV

[wim_brosens]

We have a win forms app written in .NET 4.0 using CR Runtime 13.0.9 (x64). In this app we use the Crystal Reports Viewer to display a report that was developed in Crystal Reports 2008.

This report displays a list of records. For each record there is a sub report displaying an image specific for this record.

The user can choose to preview this report with or without images (via a checkbox. Its state is send to the report parameter field PrintPhotos.) When the images should not appear, section with the sub report in it is suppressed in the section expert with a formula {?PrintPhotos} = False

When I view this report with images, I can export it to CSV.

When viewing without images and I export it to CSV, I'll get this JIT Compiler exception:

I need some help on this.

See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Runtime.InteropServices.COMException (0x80041004): De aanmelding is mislukt. Onvoldoende geheugen voor de bewerking.    at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)    at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)    at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)    at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)    at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()    at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()

...

---------------------------------------- CrystalDecisions.CrystalReports.Engine     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.CrystalReports.Engine/13.0.2000.0__692fbea5521e1304/CrystalDecisions.CrystalReports.Engine.dll ---------------------------------------- CrystalDecisions.Shared     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Shared/13.0.2000.0__692fbea5521e1304/CrystalDecisions.Shared.dll ---------------------------------------- CrystalDecisions.ReportAppServer.DataSetConversion     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportAppServer.DataSetConversion/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataSetConversion.dll ---------------------------------------- CrystalDecisions.ReportAppServer.CommLayer     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_64/CrystalDecisions.ReportAppServer.CommLayer/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CommLayer.dll ---------------------------------------- CrystalDecisions.ReportAppServer.ClientDoc     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_64/CrystalDecisions.ReportAppServer.ClientDoc/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ClientDoc.dll ---------------------------------------- CrystalDecisions.ReportAppServer.DataDefModel     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_64/CrystalDecisions.ReportAppServer.DataDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.DataDefModel.dll ---------------------------------------- CrystalDecisions.ReportAppServer.CubeDefModel     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_64/CrystalDecisions.ReportAppServer.CubeDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.CubeDefModel.dll ---------------------------------------- CrystalDecisions.ReportAppServer.ReportDefModel     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_64/CrystalDecisions.ReportAppServer.ReportDefModel/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.ReportDefModel.dll ---------------------------------------- CrystalDecisions.Shared.resources     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Shared.resources/13.0.2000.0_nl_692fbea5521e1304/CrystalDecisions.Shared.resources.dll ---------------------------------------- crdb_adoplus     Assembly Version: 14.0.2000.0     Win32 Version: 14.0.2009.1312     CodeBase: file:///C:/Program%20Files%20(x86)/SAP%20BusinessObjects/Crystal%20Reports%20for%20.NET%20Framework%204.0/Common/SAP%20BusinessObjects%20Enterprise%20XI%204.0/win64_x64/crdb_adoplus.dll ---------------------------------------- CrystalDecisions.ReportAppServer.Controllers     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_64/CrystalDecisions.ReportAppServer.Controllers/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.Controllers.dll ---------------------------------------- CrystalDecisions.ReportSource     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.ReportSource/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportSource.dll ---------------------------------------- CrystalDecisions.CrystalReports.Engine.resources     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.CrystalReports.Engine.resources/13.0.2000.0_nl_692fbea5521e1304/CrystalDecisions.CrystalReports.Engine.resources.dll ---------------------------------------- CrystalDecisions.Windows.Forms     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Windows.Forms/13.0.2000.0__692fbea5521e1304/CrystalDecisions.Windows.Forms.dll ---------------------------------------- CrystalDecisions.Windows.Forms.resources     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Windows.Forms.resources/13.0.2000.0_nl_692fbea5521e1304/CrystalDecisions.Windows.Forms.resources.dll ---------------------------------------- CrystalDecisions.Web     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_MSIL/CrystalDecisions.Web/13.0.2000.0__692fbea5521e1304/CrystalDecisions.Web.dll ---------------------------------------- CrystalDecisions.ReportAppServer.XmlSerialize     Assembly Version: 13.0.2000.0     Win32 Version: 13.0.9.1312     CodeBase: file:///C:/Windows/assembly/GAC_64/CrystalDecisions.ReportAppServer.XmlSerialize/13.0.2000.0__692fbea5521e1304/CrystalDecisions.ReportAppServer.XmlSerialize.dll ----------------------------------------

...

Thank you,

Wim Brosens

[former_member11696 · Accepted solution]

Hi Wim,

SP 13 was just released, see if that resolves the issue. SP 9 had a lot of WEB app issues.

Don

[wim_brosens · Accepted solution]

Hi Don,

I've installed v13.0.13 (64-bit) runtime that did not solve this issue. I do get another errormessage now:

System.Runtime.InteropServices.COMException (0x80004005): The system cannot find the path specified.   at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)   at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)   at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)   at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)   at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()

[former_member183750 · Accepted solution]

Hi Wim

Can you export that report successfully to any other format?

Can you export the report to CSV from the CR 2008 designer?

Can you save the report in the CR 2008 designer with the "Saved Data" option enabled, then run and export to CSV this saved data report from the app?

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[wim_brosens · Accepted solution]

Hi Ludek,

For the export without images I can export it to different files:

- Microsoft Excel (xlsx)

- Microsoft Word (doc)

- Portabel Document Format (pdf)

- Richt Text Format (rtf)

Only export to csv file throws this error.

From within the Crystal Reports 2008 Designer I can preview and export it to csv, without any problem.

Also saving this report with option "Saved Data" in designer, and via preview in application exporting to csv is no problem.

Only exporting this report filled with data coming from a dataset loaded from the database, and exported to csv file via the Crystal Reports Viewer causes this error.

Any other things I can look at ?

Kind regards,

Wim Brosens.

[former_member183750 · Accepted solution]

I wonder if the following KBA applies?

2105311 - ExportToStream throws exception in SP 12 in Crystal Reports for Visual Studio

- Ludek

[former_member11696 · Accepted solution]

Hi Win,

Can you attach the report with dummy sample data with and without image so I can test it in my app?

Use Advanced Editor, rename the RPT file to *.txt abd then attach.

Thanks

Don

[wim_brosens · Accepted solution]

Hi Don,

In attachment you'll find the exported Crystal Reports rpt files after they where coupled to the dataset holding the data. Those reports are filled with and without images.

Kind regards,

Wim Brosens.

Brosens.Wim.Without.Images.rpt.txt.zip

Brosens.Wim.With.Images.rpt.txt.zip

[former_member11696 · Accepted solution]

Hi Wim,

If you wrap the view report button in a try/catch test you get this error message:

"The system cannot find the path specified."

I tried it using the Viewer, Engine and RAS, same error in all cases.

I'll have to escalate this to DEV. Should be relatively easy to fix so likely will be in SP 14 in 3 or so months.

You can create an Exception event to handle every error something like this:

private void crystalReportViewer1_Error(object source, ExceptionEventArgs e)

{

    string eError = "";

    int StringLen = 0;

    eError = e.Exception.Message.ToString();

    StringLen = eError.Length;

    if (StringLen >= 61)

    {

        if (eError.Substring(0, 61) == @"The remaining text does not appear to be part of the formula.")

        {

            MessageBox.Show("Possible missing UFL or actual error in formula");

            e.Handled = true;

        }

        else

        {

            MessageBox.Show("Trigger Event - Error in Viewer: " + e.ToString());

        }

    }

    else

    {

        if (eError.ToString() == "The system cannot find the path specified.\r")

            MessageBox.Show(eError);

        else

            MessageBox.Show("Possible missing UFL or actual error in formula");

        e.Handled = true;

    }

}

Thanks for the report, works exactly as you described which makes it easier for R&D to debug.

Don

Message was edited by: Don Williams After looking at the error I found it was text I created to catch missing UFL's the report depends on. Update my code to handle this error also.

[wim_brosens · Accepted solution]

Hi Don,

It's been a while, but I was waiting for the release of SP14, which I just tested. The problem still exist 😞

Can you give me a time window when this bug will be solved ?

Kind regards,

Wim

[former_member11696 · Accepted solution]

Hi Wim,

Sorry, there was 2 cases that were logged around this same issue and I missed updating this post...

I had another look at this one and even in CR Designer if I try to export the without images report it prompts for log on.

So I believe what the issue is you need a registry key to tell CRD and SDK when exporting to save subreport data also.

This can happen on row based reports, exporting to PDF is a Page based export so it does not need the subreport data, even though there is none.

Row based exports need to evaluate the subreport data so it can then determine if the data is there or not but it requires the subreport to be logged on.

For your app see if this registry key resolves the issue for you, its a string type:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\SavedData - GenerateDataForAllSubreportInstances = Yes

Refresh the report and then export the report again and see if it then stops prompting for log on info.

And to make this work in CR Designer it needs this key:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\SavedData

Thanks again

Don

PS - you can now find all of these registry keys in this KBA -

https://i7p.wdf.sap.corp/sap/support/notes/2165260

[wim_brosens · Accepted solution]

Hi Don,

Because our app is running in 64-bit mode, I've added the registry key under the 64-bit hive (HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\SavedData) instead of under the Wow6432Node hive:

This actually solved this issue ...

When will this solution be available in a SP (e.g. SP15) for the CR.NET Runtime 13.0.x (32- and 64-bit) ?

Will it be solved in a SP for CR2008 Suite ? Timing ?

Kind regards,

Wim.

PS: Your link for all the registry keys (KBA) is not available ?

[former_member11696 · Accepted solution]

That is the solution.... add the registry key to your installer.

Search for the KBA number at the end of the url - 2165260

Don

[former_member183750 · Accepted solution]

Click here for the KBA.

You can find most CR KBAs here on SCN by just entering the number in the search box in the top right corner.

Re. CR 2008. This version  of CR was only 32 bit.

- Ludek