Repeat Crosstab Labels in CSV Output Format

By default, labels are not repeated for a nested cross-tab when the output is in CSV format.

This ensures upgrade compatibility with previous builds of IBM® Cognos® software. However, you can have nested crosstab row and column labels repeat in CSV format output by setting the report server advanced property RSVP.CSV.REPEAT_XTAB_LABELS to True.

Note that RSVP.CSV.REPEAT_XTAB_LABELS is a system level setting and applies to all CSV files. In a distributed environment using multiple dispatchers, ensure that you set this property for the report service and batch report service for each dispatcher. This same report server advanced property also applies to charts, which appear in a similar fashion to crosstabs, when output to CSV format.

Procedure

  1. Start IBM Cognos Connection.
  2. In the upper-right corner, click Launch, IBM Cognos Administration.
  3. On the Status tab, click System.
  4. From the All Servers drop-down menu, click Services, Batch Report.
  5. From the drop-down menu for BatchReportService, click Set properties.
  6. Click the Settings tab.
  7. For the Environment category, next to Advanced settings, click the Edit link.
  8. If it appears, select the Override the settings acquired from the parent entry check box. Otherwise, proceed to the next step.
  9. Enter the RSVP.CSV.REPEAT_XTAB_LABELS property and set the value to True.
  10. Click OK.
  11. Repeat steps 4 through 10 for Services, Report, ReportService.
Parent topic: Customizing the Functionality of IBM Cognos Software