How to use CrystalReports to avoid printing repeated `CustomerId` and total for each `CustomerId`

See more:

database

C#5.0

CrystalReports

, +

I have a table which show the sale details. I got the tbl_mdcl data using:

SELECT TOP 1000 [Invoice_No],[Invoice_Date],[CustomerId],[Med_Name],[Comp_Name],[Date_Manaf],[Date_Exp],[Qty],[Price],[Discount],[Retail]
  FROM [MMIS].[dbo].[tbl_mdcl] 

[Table containing data^]

To gather and report a monthly report using the above table ,i created a new CrsytalReportViewer and set its datasource to tbl_mdcl but it prints all its columns whereas i need something like this:
[Report to be achieved^]


Is that possible using CrystalReports?If YES,then how would i get a total for each CustomerId.I already spent 7 hours solving this but in vain