I
will explain how to create basic crystal reports using asp.net. Crystal
Report is standard reporting tool for visual studio by using these we
can display reports regarding employee details and display charts etc
and crystal reports need minimal coding to display result.
To implement crystal reports first design the table in database and give name UserInfomation
ColumnName
|
DataType
|
UserId
|
Int(set identity property=true)
|
UserName
|
varchar(50)
|
FirstName
|
Varchar(50)
|
LastName
|
varchar(50)
|
Location
|
varchar(50)
|
After completion of table creation enter some dummy data because we need to use that data to populate reports.
Now
Open visual studio and create new website after that right click on
your website and select Add new item in that select Crystal Report and
click Add
After that add crystal report then it will prompt Crystal Report Gallery window in that select blank solution and click OK
A blank report will create in our application now click on CrystalReports menu under that select Database under that select Database Expert
After click on Database Expert now Database Expert wizard will open in that select Create New Section >> select OLE DB (ADO) >> in that click on + sign of OLE DB (ADO)
Now select Microsoft OLE DB Provider for SQL
Server and click Next (Here we can select SQL Native client option also
but sometimes during deployment if servers not contains this native
client it will throw error).
Now enter SQL Server name, username, password and required database and click Next
After
enter credentials for your required database click Next then click
Finish (Here for my database I didn’t set any credentials for that
reason I didn’t enter userid and password details don’t get confused).
After
click Finish now our database loaded in OLEDB (ADO) section >>
select your database >> select dbo >> select required tables
Now open tables in that select required table and move to selected tables section and click OK
After
that Database Fields in Field Explorer populated with our required data
table now drag and drop the required fields from data table to reports
Details section
Now open your Default.aspx page drag and drop CrystalReportViewer control from Reporting tab.
Whenever
we click on New report source one window will open in that select
crystal report for Report Source from the available reports in
dropdownlist and click OK.
After assign available report to CrystalReportViewer control check your code that would be like this
<%@ Register Assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Crystal Report Sample</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="True" ReportSourceID="CrystalReportSource1" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
<Report FileName="CrystalReport.rpt">
</Report>
</CR:CrystalReportSource>
</div>
</form>
</body>
</html>
Now run your application your report will be like this
No comments:
Post a Comment