Accessing Crystal Reports from SAP Design Studio using Report Linking

What if there is a client requirement that calls for the powerful visualization of SAP Design Studio and the highly formatted data presentation of Crystal Reports ? Well, the ideal solution for that would be to use Report linking, which is similar to the Report-to-Report Interface functionality in BW, from SAP Design Studio to Crystal Reports.  It is straightforward and very easy to use.

I had a SAP Design Studio dashboard that showcased a lot of KPIs across several views using attractive visualization and a Crystal Report that provided the detailed record of the KPIs across different dimensions. I then added a report launch button to the dashboard, which when clicked, would link the Crystal Report to SAP Design Studio, with the parameters passed.

Let me walk you through the steps required to achieve this.

 Steps for Report Linking

To demonstrate the functionality, I created an Accounts Receivable dashboard in SAP Design studio 1.3 SP1. The report was designed using SAP Crystal Reports for Enterprise 4.x.

 

SAP Design Studio - Accounts Receivable Dashboard

SAP Design Studio – Accounts Receivable Dashboard

To keep things simple, I have used a single value prompt here. But we can add multiple variables with multi-select option as well, to be passed to the report from the dashboard. Here I’ve passed the value “USA” from the dashboard, in the document link of the report.

The document link of the report can be extracted from the BOBJ launch pad. Right click on the document and go to document properties.

Crystal Report - Document Link

Crystal Report – Document Link

 

The document link, with the parameters concatenated to the link, needs to be passed in the  APPLICATION.OpenNewWindow() function. Following is the code written in the On Click event of my launch button, to open the report in a new window.

SAP Design Studio - On Click Event for Button

SAP Design Studio – On Click Event for Button

My variable’s technical name is prefixed with an lsS which signifies that I’m passing a single value variable to the report. Listed below is the prefix to be attached to the technical name of the variable depending on the type of variable used.

Types of Variables Used in SAP Design Studio

Types of Variables Used in SAP Design Studio

Below is a snapshot of the  report launched from SAP Design Studio, filtered on the value of the variable for country, “USA”.

Drill down from SAP Design Studio to Crystal Report

Drill down from SAP Design Studio to Crystal Report

 

In case the report does not fetch data, check the variable screen to ensure that the prompt value was passed as required.

 

Variable Sscreen

Variable Screen

Points to Note

  • If the launch button has to trigger a report created using Crystal Reports 2011, then you will have to prefix the variable prefix (here ‘lsS’), with an ‘X’.
  • You can use any type of variable you want, in the data source, except for the selection option variable. It does not work well with Crystal Reports.
  • The maximum number of variables that may be passed also depends on the max no of characters that your browser supports. For instance, IE has a max character limit of 2048. One way to cut down on the length is to avoid passing blank values to non-mandatory variables.
  • This feature is only partially mobile device compatible, since the behavior of the APPLICATION.OpenNewWindow() function is unpredictable in iOS 7.
  • This technique is comparable to the RRI functionality in BW. RRI is on the Design studio road map, yet to be supported.

 

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com