Jump to content

This topic is 3372 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)
  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 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
  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?

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

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

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

This topic is 3372 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.