Creating reports and dashboards | Stimulsoft community forum

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.

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

becomex_jle wrote:3 - The bookmark showed without hierarchical.

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

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)

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

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

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;

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

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

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.