Reports Sub-Sub-Summary of same_ID?!

[Leb i Sol]

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!

[Leb i Sol]

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!

[Ugo DI LUCA]

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

[ernst]

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.

[Leb i Sol]

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!