Applies to:

SAP BO Webi developers

Summary

This document provides a turnaround approach for limiting the no. of rows in a page to less than the default value in a business objects report. In normal scenario the minimum default value for horizontal records is 20.

Author: SriHarsha Thota

Company: Infosys Limited

Created on: 18-Sep-2013

Author’s Bio:

SriHarsha Thota:

SriHarsha has 4 years of professional experience and has expertise in SAP BO. He is a Senior Systems Engineer in Infosys and currently implementing SAP BO Reporting development projects.

Content:

Let us assume that we have a requirement where client wants to see BO reports with max n rows per page and remaining rows should go to next pages.

Suppose we have created a report and report is having around 40 rows but client needs to see only 5 rows per page and other data should go to next pages respectively.

In Business objects web-intelligence reports we have an option to format the report to limit the no. of columns and rows in a page as shown below.

/wp-content/uploads/2013/09/1_281658.jpg

If you could see the above screenshot, the minimum no. of horizontal records per page is 20 and you will not be able to reduce below that.

Note: – Even you try to enter the value less than 20 and try clicking on apply, it will change back to 20.

So let’s see a turnaround approach where you can display n no. of horizontal records where n<20.

The below example report which I am going to use is based on e-fashion universe. It contains the objects Storename, Year, Quatitysold and Salesrevenue. The output of the report is as shown below.

/wp-content/uploads/2013/09/2_281659.jpg

There are around 40 horizontal records in the report output and the client needs to see only 5 rows per page.

Steps to Format the report to 5 rows per page

1.      Create a variable for example by name v_pagebreak with the formula

v_pagebreak = Floor(RowIndex()/5)

2.      Add the variable v_pagebreak.The data would look as shown below.

/wp-content/uploads/2013/09/3_281660.jpg

3.      Apply a section on the variable v_pagebreak which would change the display as below.

/wp-content/uploads/2013/09/4_281661.jpg

4.      Right click on the section and hide it as shown below.

/wp-content/uploads/2013/09/5_281662.jpg

5.      After hiding the sections, data is displayed in the report as shown below.

/wp-content/uploads/2013/09/6_281663.jpg

6.      Right click on the section and go to format section. Check the start on a new page option in the layout.

/wp-content/uploads/2013/09/7_281664.jpg

7.      After applying the start on a new page option the data would get displayed as 5 horizontal records per page in 8 pages as there are around 40 records as below.

/wp-content/uploads/2013/09/8_281665.jpg

Note: You could even do the same using breaks instead of sections.

To report this post you need to login first.

4 Comments

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

Leave a Reply