Recently a customer asked us to build a report to give them visibility to their item sales. The report needed to have quantity, cost, extended price and Gross Margin.
This article contains the SSRS .rdl file and the stored procedure to power it. The finished report looks like this.
