You should be able to Control-Click to select multiple Resources.

Yes I can, which can be cumbersome when there are a lot of users.  It would be nice if we can save it similar to saved filters.
However, more importantly, it is still grouping the report by Project and then user.  I would like to see it the other way, by user and then by project.

Understood.

We will implement for 4.5 release (end of year).

Ok, thanks Harvey.  Looking forward to this, as it will make my life a lot easier.
In the meantime, what query can I create which will ultimately give me the same result?

May I also request at the same time to include in the next release, creating the ability so that certain users or groups of user, can be notified when issue status's change to specific status types?  Specifically, after a developer implements their change, they mark the issue status to Ready For Testing, I would like the QA Team Lead to be notified when an issue status changes to Ready For Testing, so that it can be assigned to a member of his team.  I think it would be great if you can make this setting either global to all projects with the ability to possibly set it differently (different member alerts) for different projects.

I would be extremely grateful if you could formally log your requests @ http://gemini.countersoft.com !

Created GEM-4085 .
Do you have a sql script which I can execute to get the time report requested above?

I am posting this in case anybody else wants to make use of it.  I created these 2 TSql queries/scripts.

The first is a query which only returns on each user row, the sum total of hours and minutes that user logged in the past week.  The second is a script which returns the sum total (hours + minutes) for both the project and Time Type logged for each user in the past week.

SELECT timereport.*, SUM(timereportb.hourslogged) sumhours, SUM(timereportb.minuteslogged) summinutes
FROM (
    SELECT usr.firstname + ' ' + usr.surname as [UserName],
           proj.projectcode as projectcode,
           proj.projectname as projectname,
           issue.issueid as issueid,
           issue.summary as issuesummary,
           time.hours as hourslogged,
           time.minutes as minuteslogged,
           time.comment as timecomment,
           timetype.timetypename as timetype,
           time.timeentrydate as timefor,
           time.created    as timeentereddate
    FROM geminitimetracking time
         join geminiusers usr on time.userid = usr.userid
         join geminiissues issue on time.issueid = issue.issueid
         join geminiprojects proj on time.projectid = proj.projectid
         left join geminiissuetimetype timetype on time.timetypeid = timetype.timetypeID
    ) timereport
cross join (
    SELECT usr.firstname + ' ' + usr.surname as [UserName],
           proj.projectcode as projectcode,
           proj.projectname as projectname,
           issue.issueid as issueid,
           issue.summary as issuesummary,
           time.hours as hourslogged,
           time.minutes as minuteslogged,
           time.comment as timecomment,
           timetype.timetypename as timetype,
           time.timeentrydate as timefor,
           time.created    as timeentereddate
    FROM geminitimetracking time
         join geminiusers usr on time.userid = usr.userid
         join geminiissues issue on time.issueid = issue.issueid
         join geminiprojects proj on time.projectid = proj.projectid
         left join geminiissuetimetype timetype on time.timetypeid = timetype.timetypeID
    ) timereportb
where timereport.UserName = timereportb.UserName
  and timereport.timefor between DATEADD(wk, DATEDIFF(wk, 6, DATEADD(wk,-1, getdate())), 6) and DATEADD(wk, DATEDIFF(wk, 5, DATEADD(wk,-1, getdate())), 5)
group by timereport.UserName,timereport.projectcode,timereport.projectname,timereport.issueid,timereport.issuesummary,timereport.hourslogged,timereport.minuteslogged,timereport.timecomment,timereport.timetype,timereport.timefor,timereport.timeentereddate
order by timereport.UserName, timereport.timetype, timereport.timefor, timereport.projectcode, timereport.issueid

---

IF OBJECTID('tempdb..#temp') IS NOT NULL
  drop table #temp

select *
  into #temp
  from (
        SELECT time.entryid as id,
               usr.firstname + ' ' + usr.surname as [UserName],
               proj.projectcode as projectcode,
               proj.projectname as projectname,
               issue.issueid as issueid,
               issue.summary as issuesummary,
               time.hours as hourslogged,
               time.minutes as minuteslogged,
               time.comment as timecomment,
               timetype.timetypename as timetype,
               time.timeentrydate as timefor,
               time.created    as timeentereddate,
               CONVERT(numeric(6,2),0) as timetyperunningtotal,
               CONVERT(numeric(6,2),0) as userrunningtotal
            FROM geminitimetracking time
                 join geminiusers usr on time.userid = usr.userid
                 join geminiissues issue on time.issueid = issue.issueid
                 join geminiprojects proj on time.projectid = proj.projectid
                 left join geminiissuetimetype timetype on time.timetypeid = timetype.timetypeID
         ) timereport
where timefor between DATEADD(wk, DATEDIFF(wk, 6, DATEADD(wk,-1, getdate())), 6) and DATEADD(wk, DATEDIFF(wk, 5, DATEADD(wk,-1, getdate())), 5)
order by UserName, timetype, timefor, projectcode, issueid

declare @Id int
declare @UserName varchar(150)
declare @ProjectCode varchar(20)
declare @ProjectName varchar(50)
declare @IssueId int
declare @IssueSummary varchar(2000)
declare @HoursLogged smallint
declare @MinutesLogged smallint
declare @TimeComment varchar(2000)
declare @TimeType varchar(50)
declare @TimeFor as Date
declare @TimeEntered DateTime
declare @RunningTotal float
declare @RunningHours int
declare @RunningMinutes int
declare @LastUser varchar(150) = ''
declare @LastTT varchar(50) = ''
declare @TTRunningTotal float
declare @TTRunningHours int
declare @TTRunningMinutes int

DECLARE @cur CURSOR
SET @cur = CURSOR STATIC FOR
            select
              from #temp
            order by UserName, time_type, time_for, project_code, issue_id
           
OPEN @cur
FETCH @cur INTO @Id,@UserName,@ProjectCode,@ProjectName,@IssueId,@IssueSummary,@HoursLogged,@MinutesLogged,@TimeComment,@TimeType,@TimeFor,@TimeEntered,@TTRunningTotal,@RunningTotal
           
WHILE (@@FETCH_STATUS <> -1)
BEGIN
  if (@UserName <> @LastUser)
  begin
    set @RunningTotal = 0
    set @RunningHours = 0
    set @RunningMinutes = 0
   
    set @TTRunningTotal = 0
    set @TTRunningHours = 0
    set @TTRunningMinutes = 0
  end
  else if (@TimeType <> @LastTT)
  begin
    set @TTRunningTotal = 0
    set @TTRunningHours = 0
    set @TTRunningMinutes = 0
  end
 
  set @RunningHours = @RunningHours + @HoursLogged   
  set @RunningMinutes = @RunningMinutes + @MinutesLogged
  set @RunningTotal = (@RunningHours + (@RunningMinutes/60)) + ((@RunningMinutes%60).01)
 
  set @TTRunningHours = @TTRunningHours + @HoursLogged   
  set @TTRunningMinutes = @TTRunningMinutes + @MinutesLogged
  set @TTRunningTotal = (@TTRunningHours + (@RunningMinutes/60)) + ((@RunningMinutes%60)*.01)
       
  update #temp
    set timetyperunningtotal = @TTRunningTotal,
        userrunning_total = @RunningTotal
  where id = @Id
 
 
  set @LastUser = @UserName
  set @LastTT = @TimeType
  FETCH @cur INTO @Id,@UserName,@ProjectCode,@ProjectName,@IssueId,@IssueSummary,@HoursLogged,@MinutesLogged,@TimeComment,@TimeType,@TimeFor,@TimeEntered,@TTRunningTotal,@RunningTotal
END   
CLOSE @cur
DEALLOCATE @cur
select * from #temp
delete from #temp

Thanks for sharing.