Download ActiveReports 7 User Guide

ActiveReports 7 User Guide
663
2.
In
the
Data
Link
Properties
window
that
appears,
select
Microsoft
Jet
4.0
OLE
DB
Provider
and
click
the
Next
button
to
move
to
the
Connection
tab.
3.
Click
the
ellipsis
(...)
button
to
browse
to
your
database,
for
example
the
NWind.mdb
sample
database.
Click
Open
once
you
have
selected
the
appropriate
database
path.
4.
Click
the
Test
Connection
button
to
see
if
you
have
successfully
connected
to
the
database.
5.
Click
OK
to
close
the
Data
Link
Properties
window
and
return
to
the
Report
Data
Source
dialog.
Notice
that
the
Connection
String
field
gets
filled
automatically.
6.
In
the
Query
field
on
the
OLE
DB
tab,
enter
the
following
SQL
query.
SQL
Query
SELECT * FROM categories INNER JOIN products ON categories.categoryid =
products.categoryid ORDER BY products.categoryid, products.productid
7.
Click
OK
to
save
the
data
source
and
return
to
the
report
design
surface.
To
create
a
layout
for
the
report
1.
Right-click
the
design
surface
of
the
report
and
select
Insert
then
Group
Header/Footer
to
add
group
header
and
footer
sections
to
your
report.
2.
Increase
the
group
header
section's
height
so
that
you
have
room
to
work.
3.
With
the
GroupHeader
section
selected,
go
to
the
Properties
Window
to
set
the
following
properties.
Property
Name
Property
Value
BackColor
LightBlue
CanShrink
True
DataField
CategoryName
GroupKeepTogether
All
KeepTogether
True
4.
From
the
toolbox,
drag
the
following
controls
to
the
GroupHeader
section
and
set
the
properties
of
each
control
as
indicated.
TextBox1
Property
Name
Property
Value
DataField
CategoryName
Location
0,
0
in
Size
6.5,
0.2
in
BackColor
CadetBlue
Font
Bold
True
Font
Size
12
TextBox2
Property
Name
Property
Value
DataField
Description
Location
0,
0.2
in
Size
6.5,
0.2
in
BackColor
CadetBlue
©2013 ComponentOne, a division of GrapeCity. All Rights Reserved.