Running total by page with PDF output

[Corrigon]

Hi there everyone, I have a problem and I'm not sure how to solve it.

I have to prepare a report for the tax department of a country that my company trades in. There is zero wiggle room in meeting this particular requirement and I'm struggling.

The report is a list from a relational data set showing transactional data (payments to suppliers). The report must be a specified number of rows per page (35).

At the end of each page there must be a field showing the rolling total per page. To expand, on page 1 the total field would show the total for page 1. On page 2,it would show the total for pages 1 & 2. On page 3, it would show the total for pages 1, 2, and 3 etc. The number of pages in the report will number in the hundreds, and cannot be predicted in advance (as the report is prompted to show transactions in a month, so will obviously vary.

Output must be in PDF. I am using Report Studio 10.1.

So, I'm pretty much stumped as I have never been asked for something like this before. Does anyone have any suggestions?

Thanks in advance!

[BigChris]

Hi - I've never had to do that before, so this is all in theory rather than from practical experience...

To get the 35 lines per page, could you create a page set based on int(running-count([PaymentNumber])/35). I think that ought to give you 1 for the first 35 records, 2 for the second etc.

The total at the bottom could be more tricky...I'd be tempted to experiment with a field in the footer for the page around running-total([PaymentAmount] for Report)

[Corrigon]

Hi - I've never had to do that before, so this is all in theory rather than from practical experience...

To get the 35 lines per page, could you create a page set based on int(running-count([PaymentNumber])/35). I think that ought to give you 1 for the first 35 records, 2 for the second etc.

The total at the bottom could be more tricky...I'd be tempted to experiment with a field in the footer for the page around running-total([PaymentAmount] for Report)

Thanks very much for your thoughts BigChris - the number of rows restriction was the lesser of two evils and I resolved this prior to seeing your reply.

I tried putting a field in the footer of the report using the expression you suggested  running-total([PaymentAmount] for Report) but it would only reflect the total of the entire list column, not the cumulative total by page. So no luck there.

[BigChris]

Just checking...did yo put that in the page footer, or the report footer?

[gpreddy1986]

HI

Here is the solution with example

=> Take list with tow columns Order Number and Quantity,
=>Create the data Item RowCOunt --  running-count ([Order number])
=>Create another Data Item RowsPerspage - ceil([RowCOunt]/20)
=>Create Grouping on RowsPerspage Data Item by dragging this field into the list and then created total on Quantity
=>Then Create the another dataItem "Calc_Total" with expression running-total ([Quantity]).
=>Unlock the report  and then drag "Calc_Total"into summary cell

Regards,
GP

[Corrigon]

Thanks guys, and apologies for the delay in my response. I was having my first ever experience with tonsillitis last week. Unpleasant.

BigChris - as to your question - I had the summary in the report footer.
gpreddy1986 - I will give your method a shot this week and let you know how I get on.