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: [email protected] 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
