User`s guide
Now that the display hierarchy is set to a variable rather than the Material class hierarchy, you must
reset the hierarchy node variable to the new hierarchy variable.
To set the hierarchy node variable
1.
In the Rows area, click the Test Hierarchy Node Variable, and click Restrict.
The "Selection for Material" dialog box appears.
2.
In the Selection area, right-click the Test Hierarchy Node Variable.
3.
Click Select Variable Hierarchy.
4.
Select the Variables check box to expose the variable hierarchies in the Name list.
5.
From the Name list, click the hierarchy variable you created earlier in this tutorial.
In this example, the hierarchy name is HV01 (Test Hierarchy Variable).
6.
Click Save Query As... and name the query Simple Hierarchy Variable w HN Variable.
7.
Click Quit and Use Query.
You now have a simple query that will prompt the user to choose a particular hierarchy to use when
displaying results and to restrict that result set to a particular hierarchy node.
How to build a report off the query with a hierarchy variable and hierarchy node variable
This section guides you through the process of creating a basic report off your new query and creating
a list of default values for the hierarchy variable in Crystal Reports.
To build a report off the query with a hierarchy variable and hierarchy node variable
1.
Create the same report that you created in Building a report off a BW query except you are now
using the query called Simple Hierarchy Variable w HN Variable as the data source.
2.
Click the Refresh button.
You are presented with two parameter prompts. One prompts you to enter a value for the hierarchy
node variable and one prompts you to enter a value for the hierarchy variable.
3.
Select a value for the Hierarchy parameter.
Note:
Be sure to select this value first because the Hierarchy Node values are set based on the selection
you make here.
4.
Select a value for the Hierarchy Node parameter.
Crystal Reports and variable pick lists
Crystal Reports does not create default pick lists for any BW variables that are in your query.
2012-03-14586
Integrating Business Applications with Crystal Reports