Schedule a report (Crystal, Crystal Reports for Enterprise) with params

[former_member330044]

Schedule a report (Crystal, Crystal Reports for Enterprise) with params, create PDF, retrieve ID and filestore URL, using RESTFul WS.

I thought this would be simple but I have struggled for 3 days on trying to get this to work. First, Standard Crystal Report doesn't seem to be supported using web services. I converted the Crystal Report 2013 version to Crystal Reports for Enterprise 4 and went through several explanations..

1. I am able to create a logon token (X-SAP-LogonToken)

2. What I need to do is the following:

a. Call a RESTFul webservice to schedule a report with parameters. This schedule should run "now" and create a PDF file in the default location specified in BI.

b. I need to extract the details of that schedule, ID, PID, File Location URL, ex. and pass that data back to the calling application (which is also a webservice)

The documentation is very unclear on how to do this. Would this be better handled through a custom Java or .NET application? I would assume that this is a very common request and I'm not sure why this information isn't easily accessible.as far as the RESTFul WS API is concerned.

Any help would be greatly appreciated.

Thanks,

Branden

[DellSC · Accepted solution]

Unfortunately, the RESTful web services will not let you schedule either type of report with parameters. The Crystal-specific parts of the RESTful web service will not work at all with "classic" Crystal reports and there currently is no way to schedule Crystal for Enterprise reports with parameters from them.

While SAP's intention is to eventually have the RESTful Web Services replace all of the other SDKs that are available for BOBJ, they aren't there yet. They add new functionality with each service pack, though.

-Dell

[former_member330044 · Accepted solution]

Thank you, Dell!

[DellSC · Accepted solution]

Also, I have some older C#.NET sample code for scheduling Crystal reports available on my website: http://www.dellstinnett.com/sample_code.html. Look for "BOEScheduleCrystal". The code would have to be tweaked or converted to Java, but it should give you a sample of the steps you need to take to schedule using the BI Platform SDK.

-Dell

[former_member330044 · Accepted solution]

Dell--

Thank you. I will review. I Just needed to schedule a report, with parameters, to a pdf. I need the name of the file written at run time, meaning that as I schedule the report, an ID will be sent by the requesting webservice and the file will be generated using that ID.

For example, from our Claims system, I'm using claim ID: 1234567890. When I schedule the report, the name of the file should be 1234567890.pdf. Make sense?

Thank you for all of your help!

-Branden

[DellSC · Accepted solution]

Makes perfect sense. Your code will have to get the claim ID prior to scheduling the report and then use that as the file name as part of the scheduling process.

-Dell

[former_member230921]

As dell.stinnett-christy mentioned, "schedule with report specific parameters for CR" is not supported by REST APIs.

JAVA SDK: https://help.sap.com/viewer/0225aa3e7b4b4b17b2d4a882e6f2de96/4.2.5/en-US/45a66b0e6e041014910aba7db0e...

For Webi Reports schedule APIs: Page No. 617 - 626 https://help.sap.com/http.svc/rc/1eeee826c0154c62a5cbd29359ecbc18/4.2.5/en-US/sbo42sp5_webi_restws_d...

For CR specific REST APIs : https://help.sap.com/viewer/0945312ac81f4b63be258130d2938055/4.2.5/en-US/45cecf3f6e041014910aba7db0e...

[former_member330044]

Thank you for the links! I wish I could accept 2 answers.

-Branden