There seems to be huge interest in the BusinessObjects product suite. So, after the great feedback on my first blog I will try to complete my series on the BusinessObjects products in combination with SAP products more quickly.
In this blog I will focus on Crystal Reports in combination with SAP BW queries.
This screenshot shows the query I will use to demonstrate Crystal Reports.
The query is based on the SAP Demo Sales and Distribution Overview cube (0D_SD_C03).
In the rows I will request information for the Calendar Year / Month, the Customer (Sold-to-party) and the Material.
In the columns I will request the key figures Open Orders and Open Orders Qty.
BEx web reporting provides this result set:
Building a report with Crystal Reports based on this BW query is simple.
After the installation of the SAP Integration Kit there is a new toolbar in Crystal Reports. This toolbar is specifically designed for integration with SAP BW and allows you to use the typical role menus from the SAP BW system.
By using the SAP toolbar in Crystal Reports I can leverage the standard role menus and select the BW query for a new report.
After selecting the query, the requested information is available in the field explorer from Crystal Reports.
As shown in the image above, Crystal Reports received all the key figures and all the characteristics.
The following is a quick overview of how Crystal Reports treats elements from a BW query:
Now I can use all of these elements and have the complete functionality of Crystal Reports.
This creates a report showing me the Order Value and Order Qty for each month and it allows me to drill down on each month to see the Top 10 customers for the selected entry.
Here the start of my report:
And the view after a drill down on March:
All screens are taken from the Crystal Reports Designer tool. The user can also view all the reports via the BusinessObjects Enterprise platform in a web client and still use the same navigation functionality.
This was just a short introduction showing how Crystal Reports can leverage a BW query. I focused on explaining how elements from a BW query are returned to Crystal Reports (rather than focusing on report design). In my next blog I will explain formatting capabilities in more detail and demonstrate how to easily create a balance sheet as well as using highlighting and alerting functionalities with Crystal Reports.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |