grouping of tasks in timesheet table view

[Thea]

Hi,
I've seen somewhere that the tasks in the timesheet table can be grouped
differently to how they are in the standard. Does anyone know how to do this?
At the moment the tasks are grouped by the project name and the summary
tasks. I would like to groupr them by a number field.
Thanks for any help.
Thea

 

[Gary L. Chefetz [MVP]]

Thea:

You can control the timesheet "display" by changing it through PWA
administration menu, select "Manage Views" and then select the timesheet
view. Is this what you're looking for?

 

[Thea]

Thanks Gary for your reply.
It's not exactly what I'm looking for. If I remeber right in "Manage views"
I only can add or delete fields in the timesheet table.
I would like to change the grouping of the displayed tasks. At the moment it
looks like this:

Project Name
Summary Task 1
Summary Task 1.1
Task 1
Task 2
Summary Task 1.2
and so on

Once I chanced this grouping, the first layer of the grouping was then
"submited on", like this:

12/01/06
Project Name
Summary Task 1
Summary Task 1.1
Task 1
Summary Task 1.2
16/01/06
Project Name
Summary Task 1
Summary Task 1.1
Task 2
and so on

This happend by accident, I don't know what I did to get this and it
disapaered after we instaled the full version over the trial version we first
had.

Now I would like to groupe the tasks by a financel controlling number which
is assigened to each task. What I would like to do in the end is: export the
timesheed table to excel and in that export I would like to see the amount of
houres one as worked for a controlling number.

Since I changed the grouping once I guess there is a possibility to do this
for any displayed field, but as I said, I changed it by accident and have
absolutly no idea what I did.
Thanks!
Thea

 

[Gary L. Chefetz [MVP]]

Thea:

You probably grouped them in your personal view on the View My Tasks page.
If you add the field(s) you need, you can do this on a one-off basis. If
your intention is to export to Excel, you can regroup by your code in Excel.
You might also look at SQL reporting services to build your solution.