Hierarchical Band repeat rows on each page

[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

[Edward]

Unfortunately this is impossible in the current version of Stimulsoft Reports.Net.

Thank you.

[patwolf]

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

[Edward]

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.

[patwolf]

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

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