Print Page - Merge cell in excel 2007

Title: Merge cell in excel 2007
Post by: ajen7118 on 06 Apr 2017 05:33:54 PM

Hi,

Could you please take a look at attachment and advise the best to resolve?

I would like to show merged cell when output to excel 2007.

thank you

Title: Re: Merge cell in excel 2007
Post by: ajen7118 on 10 Apr 2017 01:57:44 PM

anyone can help this?

thank you all so much

Title: Re: Merge cell in excel 2007
Post by: New_Guy on 11 Apr 2017 01:15:10 PM

Hi,
Once you place a list inside the cell it will create a seperate cell. I think eeven a singleton will do the same. Did you try a layout calculation. And also what are you trying to show in that list.
Good luck
New guy

Title: Re: Merge cell in excel 2007
Post by: ajen7118 on 12 Apr 2017 05:16:10 PM

Hi New Guy,

I joined two of my queries into one and used the data item directly instead of inserting a list and setting up master detail relationship between two queries.

It resolved the issue.

thanks.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ajen7118 on 06 Apr 2017 05:33:54 PM