Member Avatar for mikeybware

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.

  • 1 Contributor
  • 1 Reply
  • 109 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by mikeybware
Member Avatar for mikeybware

I solved the issue, after troubleshooting in design mode

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.