Hierarchical Band Filtering

[pauljza]

Hi

I have a report that uses a hierarchical band to create the report structure and all works fine when I am not filtering the data source to exclude the root entities from the hierarchical data (ie. ParentID=null).

My structure is as follows:

Domains
ID
Name
ParentID

In my application i have given the user the ability to select the domain from a tree and this then alters the sql query to filter from the selected level downwards. When the filter is not applied to the sql query then all works fine but when the filter is included the report shows no data.

Based on the data that is available in the designer it appears that the report engine is not including the first root level since it does not have a null value in the ParentID column. If I manually set a value of the root parent in the Hierarchical Bands Parent Value property it works.

My question is this, how can I use a variable to set the Parent Value property of the hierarchical band or am I missing something in my setup that is causing the data to not display?

Regards
Paul

[Jan]

Hello Paul,

You can use following code in BeforePrintEvent of page:

Code: Select all

DataBand1.ParentValue = myVariable;

Thank you.