Hi all, starting to get the hang of reports slowly but surely but struggling with one. I have two tables that are currently unrelated - Service Ticket and Timesheet. They are both in a single app to make it simple for employees to access different functions from different views but no real reason to connect them except for one…
I have a report that references the Timesheet table, displays punch in and punch out times for each day of the week along with a total number of hours paid. This is sent to payroll at the end of every week.
What I’d like to do is bring the total number of hours billed for these same employees, located in the Service Ticket table into my report so I can do a paid vs. billed comparison.
Is there any way to do this without explicitly referencing the tables to each other in the app? When I try to put an expression into the report that references a table not covered by the report itself it doesn’t send.
Thanks in advance,