Crystal XI and CommerceCenter 10.5 - Item Descriptions

[SassyStacie13]

I'm in the process of writing a weekly sales report for my Sales Reps, who have been ever so helpful in letting me know what they need to see.

I am currently pulling in the qty, uom, item id, price, etc., but I need to pull in the item description. When I use the SQL information from Commerce Center, it starts pulling item description ordered on any order that week and not the description linked to the item id. What step am I missing in getting this to pull the right information?

Thanks.

 

[IdoMillet]

Check the table joins by going to Database, Database Expert, Links.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com