Constrain Found Set Confusion
I've been working on this for the better part of the weekend and seem to have made no progress in spite of searches on this forum, and various attempts at understanding through trial and error.
I am running a database that is keeping track of invoices, and product inventory. I need to create monthly reports for the sake of reporting sales tax in two states, I would like these reports to display data sorted by invoice with itemized products listed within each invoice, separated by state over the date range.
I have no problems constraining the invoices/data within the date ranges but cannot constrain the invoices/data with respect to the state they have been sold to.
This is where my current attempt is at:
Set Variable [$$TAX_REGION ; value:Company Dashboard::Tax Region Sort]
Go to Related Record [Show only related records, Match found set; From table: "Invoice Data; Using layout "Monthly Sales Tax" (Invoice Data); new window]
Set Field [Invoices::Tax Region; $$TAX_REGION]
Constrain Found Set [ ]
Thank you for your help.