Re: [dabo-users] Report: Break group on more than one variable

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