Print section at the bottom of the page

Question

Post reply

Print section at the bottom of the page

martin-325528

SSChasing Mays

Points: 626
More actions
October 1, 2010 at 7:47 am

#227485

I'm trying to produce a report (an invoice as it happens) that always puts the totals at the bottom of the page. The reason is that the main body of the invoice could be of varying height - depending on the number of records, size of the text - but the totals need to appear at the bottom of the page.
Anyone have any ideas how this can be achieved? Annoyingly Crystal Reports has this ability which I used a lot for this type of report.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Doug Lane SSCrazy Points: 2118 More actions · Answer 1

Have you tried putting a duplicate table in the page footer and just showing the total row(s)?

martin-325528 SSChasing Mays Points: 626 More actions · Answer 2

As far as I can see you can't put a table/matrix into the footer.

Doug Lane SSCrazy Points: 2118 More actions · Answer 3

Right, because a table in the page footer would just be too simple, wouldn't it? Here's a more educated guess (assuming each report is only one page long): try putting a details table inside a fixed-size rectangle. Put a duplicate table below the rectangle with the totals. Play around with the size and settings until the rectangle doesn't grow or bump the totals table into a second page.

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 4

My mockup may have been too simple, but I got something similar to what you described by adding a second table for the totals, then placing the Location property (under Position) for that 2nd table (in its entirety) at 0in left, 6in top, which shoves it down the page, even though I only have 3 rows in my table.

Does that help?

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

martin-325528 SSChasing Mays Points: 626 More actions · Answer 5

Thanks for both your suggestions. I've, for the moment at least, used text boxes in the page footer to host the totals. I'll also try out putting a second table at fixed height which should also work.

Unfortunately as a result I've had to remove having vertical lines on the invoice layout as I can't ensure that they will extend to the bottom or go to a second page.

Cody Konior SSCarpal Tunnel Points: 4827 More actions · Answer 6

martin-325528 (10/6/2010)
Unfortunately as a result I've had to remove having vertical lines on the invoice layout as I can't ensure that they will extend to the bottom or go to a second page.

You can sleep tight, I've encountered the same problem and had to do exactly the same thing as you 🙂

It's annoying you can't use dud tables in headers/footers just for lining things up. You must use text boxes. If you need to show totals, you have to have the totals in the query, and then use a First(Fields!Totals.Value, "DataSetName") to reference it in the header/footer.

And then you have to get rid of the vertical lines because there's no way to get them to extend to the bottom of the report on pages other than the first one. Sigh.

martin-325528 SSChasing Mays Points: 626 More actions · Answer 7

Thanks for confirming I wasn't just being a muppet! I shall rest easy now, knowing it wasn't just me.