it has been a long time since I did subform subtotals... I'll look for the code/system on monday.
I'll probably have to find the one report I did... 2 or 3 subforms, and 3 or 4 text areas all variable frame, with break points etc. quite a beast! But from memory... don't forget to sort the data ...ONE LEVEL EXTRA! place... sort on one more data bit then the break levels i.e.: break level 2 Order selection([subtable];[subtable]field1;>[subtable]field2;>;[subtable]field3;>) > Chip: > > Thanks for the reply. > > That tracks with the code that I put together after RTFM but no joy. > > I'm hitting On printing break in the parent form but never hitting it > in the subforms. I can get a variable to print in the Break 0 area of > the subform but the Subtotal function returns 0. > > Live and learn, eh? > > -- > Douglas von Roeder > 949-336-2902 > > On Sun, Mar 18, 2018 at 7:00 AM, Chip Scheide > <[email protected]> wrote: >> Doug, >> >> if you have subforms set to print variable frame you need need to >> make sure the 'Z' order is correct also, otherwise variable frame >> printing will not work correctly. I do not remember which way it is, >> but it is either: >> lowest (on the 4D from) is lowest and top most variable frame object >> is top, >> or >> vise versa. >> >> some code to help(?) >> only one level of break processing... >> you may need to have one more level of break processing set then you >> actually want. >> ie. : break level(3) for a 2 level break processing report, but that >> might be ancient history >> >> -- setup for printing -- >> >> // clear sub and grand totals >> l_Animal_Grand_Total:=0 >> l_Cage_Grand_Total:=0 >> r_Cost_Grand_Total:=0 >> l_Animal_Sub_Total:=0 >> l_Cage_Sub_Total:=0 >> r_Cost_Sub_Total:=0 >> >> //locate records >> QUERY SELECTION([Cage_Counts];[Cage_Counts]Laboratory_ID=$Lab_IDs->{$i}) >> // setup values to (sub)total >> ACCUMULATE([Cage_Counts]Number_of_Animals;\ >> [Cage_Counts]Number_of_Cages;\ >> [Cage_Counts]Daily_Cost) >> //set break level >> BREAK LEVEL(1) >> >> -- in the form method -- >> : ($Form_Event=On Printing Break) >> l_Animal_Sub_Total:=Subtotal([Cage_Counts]Number_of_Animals) >> l_Cage_Sub_Total:=Subtotal([Cage_Counts]Number_of_Cages) >> r_Cost_Sub_Total:=Subtotal([Cage_Counts]Daily_Cost) >> >> l_Cage_Grand_Total:=l_Cage_Sub_Total+l_Cage_Grand_Total >> l_Animal_Grand_Total:=l_Animal_Sub_Total+l_Animal_Grand_Total >> r_Cost_Grand_Total:=r_Cost_Sub_Total+r_Cost_Grand_Total >> >> >>> Philippe: >>> >>> Agreed ― PrintList Pro has tons of features, including subtotaling and >>> PrintList >>> Pro is one of the reasons why I've haven't needed to use commands like >>> Print selection since the early 90's. The app uses AreaList Pro, >>> fortunately, but we weren't planning on adding PrintList Pro to the >>> application until "the next version". I may have to modify that >> part of the >>> plan if we can't use Print selection. >>> >>> "BTW AreaList Pro v10 also now provides break processing. I’ll >> show you at >>> the Summit." - I'm looking forward to that! >>> >>> >>> -- >>> Douglas von Roeder >>> 949-336-2902 >>> >>> On Sat, Mar 17, 2018 at 5:52 PM, Philippe Ganter via 4D_Tech < >>> [email protected]> wrote: >>> >>>> Douglas, as you know PrintList Pro has offered this feature for ages. >>>> SuperReport Pro can do it, too. >>>> >>>> BTW AreaList Pro v10 also now provides break processing. I’ll >> show you at >>>> the Summit. >>>> >>>> Best regards, >>>> -- >>>> Phil >>>> forums.e-node.net >>>> >>>> >>>>> On 18 Mar 2018, at 00:51, Douglas von Roeder via 4D_Tech < >>>> [email protected]> wrote: >>>>> >>>>> I'm working on a legacy application that uses Print selection. >> The report >>>>> consists of the main page, which is populated by the values in >> the parent >>>>> table and uses a subform from the revenue table and a second >> subform from >>>>> the expense table to print related records. The goal is to print >>>> subtotals >>>>> for the expense and revenue records. >>>>> >>>>> Having not used print selection for a couple of decades, I >> approached the >>>>> task with some trepidation and was, unfortunately, not able to Break, >>>>> Accumulate, and Subtotal my way to victory. >>>>> >>>>> Based on the description I've provided, is it possible to do break >>>>> processing + subtotals on subforms using Print selection? If so, >> what is >>>>> the sequence of commands that are needed? >>>>> >>>>> I would sincerely appreciate any sample code that might shed some light >>>> on >>>>> this. >>>>> -- >>>>> Douglas von Roeder >>>>> 949-336-2902 >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> ********************************************************************** >>>> 4D Internet Users Group (4D iNUG) >>>> FAQ: http://lists.4d.com/faqnug.html >>>> Archive: http://lists.4d.com/archives.html >>>> Options: https://lists.4d.com/mailman/options/4d_tech >>>> Unsub: mailto:[email protected] >>>> ********************************************************************** >>> ********************************************************************** >>> 4D Internet Users Group (4D iNUG) >>> FAQ: http://lists.4d.com/faqnug.html >>> Archive: http://lists.4d.com/archives.html >>> Options: https://lists.4d.com/mailman/options/4d_tech >>> Unsub: mailto:[email protected] >>> ********************************************************************** >> ------------ >> Hell is other people >> Jean-Paul Sartre > ------------ Hell is other people Jean-Paul Sartre ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
