I have an Invoice.accdb database (in MS Access) that I am pulling into a MicrosoftReportViewer. I am having trouble subcategorizing the data, and was wondering if anyone could offer a little insight please.

I would like to display the data as follows:

Invoice Date
ID Patient Name Pt ID Status PaidOrOwing
L1Desc L1Qty L1Price L1Total
L2Desc L2Qty L2Price L2Total
L3Desc L3Qty L3Price L3Total

Invoice Date
ID Patient Name Pt ID Status PaidOrOwing
L1Desc L1Qty L1Price L1Total
L2Desc L2Qty L2Price L2Total
L3Desc L3Qty L3Price L3Total

I would also like to show subtotals for all of the line totals (L1Total - L3Total) under each subcategory, and then a GrandTotal at the bottom. I cannot get this to line up and work for me no matter what I try, so any suggestions are helpful. Thanks.

This question has already been answered. Start a new discussion instead.