Hi all, I have a report in which my main list needs to be split up (sectioned) based on a data item, but it needs to display other data items (singletons) and a list in the section header. I have managed to put everything into the list row with the help of a table and blocks, but the problem is that this information doesn't change when a new section starts.
So the first row of data items in the list keeps displaying repeatedly whereas it should display the first row of data items for the first section, second row for second section, and so on... also the list item also does not section.
Any help would be appreciated. Cognos 8.3 on Windows, SQL Server 2005.
Try setting up a master-detail relationship between the Outer list and the inner list in the section header based on the sectioned Data item.
Hi, I got it to work by putting in 2 lists in the header, and sectioning the lists on the same data item as the main list.
After that I was able to unlock the list, put in a table and bring in all my data items to place them the way I needed.