Retrieve report metadata for Crystal Reports for Enterprise with command table

[rguziy]

Hi All,

I am using the following SAP Crystal Reports RESTful Web Service to retrieve report metadata for Crystal Reports for Enterprise: http://sap_host:6405/biprws/infostore/14566/rpt/structure

As result, I have the following response for Crystal Report for Enterprise which includes Command table:

As you can see, this response includes command table name and db fields for this table, but does not include SQL expression to understand how this command table was generated from real relational db tables.

For example:

Here is how this command table looks from "SAP Crystal Reports for Enterprise 4" tool:

The question: how we can get this information (SQL expression ) with SAP API.

Notes:

1. For classic (2013, 2106) crystal reports we can use "IReportAppFactory.openDocument" method from RAS API to get this information. But this method does not work for enterprise crystal reports.

2. I am using SAP BusinessObjects BI Platform 4.2 Support Pack 7 Version: 14.2.7.3069.

--

Thanks, Ruslan

[jerryjanda]

Thank you for visiting SAP Community to get answers to your questions. I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members -- as well as provides details about tags. For example, you might want to include Crystal Reports tags as well.

After, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question).

--Jerry

[DellSC]

Unfortunately, this capability is not available in the RESTful SDK for Crystal. I suggest opening a request in the Customer Influence site (used to be IdeaPlace). You can find the stuff for Crystal Reports here: https://influence.sap.com/sap/ino/#/campaign/897

-Dell

[rguziy]

The following improvement request has been created for this issue: https://influence.sap.com/sap/ino/#/idea/240530/

Thanks Dell.

[DellSC]

Great! I just upvoted it.

-Dell