Re: Is it Possible to Print Subtotals in Subforms when Using Print Selection?

[Chip Scheide via 4D_Tech]

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 ligh

Re: Is it Possible to Print Subtotals in Subforms when Using Print Selection?

[Chip Scheide via 4D_Tech]

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...@li

Re: Is it Possible to Print Subtotals in Subforms when Using Print Selection?

[Douglas von Roeder via 4D_Tech]

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
>
***

[MEETING] Montreal 4D Club Meeting

[Thierry Daigneault via 4D_Tech]

The next meeting of the Montreal 4D Club will be held Wednesday March 21st at 7 
PM.

The schedule for the next meeting is as follows:
News
Questions
Presentations
- Open meeting. Bring your questions and presentations.
End of the meeting

We usually end up at some sort of restaurant after each meeting. Come and join 
us!



Address
---
254 Queen St, in Old Montreal, Quebec


Anyone can attend. Please note that the meetings are usually held in French.

If you need more information, you can check out our web page at:
http://www.macapa.com/4dmtl 

You can also write to our communications officer:
Thierry Daigneault: tdaignea...@macapa.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
**

Re: Is it Possible to Print Subtotals in Subforms when Using Print Selection?

[Chip Scheide via 4D_Tech]

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
**
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
**