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

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