If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How do u insert a blank row

Started by Kaja, 29 Jan 2009 03:59:55 PM

Previous topic - Next topic

Kaja

Does anyone know how to insert a blank row in a report after the totals aggregate as in below. This is a list report by the way

Name         Item   Postage   Packaging   Total
Sam          Book       4.53       2.00         6.53
                Letter     1.50       1.00         2.50
Total                      5.53       3.00         9.03

Mike          Book       5.00        4.00        9.00       
Total                      5.00        4.00        9.00

Tom          Letter      2.33        2.20        4.33

kaevne

I tried to do this with my report and I can't seem to find a way either.  Maybe with the conditional styles?

However, what you can do is add a blank crosstab space after Total so that there's a space that is owned by each person.  It'll look like:

Mark Total
       Revenue
       |Space    |
Jim   Total
etc


It doesn't look the same but it still accomplishes the extra space between aggregate info.

lebronjames

kaevne is right. there is no actual way to insert a blank row in a list report. It's only possible in a crosstab.

But one time, I needed to do that same thing and what I did was add about 0.5 inches padding on the bottom of the totals row. Then I set the vertical alignment to top. I also made all the borders white so that the report was like looking at a Word doc.

This does take away some of the professional appearance but if you are ok with that, it works to separate the individual data. My report was just an ad-hoc one so it didn't need to look pretty. Just needed to be read quickly.

Good luck.

Gopinath

Select a cell in the footer
go to(Menu) Structure --> Headers & Footers --> Insert List Row Cells Below

this will add a blank row below the footer.

Kaja

Thanks Gonipath. It worked. What I ended up doing was merging the list row cells across the report and then inserted a block object inside the row and added some padding above and below

Mounika_LP

I also need same this but "Insert List Row Cells Below" is inactive state

Lynn

Quote from: Mounika_LP on 16 Feb 2015 10:24:55 AM
I also need same this but "Insert List Row Cells Below" is inactive state

Do you have any header or footer or grouping defined in your list? I don't think you'd have the option to insert rows otherwise.