Creating a summary view

HCL Domino Domino Forum
1

Hi there,

I have been asked to create a summary view in our Timesheet System that will hold a list of all cases a person has worked on, how much time they spent on that case and the last time they added a timesheet record.

The problem I am having is that people enter multiple timesheet records for each case and this creates more than one document in the view for that case under his/her name. What I need is one document per case code, with the total time for all documents created by that person in the next column. After that it is required to know the most recent modification date but that’s not the biggest issue right now.

Does this make any sense? If so, any assistance would be very, very appreciated!

2

Subject: Creating a summary view

Trust me, you don’t want a view, you want a report. You know, an agent that runs through a view, summarizes the data, and creates a spreadsheet (or a Rich Text report, or a Word document or something along those lines).