How
to Create Crystal Report in asp.net
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 2008 and
create new website and open Default.aspx page in Designmode after that open Toolbox from that drag and drop MicrosoftReportViewer control from Reportingtab
 |
After drag and drop MicrosoftReportViewer in your page select
ReportViewer control and click on smart tag in right side and select Design a new Report
 |
After click on Design a new report now welcome window wizard will open
 |
Now click on Next button after that new Data
Source Configuration Wizard will open in that click on New Connection button to
configure database connection.
 |
Now one window will open to add new connection in that enter
Server Name and select authentication type either windows or SQL Server and
select database name after fill all the details click on Test Connection if the
connection path is correct then that will display Test connection succeeded.
After that click ok
 |
After click ok New database connection added to dropdown now click
on Next button
 |
After click Next it will display available Tables, views, Stored
Procedures and Functions in DataSource Configuration Wizard in that open Tables
section and select required table previously we created table with name UserInformation now I am selecting that table from available list
 |
After click finish our report wizard populate with our selected
table now select that table and our Next button
 |
After click Next button it will display options to select Report
type either Tabular or Matrix now select Report Type and click Next Button
 |
After click Next Report Wizard display Design the table option
with available fields from previous selected table and give options like Page,
Group and Details these are used to display the data based on Groupwise etc.
Here we are doing simple crystal report sample I am not doing anything simply
click on Next Button
 |
After click Next button Report wizard will display option to
select Table layout after select required table layout click on Next button
 |
After click Next button Report wizard will display option to
select Table style after select required table style click on Next button
 |
After click Next button Report wizard will display Completing the
Report Wizard in that enter Report Name and click Finish button
 |
After click Finish button now it will create new report if we open
our website Solution Explorer we have chance to see newly created report
Report1.rdlc and xsd file in App folder this xsd file contain our selected
database table.
 |
After that Now Open Default.aspx page and select ReportViewer and
click smart tag in right side in that select Report Type
 |
Once Report1.rdlc selected Open Default.aspx Source code it
contains code like this
|
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" Height="342px" Width="398px">
<LocalReport ReportPath="Report1.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"Name="MySampleDBDataSet_UserInformation" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"
TypeName="MySampleDBDataSetTableAdapters.UserInformationTableAdapter">
</asp:ObjectDataSource>
</div>
</form>
</body>
</html>
|
If you above code Here we added referece of assembly for
Reportviewer that is necessary to run our report perfectly. Now Run your
application check the output that would be like this.
Demo
 |
Thanks for providing these great resources.
ReplyDeleteRFID Access Control System
thanks for sharing this information
ReplyDeletedata science training in siruseri
best data science training in omr
best data science training in sholinganallur
best devops training in chennai
best devops training institute in sholinganallur
best devops training institute in omr
best hadoop training in chennai
best hadoop training in omr
hadoop training in sholinganallur
Nice blog, keep writing like this
ReplyDeleteMattress Protector for Baby
Nice blog, keep writing like this
ReplyDeleteI must recommend your blog, that is such a nice blog and if you want to buy Fridge Cover then click on the link.
Nice blog, keep writing like this
ReplyDeleteFind here online price details of companies selling Mattress Cover Cotton. Get info of suppliers, manufacturers, exporters, traders of Mattress Cover Near Me for buying in India.
Nice blog, keep writing like this
ReplyDeleteBuy Washing Machine Cover at low prices in India. Select from range of home improvement tools & Washing Machine Cover of all brands from Dreamcareindia.com
Washing Machine Cover
Washing Machine Cover Price
Washing Machine Cover Online
Washing Machine Cover Manufacturers
Washing Machine Cover Waterproof
Washing Machine Cover Near Me
Cover for Washing Machine
Washing Machine Cover IFB
Washing Machine Cover LG
Washing Machine Cover Whirlpool
Nice blog, keep writing like this
ReplyDeleteBuy Milwaukee at low prices in UK. Select from range of home improvement tools & Milwaukee UK of all brands from tools4trade.co.uk
Milwaukee
Milwaukee UK
Milwaukee Power Tools
Milwaukee Fuel
Milwaukee UK Cordless
Corded Power Tools
Milwaukee power tools UK
ReplyDeleteNice Your Blog
Visit My Blogs:-
Fridge Cover
Fridge Protector
Ffreeze Cover
Fridge Mats
Table Cover
Table Cover Online
Table Cover Design
Table Cover Plastic
Table Cover Price
Table Cover Price
Center Table Cover
Centre Table Cover
Dining Table Cover
Table Mats
Table Placemat