Printable View
Trying to write a productivity report which measures tasks that users complete (running totals from 1 table) and the time they were logged in from another (last logout - first log in).
after i've added the login measure to the report it duplicates the running totals based on the amount of login/logout records there are for each user (i.e. if they've logged in and out of the dB 3 times then their running totals will be 3 times the correct figure)
Any ideas?
link the tables
create group on the first tables on the user
create group on the date in and date out of the 2nd table.
From the first group get the user
from the header of the first get the first date don't over write if the date in is there. From the footer of the 2nd group get the date date out.
In the footer of the first table's group (users) get the time spent.
The other way is to link the table create the user group
get the min date in and max date out for that user.