Hierarchical Report Question

[cbrydon]

Hi All,

I'm trying to create a simple Hierarchical Report and cannot get my data to display in the report.
I've attached a sample database, as well as the report I'm using (both in a zip file) with the hope
that someone will be able to point me in the right direction.

I am using Stimulsoft Reports.Web 2014.1.1900, Designer.Fx, and Flash Player 16.0.

I have chosen only two fields to display in the report, InstanceName and Parent. InstanceNames
might be Floor 1, Room 1, Chair 1, with Room 1 being the parent of Chair 1, and Floor 1 being the
parent of Room 1. Essentially what I was hoping to see is something like the following...

Floor 1
--Room 1
----Chair 1
----Chair 2
----Table 1
--Room 2
---- Chair 1
---- Chair 2
---- Table 1
Floor 2
--Room 1
----Chair 1
----Chair 2
----Table 1
--Room 2
---- Chair 1
---- Chair 2
---- Table 1

Any help or direction would be appreciated!

Thanks,
Carl

[Alex K.]

Hello,

Please check the ParentID value for the root records. You have records with value ParentId=4423 but there is not InstanceID with this value. Please try to change the value of ParentId column from 4423 to NULL.

Thank you.

[cbrydon]

Thank You Aleksey - that did the trick. I appreciate the help!

Cheers,
Carl

[Alex K.]

Hello,

Let us know if you need any additional help.

Thank you.