Troubleshooting
Problem
Unable to display multiple data containers on the same HTML page in Cognos. Even after adjusting the rows per page for each container, only one of the containers shows on the first page.
Symptom
n/a
Cause
For HTML output, the report property option Page break by data container for interactive HTML controls whether the default number of rows is rendered for each data container on each page.
You must set the Page break by data container for interactive HTML option to Yes. The default value is No.
You must set the Page break by data container for interactive HTML option to Yes. The default value is No.
Resolving The Problem
"Controlling the Rows Per Page for Multiple Containers in HTML and PDF"
If you have more than one data container in a report, such as a list and a crosstab, you can control how the report is rendered in HTML and PDF by setting the "Rows Per Page" property for each container.
For HTML output, the report property option "Page break by data container for interactive HTML" controls whether the default number of rows is rendered for each data container on each page. You must set the "Page break by data container for interactive HTML" option to Yes. The default value is No.
Cognos uses the following rules when rendering reports in HTML and PDF:
Steps:
https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/c_cr_rptstd_intrd_rows_per_page.html
If you have more than one data container in a report, such as a list and a crosstab, you can control how the report is rendered in HTML and PDF by setting the "Rows Per Page" property for each container.
For HTML output, the report property option "Page break by data container for interactive HTML" controls whether the default number of rows is rendered for each data container on each page. You must set the "Page break by data container for interactive HTML" option to Yes. The default value is No.
Cognos uses the following rules when rendering reports in HTML and PDF:
- If the Rows Per Page property is not set for any of the data containers, 20 rows per page are rendered in HTML and each page is completely filled in PDF. The first data container is rendered until there is no more data, followed by the next container, and so on. Tip: The number of rows that appear on a PDF page depends on the font size set in the report.
- If the Rows Per Page property is set for each data container, the specified numbers of rows are rendered in HTML and PDF on each page until there is no more data.
- If the property is set for only some of the containers, the specified numbers of rows are rendered in HTML and PDF on each page until there is no more data. For the remaining containers, 20 rows per page are rendered on each page in HTML and each page is completely filled in PDF. For example, you have two lists, List1 and List2. You set the Rows Per Page property to 5 for List1. When you run the report in HTML, the first page contains the first 5 rows from List1 followed by the first 15 rows of List2.
- If no data is returned for a data container, an empty container is rendered.
Steps:
- Open the report in Report Studio
- Go to file, Report Properties
- Change the 'Page break by data container for interactive HTML' dropdown to 'YES'
https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/c_cr_rptstd_intrd_rows_per_page.html
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.1;10.2.1.1;10.2.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Report Authoring","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.x;11.1.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
1038256
Was this topic helpful?
Document Information
Modified date:
27 September 2019
UID
swg21342757