Export to PDF Problem with Crystal Viewer Control

[Former Member]

Hi All,

I am using a crystal report viewer in asp.net. When I load the report and click on export > pdf, I get the following displayed in the web page:

"Failed to export using the options you specified. Please check your options and try again. ". I get this error for everything that I select to export as (such as excel).

I am using Visual Studio 2008 and Crystal Reports 2008.

Any ideas why the export functionality of the Viewer isn't working?

Thank you in advance.

[Former Member · Accepted solution]

Hi Antoine,

Have you appied any service pack for Crystal Reports?

With Visual Studio 2008 Service pack 0/Service pack 1 of Crystal Reports 2008 is required.

Issue is on development or deployment environment?

Please check that are you able to export report through Crystal Report designer.

Regards,

Shweta

[Former Member · Accepted solution]

Hi Shweta,

I do have Crystal Reports 2008 SP1 installed. Issue is on development and deployment. I can export in Crystal Report Designer.

[former_member183750 · Accepted solution]

Is this a web or a win app? If it is a web app, it ay be that permissions issues are in play here. try a simple win app to see if you can duplicate the issue. If the win app works, use Process Monitor to determine what permissions are missing. Process Monitor can be downloaded from here;

http://technet.microsoft.com/en-ca/sysinternals/bb896645.aspx

Ludek

[Former Member · Accepted solution]

It's .net web app

[former_member183750 · Accepted solution]

Follow my suggestions in the previous post.

Ludek

[Former Member · Accepted solution]

I just tried your suggestions. I am not quite sure what to look for in the process monitor. Nothing looks to be blocked. All I get is a message that seems to come back from Crystal saying "Failed to export using the options you specified. Please check your options and try again. "

[Former Member]

I fixed it by adding this:

Protected Sub CrystalReportViewer1_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Init

report.Load("Intraday.rpt")

report.SetDatabaseLogon("xx", "xxx", "xxxx", "xxxx")

parameterField = report.ParameterFields("Agent Group")

parameterField.CurrentValues.AddValue("")

CrystalReportViewer1.ReportSource = report

End Sub

Edited by: Antoine Saikaley on Mar 27, 2009 6:01 PM