User`s guide

You now have a query with a simple hierarchy on Material class and a hierarchy node variable based
on the Material class hierarchy.
How to build a report off the query with a hierarchy node variable
This section guides you through the process of creating a list of default values for the parameter that
appears in "Crystal Reports".
1.
Create the same report that you created in How to build a report off the BW hierarchy except you
are now using the query called Simple Hierarchy w Node Variable as the data source.
2.
Click the Refresh button when you have finished designing the report.
Note:
If your variable is optional, ensure that the Set to Null check box is clear when you select a parameter
value. The Set to Null check box overrides any value you select from the list of default parameter
values. This check box is not always cleared when you select a parameter value.
Building a report off a BW query with a hierarchy variable and a hierarchy node variable
This tutorial guides you through adding a hierarchy variable to the query you created in the last tutorial.
The hierarchy variable allows users to choose what hierarchy they would like Crystal Reports to use
when displaying the data. The hierarchy node variable allows users to then choose what node of the
hierarchy they would like to see data from.
You will perform the following tasks in this tutorial:
• Add a hierarchy variable to your existing query
• Create a new report based on this query
• Bind the hierarchy node variable to the MemberUniqueName field.
• Bind the hierarchy variable to the Hierarchies field.
• Preview the report
Note:
This tutorial builds on the query that you built in the previous tutorial. If you have not built a query yet,
follow the steps outlined in How to create a simple BW query, How to create a simple BW query with
a hierarchy, and How to create a query with a hierarchy node variable.
How to create a hierarchy variable
This section guides you through the process of creating a hierarchy variable on your existing query and
resetting the hierarchy node variable to correspond to this new hierarchy variable.
In the last tutorial, you set the hierarchy node variable to the Material class hierarchy because that is
the hierarchy that existed in the query. In this tutorial you will change the hierarchy of the query from
the Material class hierarchy to a variable. To avoid unexpected behavior, the hierarchy node variable
2012-03-14584
Integrating Business Applications with Crystal Reports