Loading Profile...
Create a report from multiple pages data
Does anyone know if it is possible to create a report, based on multiple pages scaffold data?
Let's say we have tasks and reports reporting system. If any employee creates a task, he reports on a weekly basis. I need to create a report where I can see details on his task + details taken from his reports (actually children pages on the task page) in a single row?
Here is an example:
Sample task template code:
Sample task report code:
I repeat - it's just an example. Now I would like to create a table, where all my employees are shown and then in a single row, but different columns, to see listed all tasks for Miss X, their priority, their status, and percentage of completion. How report like this one would look like?
Thank you for your help.
Let's say we have tasks and reports reporting system. If any employee creates a task, he reports on a weekly basis. I need to create a report where I can see details on his task + details taken from his reports (actually children pages on the task page) in a single row?
Here is an example:
Sample task template code:
| Priority: |{list-data:TaskPrio|type=check|multiple=false|required=true}
{list-option}Priority 1{list-option}
{list-option}Priority 2{list-option}
{list-option}Priority 3{list-option}
{list-data} |
| Task/Project Status: |{list-data:TaskSTAT|type=check|multiple=false|required=true}
{list-option}Active{list-option}
{list-option}Frozen{list-option}
{list-option}Completed{list-option}
{list-data} |
Sample task report code:
|| Percentage of completion | {list-data:PercentageCompl|type=check|multiple=false|required=true}
{list-option}0%{list-option}
{list-option}20%{list-option}
{list-option}40%{list-option}
{list-option}60%{list-option}
{list-option}80%{list-option}
{list-option}100%{list-option}
{list-data} |
I repeat - it's just an example. Now I would like to create a table, where all my employees are shown and then in a single row, but different columns, to see listed all tasks for Miss X, their priority, their status, and percentage of completion. How report like this one would look like?
Thank you for your help.
I’m excited
2
people have 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.
The company marked this question as answered.
-
1 person says
this answers the question
-
Inappropriate?Great. I like the easy ones :)
-
Inappropriate?David, I have another question, I hope you don't mind.
Now I am developing something like a Reporting system for Employee tasks and I have specific needs.
Here is the picture:
I have Task pages, I have Reports pages (a report page is children to its task page).
I have different scaffold templates both for tasks and reports. Now I would like to add reporting code to my reports template that creates a chart with summary of all weekly reports:
Here is a sample:
{report-table:displayTitles=true}
{local-reporter:page:children | source=My page}
{text-filter:data:PercentageCompl|include=20%,40%,60%,80%,100%}
{text-filter:data:DecNeeded|include=Yes}
{date-filter:data:Due Date}
{local-reporter}
Now, my source is hard coded. Is there a way to define the source page as variable? Or any way for injection?
I’m confused
-
Inappropriate?Hi Joe,
You can inject using {report-on:injected=true}. However, I'm not sure you want to do that here exactly. Is 'My Page' always relative to the current page? How is it determined? If it is either relative, or specified in a Scaffolding field, you can use that to navigate to it through the keychain. For example, if 'My Page' is always the parent page, you can do this:
{local-reporter:page:parent > page:children}
If you set it via a {collection-options} macro, you can do this:
{local-reporter:data:My Page > reference:value > page:children}
So, there are options. It depends what your structure is.
EMPLOYEE
