COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Steve on 04 Mar 2016 03:16:26 PM

Title: Financial Report format
Post by: Steve on 04 Mar 2016 03:16:26 PM
Hi All -

I have to make a financial report in which I need to show the expenses in the following layout:

Soldering Expenses        1000.00
Fitting Expenses               500.00

Total                             1500.00



Assembly Expenses         700.00
Packing Expenses            200.00

Total                              900.00


Grand Total                   2400.00


All of these expenses are in the same query item from the same query subject because all of these expenses have an expense code which is in the same table.
If I put the expense code and description on the list or crosstab, how would I insert a blank row and then the total in between the expenses?

What is the best way to do this ?

Appreciate your help.

Thanks
Steve
Title: Re: Financial Report format
Post by: Gopinath on 07 Mar 2016 05:25:44 AM
Click on the list footer, go to Structure menu -> Headers & Footers -> Insert list row cells above

this will add a blank row above the footer