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!
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)
Quote from: BigChris on 11 Mar 2016 05:14:35 AM
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.
Just checking...did yo put that in the page footer, or the report footer?
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
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.