Databases Reference
In-Depth Information
As you can see, the chart is a little clogged with bars in the limited space we have
available. We need to limit the number of bars shown so that only the first
N
Carriers
are visible.
N
is the number that our
vTop
variable holds.
Go to the
Chart Properties
window and activate the
Dimension Limits
tab. Enable
the
Restrict which values are displayed using the first expression
checkbox. The
configuration for the limit we will set is:
• The
Show only
radio button must be selected
• From the drop-down list, the
Largest
value will be selected
• On the
Values
field, we will enter our variable using the following syntax:
$(vTop)
• The
Show Others
checkbox should be disabled
The previous configuration is shown in the following screenshot:
The syntax we used to enter the variable is called
Dollar Sign Expansion
. In this
particular case, the variable could have been entered without the dollar sign, but
there are some circumstances in which it is a must, so it's a good practice to always
include it. We will talk about this syntax later in the chapter.