It's been a long time since I've had to put a report together and require some help.
I have 3 linked tables: People / Invoice Lines / Events
Tickets purchased for an Event are recorded in the Invoice Lines table.
Some of the tickets are given out free, in this case the field 'Discount' = 1 on the Invoice Lines table
I am trying to create a report which shows how many free tickets have been given to each person, for a given Event.
I have tried creating a layout based on the Event table, with a portal listing people.
I created a calculation field under People with: Count (Invoice Lines: Discount)
This results in the portal providing the total number of discounted tickets per person, for all Events, instead of tickets related to the event selected as the main layout record.
I've tried every modification I can think of but don't know if I'm close or have it setup completely wrong.
Any help would be much appreciated.