SAP Knowledge Base Article - Public

1631486 - How to show repeated text on each individual line for a report

Symptom

You want to show repeated text on each individual line for a report.

This example will be based on the Opportunity Volume report however the same settings can be applied to any Browser or MS Excel Based reports. 

Reproducing the Issue

1. Business Analytics work center.

2. Open the Opportunity Volume report and choose the desired variable selection.

3. Add the Calendar Year/Month, Employee responsible, Sales partner and Country characteristics to the rows.

4. You noticed that the Calendar Year/Month value, for example Sep 2011, is shown only once for the whole group of Employee responsible.

5. You would like to have the Calendar Year/Month value displayed (repeated) for each row for each Employee responsible.

Resolution

I order to show repeated text on each individual line for a report you need to adjust the Table Setting as follow:

1. For Browser Based reports.

When you open the Browser Based report with the display format to table and click the wrench icon with the Settings tool-tip, the Table Settings dialog box appears. Using Table Settings, you can change the layout of the table.

In this case you need to tick the checkbox next to the Display Repeated Texts.

This indicator allow you to specify whether repeated texts are to be displayed more than once.

Note: By default, the setting is deactivate.

2. For MS Excel Based reports.

When you open the MS Excel Based report with the display format to table and click on the SAP Business ByDesign tab, from the menu, the icon with the Settings appears. Using the Settings options you can change the layout of the table.

In this case you need to Un-tick the Suppress Repeated Values option (the tick 'V' next to the text should disappear).

This indicator allow you to specify whether repeated texts are to be displayed more than once.

Note: By default, the setting is activated.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions