There should be a link present for each field used as a section. Both the master and the detail queries shown will be the same source query. In the properties for the crosstab object, click on Master Detail Relationships (MDR) to open that property page. Click OK on the new page informational message that pops up.ģ) Via the Select Ancestor up-arrow button, select the Crosstab ancestor. Optional: Click on a section, then click the Sort button and modify the setting as necessary.Ģ) Click the highest level section in the report, then click on Structure from the Cognos menu, then click Set Page Break Using Master/Detail. The process may work the same for a List report, although testing remains to be done to verify this.)ġ) Set the field(s) for level(s) of the report as Section(s), beginning with the highest level, via the Cognos toolbar. I found two ways to do this that have the same result, except for a difference in page set naming, so I'll post the shorter version. It comes down to carefully setting properties for master/detail relationships, along with grouping and sorting property settings. Thank you for any help and/or references that you can offer!Īfter experimenting, I came up with a procedure that seems to work each time for this kind of a report structure. So, I have two questions at this point:ġ) When setting up a crosstab report (or any report in general) that has sections/headers, what is the best procedure to use in getting page breaks at any particular section level? (Or, is there some different ""better way"", perhaps page layers, or whatever else may work?)Ģ) Now that I have developed a crosstab report in which the page breaks just won't work no matter what I try, is there any procedure I can use to attempt to fix the pagination problem? At times I have received a message from Cognos saying it will do the desired page breaks, but even then it still does not work.
Cognos page layers how to#
It seems like a simple task, but I have tried many, many combinations of settings, and have also tried to find info online on how to do this successfully, but the page breaks will not show up. I need to have the report skip to a new page (page break) whenever the lowest level section's value changes. If you still have problems, check out the Index topic "no data > specify what appears for a data container.I have a Cognos 10 crosstab report that has a hierarchy of three different sections/headings at the top of it. Pretty cool, actually, but buried in the documentation. You can customize a message to be displayed using that second page. Setting this value to yes creates two tabs at the top of the page, one for a page to be displayed if data is returned, and another for instances when no records are found. Not sure if this is an available feature of 8.3, but in 8.4 there is a new "No Data Contents" property for data containers (lists, blocks, etc.). I'll edit this post with any ideas I come up with. I'm sorry I don't have an answer at the moment on how to fix it, but I was planning to look into work arounds next week. (Obviously, if it exists in 8.3 and it has been carried forward to the next version, it's not a high priority.) We reported it to Cognos as a bug - Not sure if they've assigned a bug tracker id to it, but we got the impression it wasn't going to be fixed soon. We ran into this same problem when upgrading reports from 8.2 => 8.4. This seemed like such a useful enhancement in 8.3 but we haven't gotten it working yet. We've never used any conditions to hide or display the header or the footer and in 8.3 now this seems to be an issue. RowNumber()=0 or RowNumber() is null to conditionally hide data objects in the body of the report. I've tried stripping out the extra layers with no success thus far. we have a list object embedded within a table object. The issue seems to be related to embedded data objects, i.e. We have very complex reports using Oracle SQL and in most cases the Header content is linked to a SQL statement to render output from the database as well as list the parameters passed in. And the No Data Content message does not appear as well. Not even the header or footer appear on the page. However if we test the report (pass in parameters expecting no results), we are returned a blank page (pdf, html, excel output). Report looks in order if results are returned. Upgrading from 8.2 to 8.3 and testing out the new No Data Content functionality.
0 kommentar(er)
