Show reporting TOTAL TRANSFERRED

[optisyen]

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)

[comment]

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.

[irfah]

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.

[comment]

  On 3/11/2016 at 11:48 AM, irfah said:

He means that 

Expand  

@irfah

How do you know what @optisyen means?

[irfah]

  On 3/11/2016 at 12:37 PM, comment said:

@irfah

How do you know what @optisyen means?

Expand  

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, 2016 by irfah

[comment]

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?

[irfah]

  On 3/11/2016 at 1:41 PM, 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?

Expand  

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

[Fitch]

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.

[comment]

  On 3/11/2016 at 3:51 PM, irfah said:

we are planning to see 30 records on each page.

Expand  

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.

 

  On 3/11/2016 at 8:54 PM, Fitch said:

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

Expand  

I don't quite see how that would help.

 

 

Edited March 11, 2016 by comment

[Fitch]

  On 3/11/2016 at 10:32 PM, comment said:

I don't quite see how that would help.

Expand  

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?

[comment]

  On 3/11/2016 at 11:56 PM, Fitch said:

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

Expand  

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.

[irfah]

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

[comment]

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

See the attached example.

TotalOfPage.fp7

[irfah]

  On 3/12/2016 at 2: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

Expand  

It seems that everything that we need is ok.

I will check detailed tomorrow.

Thanks for your helps. @comment

@optisyen 

[irfah]

  On 3/12/2016 at 2: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

Expand  

This is exactly what we would like to have.

Thank you very much @comment

[optisyen]

Thank you very much

@comment  ; @irfah