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
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.
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.
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.
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
I also need same this but "Insert List Row Cells Below" is inactive state
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.