How to export reports from a crystal server to a c# web application

[Former Member]

We have a Crystal Server as an organisations primary BI system and we have a C# MVC web application as an incoming/outgoing data manipulation system.

One of the functions of the C# application is to preview then generate some PDF and Excel reports to be distributed to external clients, this is currently achieved by generating the reports using Crystal for Visual Studio. Ideally, we want to store the reports on the Crystal Server, preview them on the web application and then get the web application to export those reports to PDF and Excel.

I've managed to preview the Crystal Server reports on the web application using the OpenDocument URL and I've been trying to get the web application to download the pdf stream of the document (using this url: http://<server>/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=143864&lsSfromdate=Date(2017,01,01)... but I haven't had any luck yet.

Is there a way for a C# web application to export a PDF / Excel copy of a report held on a Crystal Server?

[former_member11696 · Accepted solution]

CR for VS will not connect to a BOE server. Go to Service Market Place, log in using your Account info you got when you purchased support and download the .NET SDK for BOE and update your app to that version.

Or when you are on SAP's support site search for this KBA:

1661786 - Where do I get and how to install the SAP Crystal Reports Server, full BOE, and CR Server Embedded ( OEM ) .NET SDK on the development machine?

Don