Page 1 of 1

Hierarchical Band repeat rows on each page

Posted: Thu May 29, 2008 2:09 pm
by patwolf
Hi,

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
And would like to report on it like this:

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
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

Hierarchical Band repeat rows on each page

Posted: Fri May 30, 2008 12:41 pm
by Edward
Unfortunately this is impossible in the current version of Stimulsoft Reports.Net.

Thank you.

Hierarchical Band repeat rows on each page

Posted: Fri May 30, 2008 1:11 pm
by patwolf
Edward wrote:Unfortunately this is impossible in the current version of Stimulsoft Reports.Net.
Thank you.
Thanks Edward.

Could you please be more detailed what exactly is impossible as quite a few of the above functions do work.

Thank you,
Patrick

Hierarchical Band repeat rows on each page

Posted: Tue Jun 03, 2008 12:47 am
by Edward
patwolf wrote: 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.
In the current realization of Hierarchical band you can achieve this result only with writing a lot of script and using at least 3 Hierarchical bands and also additional copy of DataSource in the Dictionary instead of one is required.
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.
This feature requires modifications in work of Hierarchical Band and we need time (approximately 3 weeks) for implementation of this. Such a long term is explained with a process of completing of the integration process of the new engine together with the current one.
Can I do this with Reports.NET? And if yes how please?
Unfortunately the solution is too complex, contains a lot of script and depends on the amount of levels which are necessary to show in the header of the page. Also now is very difficult to give a universal solution when amount of levels to show is not fixed and not all levels are present.

Thank you.

Hierarchical Band repeat rows on each page

Posted: Tue Jun 03, 2008 1:49 am
by patwolf
Edward wrote:Unfortunately the solution is too complex, contains a lot of script and depends on the amount of levels which are necessary to show in the header of the page. Also now is very difficult to give a universal solution when amount of levels to show is not fixed and not all levels are present.
In my case displaying 2-3 levels at the top of a page would be enough to let the user know where they are :dumb:

The data source could easily contain a field saying this is a row to repeat this one isn't, or displaying something on the next page would depend on it being in a GetLevel() < 3 or something along these lines.

Thanks a lot,
Patrick

Hierarchical Band repeat rows on each page

Posted: Tue Jun 03, 2008 12:55 pm
by Edward
Ok, in that case solution in the attachment from the following topic

http://forum.stimulsoft.com/Default.aspx?g=posts&t=1368

could be useful. Please send your comments on it.
What else must be changed in that solution to satisfy of all requirements of your task.

Thank you.