Creating reports and dashboards | Stimulsoft community forum

Posted: **Fri Sep 26, 2008 3:00 am**

We are working on a complex hierarchical report made up of several pages and dependancies among pages.
The report is made up of several sections each starting in a new page.
What we did was drawing our report into just one page, as we assigned a Master/detail relation to each databand in our report and you can't assign such a relation between databands in different pages (as far as we know).

We also tried to use the sub-report technique but results (so far) don't seem so good. We are encountering the same problem we have with the one page report, that is we don't always get the new section first page on a new page.

We would like to ask if you think this is the best way to proceed or we should better use some other technique.

One more question is if it's possible to alternate portrait and landscape property to the same page, for example inserting a page break and then changing the page appearence.

We'll welcome any suggestion.

Posted: **Mon Sep 29, 2008 2:02 am**

Michelangelo wrote:We are working on a complex hierarchical report made up of several pages and dependancies among pages.
The report is made up of several sections each starting in a new page.
What we did was drawing our report into just one page, as we assigned a Master/detail relation to each databand in our report and you can't assign such a relation between databands in different pages (as far as we know).

We also tried to use the sub-report technique but results (so far) don't seem so good. We are encountering the same problem we have with the one page report, that is we don't always get the new section first page on a new page.

We would like to ask if you think this is the best way to proceed or we should better use some other technique.

Current prerelease version 2008_2 contains new version Engine: EngineV2. Version of the report engine could be selected in the properties of 'Report' object in the designer. EngineV2 has been developed for overcoming some limitations which I think you have faced in that complex report. Please send the report template to support[at]stimulsoft.com and we will suggest you the best possible way for resolving the task.

One more question is if it's possible to alternate portrait and landscape property to the same page, for example inserting a page break and then changing the page appearence.

Yes, this is possible, but only after rendering the report. Here is the code for report.EndRenderEvent event handler which changes size of the pages when the report has been rendered:

Code: Select all

foreach (StiPage page in this.RenderedPages)
{
if ((myCounter&1)==0) 
{
	page.Height = 10;
	page.Width = 20;
}
else
{
	page.Height = 20;
	page.Width = 10;
}
myCounter++;
}

myCounter - is an int type variable, declared in the Dictionary.

In EngineV2 version you can call break of the page from script:

this.Engine.NewPage();

also there are a lot of new properties for starting of the new page in the EngineV2.

Working of the Hierarchical band also has been improved. We have added new properties to Hierarchical Band:
'Headers' and 'Footers' properties have been added to the HierarchicalBand.
Sub-totals can be calculated for HierarchicaBand. For example: Totals.SumAllLevels(HierarchicalBand1, expression)
You can calculate totals with help of HierarchicalBand. For example: Totals.Count(band)
HierarchicalBand can output tree as its header and footer on all pages.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Hierarchical Report

Hierarchical Report

Hierarchical Report