Hello People!

I am having some truble making my summaries look as desired...this could be the problem of my DB design but perhaps you can help me.

I have one file (LineItems.fp5) that has:

enunique ItemID and Many Worker_ID that have/use many Product_ID.

the desired output should look like this:

===================================================

ItemID [abc-1234]________________________

................Worker_ID[7]

-------------------Product_ID [101]

-------------------Product_ID [131]

-------------------Product_ID [231]

................Worker_ID[56]

-------------------Product_ID [234]

-------------------Product_ID [678]

-------------------Product_ID [120]

==========================================================

I have tried to lay-it-out as:

[Header]

[sub-Summary by Item_ID (leading) ] -contains Item_ID

[sub-Summary by Worker_ID (leading) ] -contains WorkerID

[body]- contains Product_ID

but no luck..the Products used by a particular Worker are not being "looped"

What am I doing wrong?

Thank you all for the help!

well guys..I don't know what to say ..I just ran the same report and let the wizard generate the look and the script and it Works?! I don't know what to say...compleatly the same as I had it posted! so I guess, the post is the solution!

All the best!

This confirms that the FM Wizard for Sub-Summary report is really a good tool !

Hi Leb, hi Ugo,

I suppose you did NOT forget to actually sort on Item, Worker and Product ID?

I ask this because even though "FM Wizard for Sub-Summary report is really a good tool" it is not really a wizard; it does not do any secrect 'trick' to accomplish it's task...

Regards,

Ernst.

Hi Ernest!

Actually I have....the 1st design was done by the "wizard" and I just changed some layout look and script was being executed correctly...why it didn't work I don't know; when I re-did it using template layout it worked again.

They say that "Repetition is Mother of Knowledge"

all the best!