HierarchicalBand/GroupBand with collaping and bookmark

becomex_jle · Post by **becomex_jle** » Mon Nov 21, 2011 2:13 pm

Hello,

I tried to use the HierarchicalBand with collapsing and bookmark but i can't.

I have 3 problems:

1 - See Topic "Collapse problems" and post 21/11/2011 19:13:13.

2 - The button "+" e "-" always is visible. I wish it was visible when had children rows. Is it possible?

3 - The bookmark showed without hierarchical.

-----------------------------------------------------------------

I'm trying a another solution. With Master-detail.
I added three times the same table and configured collapsing and bookmark.

It's work perfect but when I add fourth table as master-detail, occured error in preview:

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Stimulsoft.Base.StiExceptionForm..ctor(Exception exception)
at Stimulsoft.Base.StiExceptionProvider.Show(Exception exception)
at Stimulsoft.Report.Design.Controls.StiDesignerPreviewControl.btRefresh_Click(Object sender, EventArgs e)
at Stimulsoft.Report.Design.StiDesignerControl.UpdateDesignerPreviewControl2(Object sender, EventArgs e)
at Stimulsoft.Report.Design.StiDesignerControl.TabControl_SelectedTabChanged(Object sender, TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabControl.InvokeSelectedTabChanged(TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabControl.tabStrip1_SelectedTabChanged(Object sender, TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.InternalOnMouseDown(MouseEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Post by **HighAley** » Tue Nov 22, 2011 8:01 am

becomex_jle wrote:I tried to use the HierarchicalBand with collapsing and bookmark but i can't.

I have 3 problems:

1 - See Topic "Collapse problems" and post 21/11/2011 19:13:13.

Sorry. But there several technical difficulties, we are still working on this problem.

becomex_jle wrote:2 - The button "+" e "-" always is visible. I wish it was visible when had children rows. Is it possible?

This signs can't be removed without impact on performance.

becomex_jle wrote:3 - The bookmark showed without hierarchical.

It's a feature of the Hierarchical Band. You should add next code in the Code tab

Code: Select all

string[] levels = new string[10];
int level = 0;
string levelName = string.Empty;

and use next script in the Get Bookmark event of the Hierarchical Band.

Code: Select all

level = Employees.GetLevel();
levels[level] = Employees.FirstName + Employees.LastName;
levelName = "%";
for (int index = 0; index < level + 1; index++)
{
     levelName += "\\" + levels[index];
}
e.Value = levelName;

becomex_jle wrote:I'm trying a another solution. With Master-detail.
I added three times the same table and configured collapsing and bookmark.

It's work perfect but when I add fourth table as master-detail, occured error in preview:

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Stimulsoft.Base.StiExceptionForm..ctor(Exception exception)
at Stimulsoft.Base.StiExceptionProvider.Show(Exception exception)
at Stimulsoft.Report.Design.Controls.StiDesignerPreviewControl.btRefresh_Click(Object sender, EventArgs e)
at Stimulsoft.Report.Design.StiDesignerControl.UpdateDesignerPreviewControl2(Object sender, EventArgs e)
at Stimulsoft.Report.Design.StiDesignerControl.TabControl_SelectedTabChanged(Object sender, TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabControl.InvokeSelectedTabChanged(TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabControl.tabStrip1_SelectedTabChanged(Object sender, TabStripTabChangedEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.InternalOnMouseDown(MouseEventArgs e)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at Stimulsoft.Controls.Win.DotNetBar.TabStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

We couldn't reproduce this issue. There is our report template in an attachment.

Thank you.

becomex_jle · Post by **becomex_jle** » Tue Nov 22, 2011 11:49 am

Aleksey wrote:Sorry. But there several technical difficulties, we are still working on this problem.

ok.

Aleksey wrote: This signs can't be removed without impact on performance.

ok.

Aleksey wrote: It's a feature of the Hierarchical Band. You should add next code in the Code tab
Code: Select all
string[] levels = new string[10];
int level = 0;
string levelName = string.Empty;
and use next script in the Get Bookmark event of the Hierarchical Band.
Code: Select all
level = Employees.GetLevel();
levels[level] = Employees.FirstName + Employees.LastName;
levelName = "%";
for (int index = 0; index < level + 1; index++)
{
     levelName += "\\" + levels[index];
}
e.Value = levelName;

It's work. Thanks.

Aleksey wrote: We couldn't reproduce this issue. There is our report template in an attachment.

I'm using the same table for the four datasource. See in attachment (mrt e sql).

Post by **HighAley** » Wed Nov 23, 2011 3:01 am

Hello.

becomex_jle wrote:I'm using the same table for the four datasource. See in attachment (mrt e sql).

Please, try to set the 'Print if Detail Empty' property to true for all Data Bands.

Thank you.

becomex_jle · Post by **becomex_jle** » Wed Nov 23, 2011 6:17 am

Aleksey wrote:Hello.
becomex_jle wrote:I'm using the same table for the four datasource. See in attachment (mrt e sql).
Please, try to set the 'Print if Detail Empty' property to true for all Data Bands.

Thank you.

It's work! Thank you.
But appeared two new problems:

1 - The "+" is appearing when the item don't have children. With three levels, it's work.

2 - When I click him (item 4), show the child of other item.

becomex_jle · Post by **becomex_jle** » Wed Nov 23, 2011 12:04 pm

Hello,

I have more doubt/issues...

1 - Using StiWebViewerSL with Bookmark and Collapsing: When I click bookmark's item, it is not select the report's row. If Collapsing = false, it's work.

2 - Using StiWebViewerSL with Collapsing and Drill-down: I added a Shape Object and configured as Drill-down. When I click in Shape, not open child report. Open then "Rendering Report..." and not finish. If Collapsing = false, it's work.

3 - Bookmark and Drill-down: When I change the reports, always the bookmark is close.

4 - I would like to set Collapsing/Drill-Down = true with expression. Is it possible?

Post by **HighAley** » Fri Nov 25, 2011 6:43 am

Hello.

Sorry, we need more time to prepare an answer for you.

Thank you.

becomex_jle · Post by **becomex_jle** » Mon Nov 28, 2011 6:53 am

Hello.

Ok.
I'm look forward to your answer.
Thanks.