As my Master table I'm using Customer, and attempting to use the Detail Tables of Invoice.CustomerRef and Transaction.CustomerRef.
My report shows the transaction number, the date of the payment transaction, invoice number, po, rep, paid status and paid amount.
My issue is filtering the report to the correct date range and paid status. I have a Detail Band that's using "Customer.Transaction.Customer" as it's Data Member. When I attempt to create a formatting rule, I cannot find the appropriate fields (transaction date, transaction number).
In the Formatting Rules Editor, if I change the Data Member to Customer.Invoice.Customer I get the following error: "Index and Count must refer to a location within the buffer." I have no idea what that means or how to fix it and be able to filter on the fields I need to filter on.