Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 3166 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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)
Posted

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.

Posted

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.

Posted (edited)
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 by irfah
Posted

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?

Posted
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?

Posted

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.

Posted (edited)
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 by comment
Posted
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?

Posted
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.

Posted
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

Posted
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 

Posted
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

This topic is 3166 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.