C# Export Report to SAP Crystal Server and retrieve the OpenDocURL

[treesap213]

Is it possible to export a crystal report to an OpenDocURL. Uploading a Crystal Report to the server will generate the OpenDoc URL as well. Is it possible to upload the report to the server and retrieve the URL through a C# program?

[DellSC]

I changed the tags on your question to get you a better answer. Crystal Server is a limited version of the SAP BusinessObjects software, so the .NET SDK that you're should be using is actually the one for BOBJ (assembly version 14.x.x.x), not the one for Crystal Reports (assembly version 13.x.x.x).

-Dell

[DellSC]

You cannot export to an OpenDocument URL directly from Crystal. However, you can use an OpenDocument URL to run a report or to view a previously run instance.

You can use the .NET SDK to publish a report to Crystal Server. I will try to find my code for doing this and post it tomorrow.

-Dell

[JWiseman]

In SAP BI 4.3 (I'm using CR Server) you can use sOutputFormat to render the report without having to create an instance...not sure when that was changed. i.e. Right after publication if you grab the CUID you can utilize opendoc and the output param like the following to create an xls file etc.

http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AXlkNw3_0OtNtYdl...

[treesap213]

Hi Dell, were you able to find the code for this?

[JWiseman]

To hopefully answer your first question, "Is it possible to export a crystal report to an OpenDocURL" you can use opendocument's sOutputFormat param to specify the output format of a report.

sOutputFormat | SAP Help Portal

• H (HTML)
• P (PDF)
• E (Microsoft Excel (XLSX))
• XLS (Microsoft Excel (XLS) - Crystal Reports only)
• W (Rich Text Format (RTF) - Crystal Reports only)