Loading Profile...
Is there a way create reports that are "grouped by" a particular field
I currently have a report that shows tasks assigned to users:
Which produces the report below:
Is there a way that I could group this report by the name of the developer as follows:
I couldn't see a group-by macro so I assume I'l have to create nested reports. What's the best way of doing this, and is there a big performance hit associated with nesting reports?
The reporting and scaffolding plugins are great products by the way!
Regards,
Simon
{report-table}
{content-reporter:space=TASKS|scope=Java Tasks>children|type=page}
{text-sort:data:Developer}
{date-sort:data:Release}
{natural-sort:data:Status}
{text-sort:content:title}
{text-filter:data:Developer|required=true}
{text-filter:data:Status|exclude=Released}
{content-reporter}
{repeat-filter:data:Developer}
{report-column:title=Developer|width=10em}*{report-info:data:Developer}*{report-column}
{report-column:title=Task|width=5em}{report-info:content:title|link=true}{report-column}
{report-column:title=Application|width=5em}{report-info:data:Application}{report-column}
{report-column:title=Description|width=35em}{report-info:data:Desc}{report-column}
{report-column:title=Status|width=10em}{report-info:data:Status}{report-column}
{report-column:title=Release|width=7em}{report-info:data:Release|format=MMMM yyyy}{report-column}
{report-column:title=Priority|width=5em}{report-info:data:Priority}{report-column}
{report-empty}
No tasks are currently assigned to developers
{report-empty}
{report-table}
Which produces the report below:
Is there a way that I could group this report by the name of the developer as follows:
I couldn't see a group-by macro so I assume I'l have to create nested reports. What's the best way of doing this, and is there a big performance hit associated with nesting reports?
The reporting and scaffolding plugins are great products by the way!
Regards,
Simon
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?Hello Simon,
Could you please post your scaffold task template to see if I can help? -
Inappropriate?At the moment, the only way is with sub-reports. There is a 'grouping-reporter' on the way which may help (I'll have to check if it actually helps with that kind of report - it's actually intended for more statistical stuff like 'count', 'sum', etc).1 Comment
Add a comment
This answers the question
-
Hi David,
Thanks for the reply. Is there a way that I can report on unique data items?
In this case I would first need to find all unique Developers, and then create a sub-report for each one. "Developers" is defined as {text-data:Developer}
Regards,
Simon -
Inappropriate?Hi Joe,
Here's the scaffolding template:
h1. Description
{text-data:Desc|type=area|width=75%}Enter a brief description of the task{text-data}
|| Platform | {list-data:Platform}{list-option}PC/Unix{list-option}{list-data} ||
|| Application | {list-data:Application} {list-option}eDev{list-option} {list-option}DMP{list-option} {list-option}RAS{list-option} {list-option}Backflow{list-option} {list-option}EDC{list-option} {list-data} ||
|| Priority | {list-data:Priority}{list-option:1 - High}High{list-option}{list-option:2 - Medium}Medium{list-option}{list-option:3 - Low}Low{list-option}{list-data} ||
|| Release | {date-data:Release|format=MMMM yyyy|minYear=-1|maxYear=+1} ||
|| Developer | {text-data:Developer}{text-data} ||
|| Status | {list-data:Status} {list-option}Waiting to Start{list-option} {list-option}In Progress{list-option} {list-option}Development Testing{list-option} {list-option}SIT{list-option} {list-option}UAT{list-option} {list-option}Awaiting Release{list-option} {list-option}Released{list-option} {list-data} ||
Would it help if the Developer field was a list rather than free form text?
Thanks for your help,
Simon -
Inappropriate?It would be simpler to accomplish if your developers were in a user group and set via {user-options}. That way you just do a {user-reporter:group=my-developers} and go from there.
However, with the current structure, you could probably do it with a {repeat-filter}, similar to how you have it now. Just change the {report-table} to a {report-block}.
EMPLOYEE
