Hierarchical Band repeat rows on each page
Posted: Thu May 29, 2008 2:09 pm
Hi,
I have the following structure:
And would like to report on it like this:
This seems to work fine with the hierarchical band.
The special case here is:
Each type project, task, taskDetail etc. needs a different layout in the row in which it is displayed as it has different columns (see sample data). E.g. a project has to display projectIsActive while a task display the taskResource.
Also I would like certain types to be repeated at the top of each page. E.g. project and task rows should be repeated on the top of each page while taskDetail rows shouldn't (the rows to repeat could be done on a GetLevel() < 2 to keep it dynamic).
This is only a sample data structure by the way ours is about 10 levels deep and we don't always start the report on the project level but sometimes on the task level etc. so it needs to be a dynamic solution.
Also many reporting tools have an option of "keep together with next row". Basically I wouldn't like the last row of a page to be a new project row but rather have the project displayed on the next page with it's data.
Can I do this with Reports.NET? And if yes how please?
Thanks,
Patrick
I have the following structure:
Code: Select all
id root type name projectIsActive taskResource taskDetailCost
1 null project A TRUE null null
2 1 task A1 null Peter null
3 2 taskDetail A1-1 null null 25
4 2 taskDetail A1-2 null null 21
5 null project B TRUE null null
6 5 task B1 null Bob null
7 6 taskDetail B1-1 null null 2
Code: Select all
A
.A1
..A1-1
..A1-2
----- maybe new page ----------
A
.A1
..A1-3
B
----- maybe new page (B should be on the next page with "keep togehter with next row" option) ----------
.B1
..B1-1
The special case here is:
Each type project, task, taskDetail etc. needs a different layout in the row in which it is displayed as it has different columns (see sample data). E.g. a project has to display projectIsActive while a task display the taskResource.
Also I would like certain types to be repeated at the top of each page. E.g. project and task rows should be repeated on the top of each page while taskDetail rows shouldn't (the rows to repeat could be done on a GetLevel() < 2 to keep it dynamic).
This is only a sample data structure by the way ours is about 10 levels deep and we don't always start the report on the project level but sometimes on the task level etc. so it needs to be a dynamic solution.
Also many reporting tools have an option of "keep together with next row". Basically I wouldn't like the last row of a page to be a new project row but rather have the project displayed on the next page with it's data.
Can I do this with Reports.NET? And if yes how please?
Thanks,
Patrick