If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to section ?

Started by matrixfree, 17 Dec 2015 05:28:11 AM

Previous topic - Next topic

matrixfree

Hi,

We created a list with only 1 column and decided to display LIST HEADER and LIST FOOTER.
We included a table of 3*3 in the LIST HEADER  in order to display txt and data items.

It seems to display what we need so far.

QUESTION:
Can I section the list (that has only 1 column) based on data item field that is displayed on the LIST HEADER ?

I KNOW THAT WHEN WE HAVE A NORMAL LIST WE CAN SIMPLY GROUP ON THE FIRST 2 COLUMNS FOR EXAMPLE AND THEN CLICK ON THE COLUMN(S) AGAIN AND THEN ON THE SECTION BUTTON.

I'm not able to do the same with data items that are displayed on the table (that is inside the list header)

How can we do that ?

Thanks to anyone for any valuable advices !

Lynn

Quote from: matrixfree on 17 Dec 2015 05:28:11 AM
Hi,

We created a list with only 1 column and decided to display LIST HEADER and LIST FOOTER.
We included a table of 3*3 in the LIST HEADER  in order to display txt and data items.

It seems to display what we need so far.

QUESTION:
Can I section the list (that has only 1 column) based on data item field that is displayed on the LIST HEADER ?

I KNOW THAT WHEN WE HAVE A NORMAL LIST WE CAN SIMPLY GROUP ON THE FIRST 2 COLUMNS FOR EXAMPLE AND THEN CLICK ON THE COLUMN(S) AGAIN AND THEN ON THE SECTION BUTTON.

I'm not able to do the same with data items that are displayed on the table (that is inside the list header)

How can we do that ?

Thanks to anyone for any valuable advices !

I'm not sure it makes sense to put a data item in a list header unless it will always have the same value for every row within the list. If that isn't the case then you should group on the item and create a group header for whatever you need to display above the list.

Personally, I NEVER (EVER, EVER, EVER) use sectioning. It creates a list inside of a list which is just more confusing and difficult to manage as reports tend to grow in complexity. This is especially difficult for novice users.

Just use grouping and then create a group header to achieve the same look. You can change the list property for Column Titles to At start at details. You can also split the group header and merge individual elements within the header to put things in any way you want. These functions are found in the Structure menu under Headers and Footers. You can even create additional list rows within your group header so the 3*3 table wouldn't be necessary.



matrixfree

Thank you Lynn for your fast reply.

I understand you do NOT advice to use SECTION.
When you say:
"If that isn't the case then you should group on the item and create a group header for whatever you need to display above the list."

Question: I should be able to creatde nested group headers based on your logic right?

This is somewhat the header we are aiming at:

--------------------------------------------------------------------------------------------------------------------------------------
txtTitle            DataItem (to section on)                AnotherDataItem2                      Page#

AnotherDataItem3                                                      AnotherDataItem4(to section on)
AnotherDataItem5

AnotherDataItem6

txttitle.           txtTitle.           TxtTitle
----------------------------------------------------------------------------------------------------------------------------------------

Lynn

Yes, you can have multiple group headers. They will be organized in the order of the grouping you specify in the layout grouping and sorting.