Creating a Report
in
Visual Studio 2008
In this section, you
create a report that
draws its information
from the sample
Microsoft Access
database that ships
with Crystal Reports.
To create a report
with secure data
from the Your
database follow
these steps .
1. In Solution
Explorer, right-
click the project
name that is in
bold type, point
to Add, and then
click Add New
Item.
2. In the Add New
Item dialog box,
in the
Templates view,
select the
Crystal Report
template.
3. In the Name
field, enter the
name
"MyReport.rpt" and
click Add.
- In the Create
New Crystal
Report
Document panel
of the Crystal
Reports Gallery
dialog box, select
Using a Report
Wizard . - In the Choose an
Expert panel,
select Standard,
and then click OK. - In the Available
Data Sources
panel of the
Standard Report
Creation Wizard
window, expand
the Create New
Connection
folder. - From the
subfolder that
opens, expand
the ODBC (RDO)
folder. - In the ODBC (RDO)
window, select
the correct ODBC
DSN entry for
your version of
Crystal Reports
as explained in
ODBC DSN Entry
for Xtreme
Sample Database
, and then click
Finish.
The ODBC (RDO)
folder expands
and shows the
Xtreme Sample
Database. - Expand the
Tables node, and
then double-click
the <your table >to move the
table to the
Selected Tables
panel, and then
click Next. - Expand the
<your table>,
and then CTRL-
click <list of colum>. - Click the > symbol
to move these
fields into the
Fields to
Display panel,
and then click
Next. - In the Available
Fields panel,
under Report
Fields, double-
click
<any one column> to
move the field
into the Group
By panel, and
then click Finish.
The
MyReport report is
created and
loaded into the
main window of
Visual Studio.