Billing records show reporting TOTAL TRANSFERRED

I could not adjust.

 

There are 3 pages report

Page 1: To write something on the top,  bottom (let's say a total of 30 records) $3520

Page 2: Above $3520;                         bottom (let's say a total of 60 records) $6920

Page 3: Above $6920;                         bottom (let's say a total of 78 records) $8310

 

What should be done this way in order to get the report?

Is there a sample file?

Waiting for help, thank you.

in Report a Product Issue • Share • Reply • Like Show 0 Likes(0)

It's difficult to understand your request. i am guessing you want to use a summary field defined as running total. For the header, subtract the current amount from the total.

Hello,

He means that when printing an invoice (multiple pages invoices), he wants to see in each page:

- total of previous pages

- subtotal of current page

and on the last page; "total of previous pages + subtotal of current page = grand total".

Could you please find a solution for this request?

Thanks.

48 minutes ago, irfah said:

He means that 

@irfah

How do you know what @optisyen means?

18 minutes ago, comment said:

@irfah

How do you know what @optisyen means?

Yes, I know what he means and I tried to explain instead of him.

He is one of my friends and asked my help to explain situation.

I also did not be able to find a solution until now.

Edited March 11, 20169 yr by irfah

It is not easy to calculate the subtotal of a page, because Filemaker does not know which record is on which page until it actually paginates the report.

Do you at least know how many records will be on each page?

2 hours ago, comment said:

It is not easy to calculate the subtotal of a page, because Filemaker does not know which record is on which page until it actually paginates the report.

Do you at least know how many records will be on each page?

Yes we are planning to see 30 records on each page. Is it possible to make a formula based on 30 records per page?

Normally I wouldn't recommend using portals to print long invoices. But in this case it might be a feasible approach. Start the portal on page 2 at row 31, etc.

As for the subtotals, one way to do this would be to grab the numbers using List, then take the MiddleValues of that list for each page, then feed it into a calculation such as this custom function.

6 hours ago, irfah said:

we are planning to see 30 records on each page.

If the records do not have to be sorted in specific order, then you could use an unstored calculation field =

Div ( Get (RecordNumber) - 1 ; 30 ) 

to sort and group them.

Otherwise, it can get more complicated.

 

1 hour ago, Fitch said:

Normally I wouldn't recommend using portals to print long invoices. But in this case it might be a feasible approach.

I don't quite see how that would help.

 

 

Edited March 11, 20169 yr by comment

1 hour ago, comment said:

I don't quite see how that would help.

It could help in controlling the page breaks, given the requirement that there is a fixed number of records per page.

It would mean printing from the context of a parent record. Not sure what that would be here. Account?

15 minutes ago, Fitch said:

It could help in controlling the page breaks, given the requirement that there is a fixed number of records per page.

I understood that not as a requirement, but as a result of having a fixed body height per record and a known page size.

But if you wanted to force a page break after every 30 records, you could do so in the part setup.

Div ( Get (RecordNumber) - 1 ; 30 ) 

Even I tried to do it in several different ways, I couldn't achieved to see these fields separately:

1- transfered total (total of previous pages) on the top of each page except of 1st page.

2- page total (Total of current page) on the bottom of each page.

3- grand total (invoice grand total ) on the last page.

 

I attached a simple database, is it possible to show me practically?

Thanks.

Sample Fİle.fmp12

The calculation is helpful only for the 'total of current page' part; the other parts are rather trivial.

See the attached example.

TotalOfPage.fp7

25 minutes ago, comment said:

The calculation is helpful only for the 'total of current page' part; the other parts are rather trivial.

See the attached example.

TotalOfPage.fp7

It seems that everything that we need is ok.

I will check detailed tomorrow.

Thanks for your helps. @comment

@optisyen 

On 12 Mart 2016 at 4:09 PM, comment said:

The calculation is helpful only for the 'total of current page' part; the other parts are rather trivial.

See the attached example.

TotalOfPage.fp7

This is exactly what we would like to have.

Thank you very much @comment

Thank you very much

@comment  ; @irfah