Show unique parent records for current user

Question

Looking for a way to show a summary type list of items. In my application I have a Projects table and a Time Entries table. Projects can have many Time Entries.

I also have a Team Members table. A Team Member can have multiple Time Entries.

I'm trying to create a summary type report which would show the Current User a list of all Projects to which they have logged any time. I do not want to view each of the individual time entries, but just a list (non-repeating) of the project name.

Example:

Time Entries (table)

Team Member	Date	Project
Bob Smith	7/1/2024	Project A
Bob Smith	7/2/2024	Project A
Bob Smith	7/1/2024	Project B
Bob Smith	7/2/2024	Project B
Sally Jones	7/1/2024	Project A

Report would then Display:

Bob Smith
Project A
Project B
Sally Jones
Project A

EmberKrumwied · Accepted Answer

Apologies for not being clearer or holding a greater understanding of the application. I was stuck in the mindset that I needed to create a Summary field (via table-to-table relationships). I had previously attempted an actual Summary Report, but the results I was getting only showed a total number, not the names. I believe I have created a Summary Report that gives me the essence of what I am seeking. It is built summarizing (by distinct count) the Related Project field. It is then grouped by my Project Name field then by Related Team Member. I should now be able to filter this report so that the results will be based on the current user. I do wish I could not show the distinct count column, but that is a small issue.

MarkShnierYou · Answer

You should be able to do this by making a summary report in the Time Entries table.   Also, if you do in fact want to limit the results to time entries for the current user, and you have a user field on the time record for whose time it is, then you can add a file term to the summary report for there the Team Member userid is the current user

Sign up

Login to the community