Author: Nate Lowrie
Posted: 2011-12-29 12:31:01 Link
I need a group expression in a report to start a new group when any of 3
different variables changes. Can I specify that in the expr property
and if so, what is the syntax?
Regards,
Nate
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4EFCA3D5.5030809@gmail.com
Author: Paul McNett
Posted: 2011-12-29 14:34:29 Link
On 12/29/11 9:31 AM, Nate Lowrie wrote:
> I need a group expression in a report to start a new group when any of 3
> different variables changes. Can I specify that in the expr property
> and if so, what is the syntax?
I usually use a tuple, such as:
(self.Record.customer_id, self.Record.order_id, self.RecordNumber)
Paul
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4EFCC0C5.2020406@ulmcnett.com
Author: Nate Lowrie
Posted: 2011-12-29 14:57:55 Link
On 12/29/2011 2:34 PM, Paul McNett wrote:
> On 12/29/11 9:31 AM, Nate Lowrie wrote:
>> I need a group expression in a report to start a new group when any of 3
>> different variables changes. Can I specify that in the expr property
>> and if so, what is the syntax?
> I usually use a tuple, such as:
>
> (self.Record.customer_id, self.Record.order_id, self.RecordNumber)
>
> Paul
> _______________________________________________
> Post Messages to: Dabo-users@leafe.com
> Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
> Searchable Archives: http://leafe.com/archives/search/dabo-users
> This message: http://leafe.com/archives/byMID/4EFCC0C5.2020406@ulmcnett.com
Great. Also, can I repeat a certain group a set number of times based
on a field? Or would I have to expand it out in SQL to multiple row sets?
Regards,
Nate
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4EFCC643.6040504@gmail.com
Author: Nate Lowrie
Posted: 2011-12-29 15:28:23 Link
On 12/29/2011 2:34 PM, Paul McNett wrote:
> On 12/29/11 9:31 AM, Nate Lowrie wrote:
>> I need a group expression in a report to start a new group when any of 3
>> different variables changes. Can I specify that in the expr property
>> and if so, what is the syntax?
> I usually use a tuple, such as:
>
> (self.Record.customer_id, self.Record.order_id, self.RecordNumber)
I take back my previous statement. The tuple in the expr property
doesn't work for me.
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4EFCCD67.2090400@gmail.com
Author: Nate Lowrie
Posted: 2011-12-29 15:37:58 Link
On Thu, Dec 29, 2011 at 15:28, Nate Lowrie <lowrie.nate@gmail.com> wrote:
>
> On 12/29/2011 2:34 PM, Paul McNett wrote:
> > On 12/29/11 9:31 AM, Nate Lowrie wrote:
> >> I need a group expression in a report to start a new group when any of 3
> >> different variables changes. Can I specify that in the expr property
> >> and if so, what is the syntax?
> > I usually use a tuple, such as:
> >
> > (self.Record.customer_id, self.Record.order_id, self.RecordNumber)
> I take back my previous statement. The tuple in the expr property
> doesn't work for me.
>
Nevermind. The designer choked on the change I made and therefore
didn't make it. It works now.
Regards,
Nate
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/CAGcHxzYU6d36hXV3YtRB7zF+0n5tCfm_26T0-safFeiaPq5qyQ@mail.gmail.com
Author: Paul McNett
Posted: 2011-12-29 18:05:41 Link
On 12/29/11 12:37 PM, Nate Lowrie wrote:
> Nevermind. The designer choked on the change I made and therefore
> didn't make it. It works now.
Was there a traceback with that? If the python expression you entered doesn't
evaluate for any reason, the designer/report writer should still mostly work, but of
course because that expression didn't evaluate it wouldn't know how to group the data...
Paul
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4EFCF245.1060901@ulmcnett.com
Author: Paul McNett
Posted: 2011-12-30 12:30:14 Link
On 12/29/11 11:57 AM, Nate Lowrie wrote:
> Also, can I repeat a certain group a set number of times based
> on a field? Or would I have to expand it out in SQL to multiple row sets?
Give me a real-world example to understand what you are doing. Not sure what you mean
by 'repeat a group'. The group will print as long as the group expression evaluates
identically to the prior record. Theoretically, you should be able to repeat the same
group as long as there's a non-matching record in between, but I'm not sure that's
even what you were getting at.
Paul
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4EFDF526.9060109@ulmcnett.com
Author: Nate Lowrie
Posted: 2012-01-02 07:21:25 Link
On 12/30/2011 12:30 PM, Paul McNett wrote:
> On 12/29/11 11:57 AM, Nate Lowrie wrote:
>> Also, can I repeat a certain group a set number of times based
>> on a field? Or would I have to expand it out in SQL to multiple row sets?
> Give me a real-world example to understand what you are doing. Not sure what you mean
> by 'repeat a group'. The group will print as long as the group expression evaluates
> identically to the prior record. Theoretically, you should be able to repeat the same
> group as long as there's a non-matching record in between, but I'm not sure that's
> even what you were getting at.
My real world example was printing out kit BOMs with an order packing
slip based upon order lines. So, if they ordered 3 of kit A and 5 of
kit B, the report would get the order line/product/product bom
de-normalized table and be able to repeat the group on Kit A 3 times and
Kit B 5 times.
I have since abandoned the approach and made it simplified. I just do a
single product BOM based upon a product/product bom de-normalized
bizobj. If I need to generate kit BOMs with a packing slip, I
programatically scan the list and gen the report the needed amount of times.
Regards,
Nate
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4F01A145.5060604@gmail.com
Author: Paul McNett
Posted: 2012-01-02 09:45:38 Link
On 1/2/12 4:21 AM, Nate Lowrie wrote:
> On 12/30/2011 12:30 PM, Paul McNett wrote:
>> > On 12/29/11 11:57 AM, Nate Lowrie wrote:
>>> >> Also, can I repeat a certain group a set number of times based
>>> >> on a field? Or would I have to expand it out in SQL to multiple row sets?
>> > Give me a real-world example to understand what you are doing. Not sure what you mean
>> > by 'repeat a group'. The group will print as long as the group expression evaluates
>> > identically to the prior record. Theoretically, you should be able to repeat the same
>> > group as long as there's a non-matching record in between, but I'm not sure that's
>> > even what you were getting at.
> My real world example was printing out kit BOMs with an order packing
> slip based upon order lines. So, if they ordered 3 of kit A and 5 of
> kit B, the report would get the order line/product/product bom
> de-normalized table and be able to repeat the group on Kit A 3 times and
> Kit B 5 times.
No, I guess there's no way to repeat a group like you describe. I'll have to put that
in the hopper and consider it for a while before doing anything.
Paul
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4F01C312.5040907@ulmcnett.com
Author: John Fabiani
Posted: 2012-01-02 10:41:20 Link
On Monday, January 02, 2012 06:45:38 AM Paul McNett wrote:
> On 1/2/12 4:21 AM, Nate Lowrie wrote:
> > On 12/30/2011 12:30 PM, Paul McNett wrote:
> >> > On 12/29/11 11:57 AM, Nate Lowrie wrote:
> >>> >> Also, can I repeat a certain group a set number of times
> >>> >> based
> >>> >> on a field? Or would I have to expand it out in SQL to
> >>> >> multiple row sets?>> >
> >> > Give me a real-world example to understand what you are doing.
> >> > Not sure what you mean by 'repeat a group'. The group will
> >> > print as long as the group expression evaluates identically to
> >> > the prior record. Theoretically, you should be able to repeat
> >> > the same group as long as there's a non-matching record in
> >> > between, but I'm not sure that's even what you were getting at.
> >
> > My real world example was printing out kit BOMs with an order packing
> > slip based upon order lines. So, if they ordered 3 of kit A and 5 of
> > kit B, the report would get the order line/product/product bom
> > de-normalized table and be able to repeat the group on Kit A 3 times and
> > Kit B 5 times.
>
> No, I guess there's no way to repeat a group like you describe. I'll have to
> put that in the hopper and consider it for a while before doing anything.
>
> Paul
I would add a field to group on. In this case a group BOM number. Then I
could have the three (3) BOM's repeat.
Johnf
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/24102463.i0k3HTgI2t@linux-12