Crystal reports need database drivers to
connect to connect a data source for accessing data and showing into a report.
VB.Net support two methods to access data from data source and publish it .
(i)
These
two methods are The Pull Model: When this model is used to access data from the
data source, the data driver directly from data source. This model does not require
a dataset means this model does not require the programmer to write any additional
code. The crystal report creates and manages the SQL commands for connecting to
the data source and retrieving data from it.
Crystal Report-------------Data---------------Data source
(ii)
The
Push Method: When this model is used to access the data from data source
through creating a dataset.
Crystal Report---------------Data-------------Dataset-----------Data------------Data source
But, In this post I will only write only
about, how to prepare a crystal report by pull method: or manually. When
crystal reported created manual, the data added manually to the created report
by using various tools from crystal report toolbox and the field explorer
window. To create crystal report by pull method or manually follow the
following steps
(a) Right click the project name in
solution explorer with and point Add from the shortcut menu. Then click add new
Item from Add shortcut menu option
(b) The add New Items dialog box will open then select Reporting from the list , you will see crystal report in after
selecting Reporting heading. Select crystal report and give name blog.rpt
(c) By default the Crystal report is
named as CrystalReport.rpt change the name to blog.rpt and click open report,
crystal report gallery is displayed
(d) Select As blank Report by checking the radio button
from Crystal report gallery, a new blank crystal report will be open
(e) You can connect a data source
directly and select the fields from database table to be displayed in the
crystal. To do so follow the following steps
(a) Right click of database field in the
field explorer windows and then select .
(b) A list of data sources is displayed
select a Create new connection and dig
down data base files and click of find
data base files when you click a pop up will open just select your data base
and click open after clicking open you will find all the tables of your
database is listed there.
(c) Just select a tables from the list
which you want to use in your crystal report , I have selected CoyEmployee
table in my example then click ok now the table is include database field just dig down your added table
and drag those fields which you want to show in your crystal report. The dragged
fields should be placed section-3 a heading will be created in section -2 also
which will be the subject tag of the report that can be also edited by right
clicking on them and editing text object.
(d) The report Designer displays a
various sections of the report such
(i)
Report
Header: The section contains the report title so you can use toolbox and text
object and create heading here.
(ii)
Page
header: This section contain title of the report, the component you add to this
section will be displayed on all the pages of report
(iii)
Details:
this section show actual reports
(iv)
Report
footer: . The component you add in this section will be show at the end of the
page.
Now you have created a report, you
can still do lots of things in this crystal report that all cannot be concluded
in one post so this Crystal report is ok for trial. Once you have created a
crystal report, then how you will show it.
(e) How you will display a crystal
report for that again go to solution explorer and right click on you project
then Add then Add window form and open a window form and name it report.vb and
click Add.
(f) Now new window form is open then go
to toolbox the drag Crystal report viewer which listed under sub head Reporting
and placed it on the window form
(g) Once you have place it on windows
form just select the Crystal Report viewer by clicking on it and go the property of the report viewer and set the
report source as crystal report which you have just created.
And Now your
crystal report viewer is set just press F5 and run the report
No comments:
Post a Comment