Dynamic reports with related tables

[Kostanzas200]

Hey guys, I am trying to dynamically sort a report with controls that are in the header. And the report items themselves are in two related tables.

I have a drop down list to select a company and I want every record for that company to show up in the report, however only the first record shows up.

Please check out my file at http://www.mediafire.com/?ifdlzjdrgn2

and check out the Invoice Report layout to understand what I am talking about.

[mz123]

Your Invoice Report layout should be based on the Table occurrence "Tip Log"

Click on "GTRR" on the Invoice Layout. A new window will pop up taking you to the related records in the Invoice Report layout, which is now tied to the TO "Tip Log"

Hope that helps!

ReedyCreekInvoicing.fp7.zip