COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ramjos on 28 Oct 2009 03:34:55 PM

Title: how to create a slotted column in report out put
Post by: ramjos on 28 Oct 2009 03:34:55 PM
ID A has two records or row in database because of MAJOR

one row with ID  A   and MAJOR physics   and
one row with ID A and MAJOR chem
in data base

how user want to see in out put is only one row with ID A  and two different column MAJOR1(column name) with physic and MAJOR 2 (major 2) with chem
how can we do this
Sent at 3:28 PM on Wednesday
Title: Re: how to create a slotted column in report out put
Post by: surfjb on 28 Oct 2009 11:45:15 PM
In the list - make column titles as "start of detail". Then create a list header. Use the split rows under Structure -> headers and footers menu if the columns do not split. Then use the "merge cell" by selecting the two column on row 1.