However, you can also set "Paginate saved HTML output" available under File Menu > Report Properties to achieve the same. This property saves users from having to set a very high value for the Rows Per Page property against each report object.
Popular Posts
Showing posts with label Page Break. Show all posts
Showing posts with label Page Break. Show all posts
Monday, March 21, 2011
Avoid Paginating Saved HTML Outputs
When you burst/save HTML outputs, you must have noticed that Cognos by default paginates the outputs with the default value being 20 rows per page. In saved outputs, this causes sections of the report to repeat down the length of the single HTML page. This can be avoided by setting the rows per page property for report objects.
However, you can also set "Paginate saved HTML output" available under File Menu > Report Properties to achieve the same. This property saves users from having to set a very high value for the Rows Per Page property against each report object.
However, you can also set "Paginate saved HTML output" available under File Menu > Report Properties to achieve the same. This property saves users from having to set a very high value for the Rows Per Page property against each report object.
Tuesday, August 24, 2010
Master Query Cannot Be a Nested Query - Error Message
When you try bursting a report that has multiple pages with page breaks set on different queries, the report could throw errors "Master Query Cannot Be a Nested Query" unless you have master detail relationships set up between the Burst query and the Page Set Queries.
Master Detail relationships can be set up using the "Master Detail Relationships" property of the Page Set query.
Master Detail relationships can be set up using the "Master Detail Relationships" property of the Page Set query.
Tuesday, July 13, 2010
Practical Usage for Sectioning
Most often you would have used Sectioning for formatting reasons. Here's how you could use Sectioning, Page-break concepts to make a single list report work like 2 lists.
Requirement: Display Data for Current Year and Previous Year as 2 separate lists on 2 separate pages.
Normally you would have used 2 separate queries for the 2 list reports. Using Sectioning and Page-Break you can use a single query to achieve this. You can use this method when you need to display multiple lists that differ in terms of filters alone.
Solution:
Step 1: Drag Product, Sales, Year in to the report
Step 2: Create a filter to filter the data for current and previous year.
Step 3: Create a data item called Section Title.
Step 4: Section on the Section Title data item

Step 5: Create a page break on Section Title data item.



Requirement: Display Data for Current Year and Previous Year as 2 separate lists on 2 separate pages.
Normally you would have used 2 separate queries for the 2 list reports. Using Sectioning and Page-Break you can use a single query to achieve this. You can use this method when you need to display multiple lists that differ in terms of filters alone.
Solution:
Step 1: Drag Product, Sales, Year in to the report
Step 2: Create a filter to filter the data for current and previous year.
Step 3: Create a data item called Section Title.
case when [YEAR] = extract(year from current_date)
then 'Current Year'
else 'Previous Year'
end
Step 4: Section on the Section Title data item
Step 5: Create a page break on Section Title data item.
Subscribe to:
Posts (Atom)