optisyen Posted March 4, 2016 Posted March 4, 2016 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 Posted March 4, 2016 Posted March 4, 2016 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 Posted March 11, 2016 Posted March 11, 2016 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 Posted March 11, 2016 Posted March 11, 2016 48 minutes ago, irfah said: He means that @irfah How do you know what @optisyen means?
irfah Posted March 11, 2016 Posted March 11, 2016 (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 March 11, 2016 by irfah
comment Posted March 11, 2016 Posted March 11, 2016 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 Posted March 11, 2016 Posted March 11, 2016 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?
Fitch Posted March 11, 2016 Posted March 11, 2016 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 Posted March 11, 2016 Posted March 11, 2016 (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 March 11, 2016 by comment
Fitch Posted March 11, 2016 Posted March 11, 2016 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?
comment Posted March 12, 2016 Posted March 12, 2016 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.
irfah Posted March 12, 2016 Posted March 12, 2016 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 Posted March 12, 2016 Posted March 12, 2016 The calculation is helpful only for the 'total of current page' part; the other parts are rather trivial. See the attached example. TotalOfPage.fp7 1
irfah Posted March 12, 2016 Posted March 12, 2016 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
irfah Posted March 15, 2016 Posted March 15, 2016 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now