Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: chinnucognos on 15 Jul 2014 07:12:28 AM

Title: Columns alignment in two lists
Post by: chinnucognos on 15 Jul 2014 07:12:28 AM
Hello Techies,


I have two lists in a report which is list after list having same coloumn headers.
I have removed 2nd list column header by making 'BOX TYPE= none", now coloumns in both lists not aligned properly while runnig in html,pdf,excel formats.
Can you guys help on this.
I have tried padding and size & overflow, but miserably failed.

Thanks in advance
Title: Re: Columns alignment in two lists
Post by: mondans.sureshbabu on 15 Jul 2014 12:58:36 PM
Hi Chinnu,

I assume that  in your report you want both the lists to appear one after the other as if they were single lists. If that's the case then its a straight shot,

You should already have 2 QS's for these 2 lists (assume Q1 and Q2)now,
1. you'll have to create a new QS by doing a UNION ALL between these two QS(Q3 -> Q1 UnionAll Q2) in the Query explorer.
2. Use Q3 build your report in one list. Later change the headings of the list header as you wish by changing the text source.

Hope it works ! ! ! Let me know how it went.

-Suresh
Title: Re: Columns alignment in two lists
Post by: chinnucognos on 16 Jul 2014 04:47:02 AM
Yes, it worked.
Thanks for your valuable help.
Title: Re: Columns alignment in two lists
Post by: mondans.sureshbabu on 16 Jul 2014 11:17:41 AM
Quote from: chinnucognos on 16 Jul 2014 04:47:02 AM
Yes, it worked.
Thanks for your valuable help.

Awesome ! ! ! your welcome always
Text only | Text with Images