COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Abdel on 24 Jun 2015 03:30:16 PM

Title: Format on Excel
Post by: Abdel on 24 Jun 2015 03:30:16 PM
Hi there,

I am experiencing trouble with formatting a report. Your help is greatly appreciated!!!

My report is an Income Statement to an excel file. I simply want to place the "Net Income" label directly under "Total Expenses". See attached screenshots for a better view.

Note: I already tried Padding but the output on excel is the same cell.

Abdel
Title: Re: Format on Excel
Post by: Abdel on 24 Jun 2015 03:31:51 PM
See Current Excel Format ....
Title: Re: Format on Excel
Post by: Abdel on 24 Jun 2015 03:32:59 PM
See Ideal Excel Format ....
Title: Re: Format on Excel
Post by: bdbits on 24 Jun 2015 05:47:03 PM
Is this a list or crosstab? I would guess a list, but...
Title: Re: Format on Excel
Post by: Abdel on 24 Jun 2015 05:48:00 PM
I think its a LIST
Title: Re: Format on Excel
Post by: bdbits on 24 Jun 2015 05:59:29 PM
This may work for you, kind of depends on the list structure.

Select the <#Net Income#> cell.
Select menu item Structure > Headers & Footers > Split List Row Cell.
Unlock the list (the padlock in the toolbar).
Drag and drop <#Net Income#> over one cell.