I know very little about SQL or SSRS, but I need to create a report from my Online Print Solutions Data. Basically I need to create a report showing charges. My problem is there are Cart charges, and Item charges and I can't get my head around how to do this. Cart charges apply only to the cart, while item charges are on each item of the cart. When I pull the data the cart charge is being repeated for each item in the cart.
If anyone can point me in the right direction, I would be grateful.
Paul
If anyone can point me in the right direction, I would be grateful.
Paul
