Reen:

Not knowing the report my thinking is that you want to start with Sales Analysis and link in the IC tables. Linking the item number in SA to IC Items then allows you to link from IC Items to the other IC tables.

If you are looking for one line per item then summarize the data and report only the group footer.