Post

2 followers Follow
0
Avatar

Multiple sort parameters in Work Report - is this possible?

Hi there,
I wish to run a custom requirements report with the results sorted by multiple criteria.
For example I wish to report all requirements in my project sorted: -
First by Type
Within the Type sort I want the requirements sorted by Source and then Priority.

So if I had two Types (say "Business Rules" and "Functional"), two Sources (say "Fred" and "Melissa") who raised some requirements as follows: -

Req-1 Melissa Business Rule Priority 1 "Always have lunch"
Req-2 Fred Functional Priority 2 "Walk to work"
Req-3 Fred Business Rule Priority 1 "Submit timesheet by Friday"
Req-4 Melissa Business Rule Priority 3 "Leave desk tidy"

I want the report to list these in the following order: -

Business requirements
Req-3 Fred Business Rule Priority 1 "Submit timesheet by Friday"
Req-1 Melissa Business Rule Priority 1 "Always have lunch"
Req-4 Melissa Business Rule Priority 3 "Leave desk tidy"

Functional
Req-2 Fred Functional Priority 2 "Walk to work"

I can do the first bit with $repeatRequirementsSortType but not sure if or how I can do the sub-sorts.

Best regards,
Alan

Alan Sinclair-Brown

Please sign in to leave a comment.

1 comment

0
Avatar

Alan,

Check out the group by 3 properties example report, copied below. Hope this helps.

The report templates in this folder are intended to supplement the Custom Reports User Guide (available from the Help menu). Many contain examples of advanced reporting features. For basic information on custom reports, you should consult the user guide. You can generate reports from all templates in this folder to see how they behave. If you have not already, you should click the “Edit Template” button to view the report template and see how it is constructed.

You can group by an arbitrary number of properties, although 3 levels is probably the limit of usefulness. The thing to note in this example is that the endgroupCurrentGroup keywords must include the “By” portion of the group keyword so that Case Complete can distinguish between them (e.g. endgroupCurrentGroupByPriority). With 2 levels or less, you can just use endGroupCurrentGroup.

Use Cases grouped by release, then by Assigned to, then by priority, then sorted by ID:
$groupUseCasesByRelease
Release: $Release
$groupCurrentGroupByAssignedTo
Assigned To: $AssignedTo
$groupCurrentGroupByPriority
Priority: $Priority
$tableCurrentGroupSortID $ID $Name
$endgroupCurrentGroupByPriority

$endgroupCurrentGroupByAssignedTo

$endgroupUseCases

Kevin Chase 0 votes