AnsweredAssumed Answered

Constrain Found Set Confusion

Question asked by RyanMcReynolds on Apr 26, 2015
Latest reply on Apr 27, 2015 by RyanMcReynolds


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.