Download ActiveReports 7 User Guide

ActiveReports 7 User Guide
329
You
can
use
a
whisker
Sparkline
to
render
“win/loss/tie”
scenarios
(for
example,
sport
statistics)
or
“true/false”
scenarios
(for
example,
was
the
sales
goal
met
or
was
the
temperature
above
average),
based
on
the
numeric
data
from
a
data
set.
The
bars
in
a
whisker
sparkline
render
below
the
baseline
for
a
negative
value,
above
the
baseline
for
a
positive
value
and
on
the
baseline
for
a
zero
value,
for
example,
in
a
"profit/loss/no
profit,
no
loss"
scenario.
The
following
steps
demonstrate
how
to
create
a
whisker
sparkline.
These
steps
assume
that
you
have
already
added
a
Page
Report
template
to
your
project,
connected
it
to
a
data
source
and
added
a
dataset.
See
Adding
an
ActiveReport
to
a
Project,
Connect
to
a
Data
Source
and
Add
a
Dataset
for
more
information.
Note:
These
steps
use
the
AccountsChartData
table
from
the
Reels
database.
The
sample
Reels.mdb
database
file
is
located
in
the
[User
Documents
folder]\ComponentOne
Samples\ActiveReports
Developer
7\Data
folder.
1.
From
the
Visual
Studio
toolbox,
drag
a
Sparkline
control
onto
the
design
surface.
2.
With
the
sparkline
selected
on
the
design
surface,
go
to
the
properties
window
and:
Set
the
Sparkline
Type
property
to
Whiskers.
Set
the
SeriesValue
property
to
a
numeric
field
(like
=Fields!RollUp.Value)
from
the
connected
data
set.
Set
the
FillStyle/FillColor
property
to
Red.
3.
Go
to
the
Preview
tab
to
view
the
whisker
sparkline.
Add Parameters in a Page Report
You
can
add
parameters
to
a
page
report
to
allow
users
to
select
the
data
to
display,
or
to
use
in
creating
drill-through
reports.
To
add
a
parameter
1.
In
the
Report
Explorer,
right-click
the
Parameters
node
and
select
Add
Parameter.
The
Report
Parameters
dialog
appears.
2.
On
the
General
tab
of
the
dialog,
set
the
name,
data
type
and
prompt
text
for
the
parameter.
For
example:
Name:
MPAA
Data
type:
String
Text
for
prompting
users
for
a
value:
Enter
value
Select
out
of
the
checkbox
options
to
allow
null
values,
multivalues,
blank
value,
multiline
values
or
set
hidden
parameters.
3.
On
the
Available
Values
tab,
you
can
select
From
query
populate
a
list
from
the
data
set
from
which
users
can
select
a
value.
Alternatively,
you
can
select
Non-queried
to
enter
your
own
values.
4.
On
the
Default
Values
tab,
you
can
provide
default
values
to
use
if
the
user
does
not
select
a
value.
This
is
useful
when
you
are
creating
a
hidden
parameter.
5.
Click
OK
to
save
the
parameter.
The
new
parameter
appears
in
the
Report
Explorer
under
the
Parameters
node.
6.
From
the
Report
Explorer,
drag
the
parameter
to
report
design
surface
to
create
a
TextBox
that
is
bound
to
the
parameter.
When
you
run
the
report,
the
value
that
the
user
supplies
in
the
prompt
dialog
displays
in
the
bound
TextBox
on
the
report.
©2013 ComponentOne, a division of GrapeCity. All Rights Reserved.