Doug,
I looked for the report I mentioned, which if I could find would
probably allow me to resolve your issue with subtotals...
but it is not in any current system, and the old system i think it
might be in I can not get into, as I have forgotten the PW..
I will try again this evening to see if I can get into that system.
and yes I know that print form would require a bunch of coding, but...i
have not used area/print list... i figured it might/would be easier
then starting from scratch, and since the forms you would need to print
from already exist (the existing report and subforms). You would need
to duplicate a some of the forms, and set the markers, but the code for
print form is pretty straight forward. It seemed to me that it would
not take as much work as the plugins.
Chip
On Mon, 19 Mar 2018 11:15:13 -0700, Douglas von Roeder wrote:
> Chip:
>
> Print form is a 4D *command* and, yes, it allows me "complete control".
> That's a nice way of saying that I'll have to write a lot of code to use it
> because, by itself, the Print form command doesn't accomplish much.
>
> In contrast, PrintList Pro is a *product* that allows me to print arrays or
> fields in one line of code but also has another couple of dozen commands to
> let me do formatting, break level processing, calculated columns, etc. In
> the same way that I use a "3rd party product" like 4D because the IDE and
> database engine have the features that I need, I use a 3rd party products
> like ALP and PLP because *they* have the features that I need. Q.E.D.
>
> This particular application is rife with code and techniques from the 90's
> - subtables, "included areas", fixed size windows, Before, During, and
> After, etc. As time goes by, we're moving to AreaList Pro so we'll be able
> to use the tight integration of AreaList Pro and PrintList Pro to make
> things easy to print. I've been able to update this particular report with
> some small changes that the customer wanted but it appears that subtotals
> aren't doable without rewriting the report.
>
>
> --
> Douglas von Roeder
> 949-336-2902
>
> On Sun, Mar 18, 2018 at 8:48 PM, Chip Scheide <4d_o...@pghrepository.org>
> wrote:
>
>> it is a lot of work, but probably less then using a plugin or component
>> you *could* rewrite the report using print form.
>>
>> You already have the base versions of the various forms you would need to
>> print with from the subtables
>> you would also have complete control at that point.
>>
>>> 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
>>>> <4d_o...@pghrepository.org> 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 <
>>>>>> 4d_tech@lists.4d.com> 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 <
>>>>>>> 4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com
>>>>>>> ************************************************************
>> **********
>>>>>> ************************************************************
>> **********
>>>>>> 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:4d_tech-unsubscr...@lists.4d.com
>>>>>> ************************************************************
>> **********
>>>>> ------------
>>>>> 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:4d_tech-unsubscr...@lists.4d.com
>>> **********************************************************************
>> ------------
>> Hell is other people
>> Jean-Paul Sartre
>>
---------------
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
**********************************************************************
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:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
