A lot of big enterprises use SAP’s Crystal Reports when it comes to generate and send PDF documents. There are two reasons for this:

  1. There is no decent PDF export built in the standard reporting tools.
  2. Crystal Reports offers several features to generate a pixel-perfect design for printouts


However, from our experience, the usage of SAP Crystal Reports in addition to a dashboard frontend such as SAP Design Studio also has some downsides:

  1. You have twice the effort for the same content: First build the dashboard for online usage, then build the Crystal report for the printout.
  2. You need an additional consultant with SAP Crystal Reports know-how.
  3. Visualizations have to be built and set up twice.
  4. Some custom visualizations that you employ in the dashboard tool may even not be available in Crystal Reports, they might look different or have to be custom built.


Now wouldn’t it be great to have a built-in PDF export feature for SAP Design Studio that:

  1. Reuses the content of the dashboard
  2. Reuses the setup of tables, charts and other components
  3. Supports detailed customization of PDF documents and pixel-perfect layouts

All in all, such a feature would minimize efforts to create PDF documents immensely. SAP Crystal Reports would have to be used for the really special reporting cases!

Now let me tell you that the use of the subjunctive is wrong here. Cause there is already an add-on to SAP Design Studio that offers this feature: Our biExport for SAP Design Studio!

Let’s say we have the following Design Studio dashboard:

/wp-content/uploads/2016/08/dashboard_1026964.png

Not only does biExport allow you to reuse the content of the dashboard or – if necessary – multiple dashboards at once. It also allows you to rearrange content for the print out. To create fully individual headers and footers for the PDF document.

The most stunning feature is the usage of Word documents as templates for the PDF export!

The simple idea behind this: Why introduce a new proprietary tool to define title pages, headers and footers, table of contents, to include headings, images and texts. Why not reuse what is already there and known to almost everyone: Microsoft Word.

To layout a PDF document for SAP Business Intelligence has never been so easy:

  1. Open Word and load your corporate Word master document
  2. Edit the title and add static contents like texts, images, chapters
  3. Where content of the dashboard shall be included, define a placeholder
  4. Customize the arrangement of the placeholders if needed (e.g. by using tables)

Placeholders consist of the name of the component you want to export, surrounded by “%” as you can see in the following example.

To export a chart, for example, you write %CHART_1%.

To export a table, you write %CROSSTAB_1%. If you want to include it as a native Word table, you write %CROSSTAB_1%:TEXT.

SupplierFactSheet_1.png

And you are already done! Simply specify the new document as a Template for PDF Export, and you will receive a beautiful document as the following – perfect for external reporting, supplier fact sheets or customer fact sheets!

SupplierFactSheet_2.png

SupplierFactSheet_3.png

Your reporting users will love you for these beautiful PDF exports – though your effort was reduced to a minimum!

Now I am curious about your feedback! We are looking forward to demo this feature to you in a live session!

Thilo Knötzele

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Bogdan Popescu

    I think you guys did a very good job! It is a very clever way to print dashboards. I like this development.

    I am curios how many object types will be recognizable at the end e.g: filters, buttons etc.

    Regards,

    Bogdan

    (0) 
    1. Thilo Knötzele Post author

      Hi Bogdan,

      thanks for your great feedback!

      We do support all standard types of Design Studio. PLUS all custom components that might be in use in your dashboard!

      In my example, the charts I used are in fact custom charts developed by another SAP partner Archius.

      When it comes to include contents of the components as native text (e.g.not to include the dropdown box but the selected content), we support:

      – Crosstabs

      – graphomate Tables

      – Simple and Formatted Text

      – Dropdown Boxes

      – Input Fields

      – Filter Line

      More and more components are added upon request.

      You can even try it out yourself by registering on http://www.designstudio-export.com.

      Take care

      Thilo

      (0) 

Leave a Reply