Author Topic: Aligning lists of different lengths one below other  (Read 314 times)

Offline mlodugu1

  • Full Member
  • ***
  • Join Date: May 2015
  • Posts: 11
  • Forum Citizenship: +0/-0
Aligning lists of different lengths one below other
« on: 13 Aug 2017 10:06:21 pm »
Hi all,

I am enhancing an existing report that displays a list with 34 columns (23 attributes and 11 measures). The list also displays totals. The task is to display the data in the list in 3 sections one below another as below:

1. The data with filter  (code =  3)
2. The data with filter  (code = 4)
3. Grand totals for the entire data without any filters.

The approach used currently involves taking 3 query references of the existing query and creating 3 lists one below the other where the last list simply displays grand totals. Even though I got the amounts correctly I could not align the totals (11 totals) of the third list with those of the list above it. Since I do not have any attributes in the 3rd list except for the total values, I used a dummy column 23 times once for each attribute and set width to match the columns in the list above .

Now I am facing the tedious challenge of having to set the width of each column of all the lists as well as the size of each list. In addition, any change in numerical values may cause misalignment of fact columns.

Please suggest alternatives or workarounds to achieve the result mentioned above.


Offline New_Guy

  • Statesman
  • ******
  • Join Date: Mar 2016
  • Posts: 308
  • Forum Citizenship: +15/-0
Re: Aligning lists of different lengths one below other
« Reply #1 on: 22 Aug 2017 07:16:33 am »
I would try placing a block in the list cells and moving the text into the blocks and setting the size of the blocks to the maximum length of the text that you are expecting in the lists. And in the last list place another block in each column with the same size as the block in the lists above.
Good luck
New guy

Offline Invisi

  • Community Leader
  • *****
  • Join Date: Sep 2016
  • Posts: 233
  • Forum Citizenship: +6/-3
    • Invisi - Vision on Information
Re: Aligning lists of different lengths one below other
« Reply #2 on: 22 Aug 2017 08:27:28 am »
Why place a block in the cells? You can also give width to an individual cell / column. The columns also have the setting Size & Overflow.
Few can be done on Cognos | RTFM for those who ask basic questions...