Introduction:
In this article I will explain how to create crystal reports example in asp.net.
In this article I will explain how to create crystal reports example in asp.net.
Description:
In Previous posts I explained how to install crystal reports in visual studio 2010 and how to create rdlc reports using asp.net and pass parameters to rdlc reports using asp.net. Now 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.
In Previous posts I explained how to install crystal reports in visual studio 2010 and how to create rdlc reports using asp.net and pass parameters to rdlc reports using asp.net. Now 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.
 |
Now select CrystalReportViewer and click on smart tag in right hand side and Choose new Report Source
 |
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
 |
In case your report prompt window for UserName and password before we access data in that situation we need to set those details in code behind instead of assign crystal report to CrystalReportViewer control
Drag and drop CrystalReportViewer control click on right side smart tag of your CrystalReportViewer control and uncheck EnableDatabaseLogonPrompt
 |
Our aspx code will 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 Open your code behind file and set database connection settings and assign reports to the control before that first add following namespaces
using System; using CrystalDecisions.CrystalReports.Engine; |
After add namespaces write the following code in page load event
C# code
protected void Page_Load(object sender, EventArgs e) { ReportDocument reportdocument = new ReportDocument(); reportdocument.Load(Server.MapPath("CrystalReport.rpt")); reportdocument.SetDatabaseLogon("username","password","SureshDasari","MySampleDB"); CrystalReportViewer1.ReportSource = reportdocument; } |
VB.NET Code
Imports CrystalDecisions.CrystalReports.Engine Partial Class Default2 Inherits System.Web.UI.Page Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load Dim reportdocument As New ReportDocument() reportdocument.Load(Server.MapPath("CrystalReport.rpt")) reportdocument.SetDatabaseLogon("", "", "SureshDasari", "MySampleDB") CrystalReportViewer1.ReportSource = reportdocument End Sub End Class |
Now run your application and check your output that would be like this
|
|
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email. |
|||
Subscribe by RSS
Subscribe by Email
|
|||
100 comments :
No Challenge to this site....This should be the template that every site must follow....
really its very useful
g8t example buddy its easy to understand thanks !
Helped a lot. Thanks
Its a very good example of crystal report....
Is there a way to create a crystal report that can be used in any remote computer system.
Whenever I try to use my crystal report created in my local pc to remote pc having the same database name and feilds I have to recreate the entire crystal report
I have one doubts
my server name is
DARSHAN-PC\SQLEXPRESS
when i write this as a string i am getting error..please help me how to solve this problem
thanks
very very very nice excellent
how to send sms to mobile..
hi suresh from which college you had complited your BE
Dipak
sample project is very help full
thanks
wewewewqe
Thanks SURESH Ji..!!
Nice steps to geneate crystal report
Hi,
This steps of creation is well also run in the browser during the execution in the editor having MS-Dev. kit IDE. But, after this page upload to IIS, the crystal report viewer could not load properly on client PC. Is there any possible setting in Web.Config .... Pls inform...
Thanks in advance...
JP.SIVARAJ
hai.. how can i add my crystal report to templates.. am using crystal report 10...can u help me....
thank you sir, it is good example
i have one query
enable databse login prompting
is it when i have SQL Security
not Windows Security
please reply my query
i mean
string server = @"\SQLEXPRESS";
reportdocument.SetDatabaseLogon("", "", server, "CrystalReport");
in this case i have window integrated security
so i don't have user name or password
thank you
if you have Windows Security then just remove
reportdocument.SetDatabaseLogon("", "", server, "CrystalReport");
hope it will work...
i want to ask Question
my crystal report working fine on local computer
when i uploaded it to server (not published version)
it is give me blank page
please replay me sir
this is my mail
devnet84@yahoo.com
thank you very much
It's very useful to me
Thank u very much
Hi Suresh,
I am new to Crystal Reports,
can u please tell me how the Find button works in the report. If i type "a" and click on that find. it is not doing anything and displaying "End of Search". I have even added the OnSearch click event of that. But no use. Please help me.
Hi suresh ,
this is one good example to create Report generations operation . thanks for your guidance.
Hi Suresh,
I am new to crystal reports, we have a crystal report in that find button fuctionality is not working. Can you please help me. it is crystal 10.0.
DLR
HI I USED THE SAME PROCESS BUT UN ABLE TO MOVE TO THE NEXT PAGE AS WELL AS UNABLE TO EXPORT THE REPORT
hi suresh,
thank you your code helped me in parameter passing in crystal reports.
iam having a problem in crystal reports when iam passing the parameter i am un able to move to the next page as well as export.
iam using vs2010
I used the same code but am getting missing logon parameter error and when i enable log on prompt i get an input box to log on in database..... help me! my e-mail is
urban_hippy@hotmail.com
Hi Suresh....
The above error only appears when i move to the second page,the first page displays fine....
thanx for this hint..
very easy to understand..
hi suresh can u explain me how to display the selected record in a grid view and print the selected record in a crystal report...
I got more help in this your blog....Very fine...easy to understand...I give 1 vote to great site for IT developer....
I think @Suresh ur the best.....ur site is really bombastic......keep itup bro....
I'm using a SAP Crystal Reports Web Viewer to display a CR report. It works perfectly fine in a CR Designer preview, however when I view it in a browser (any) the crosstab does not look as expected:
Can you tell me how to display images through crystal report in viewer. the images are stored in sql database
Hi Suresh this is good exampl but when i run the application to generate report using Crystelreport it is asking Sql Server Credientials ie Uid,Pwd everi time why ples help me
hi sir how to add cssStyle in crystal repot. please help me
Thanks a lot.
Very simple to understand (Step by Step)
Could u pls provide code for how to add button to crystal reportViewer toolbar?
thanks for step by step explanation
Hi,
Suppose we have ever growing database. Can we generate crystal report in real time by choosing some parameters like column names from the database?
thanks
Hi Suresh... Went through your article,found it really useful.Need your help at the start up though.
---------------
When I add a new item (crystal report)to the website,I get a file to my solution explorer with an extension ( .mht ) though it shows a (.rpt) before adding it in the dialogbox where i can rename it and no such gallery to select the template shows.Am I missing out a plugin or something??..
Awaiting your valuable reply :D
Hi Suresh,
Personally, This article very useful to me.I need a help,how to generate Payslip to more than one employee. Kindly give me some ideas like this article.
Thank u so much for your proper reply
thanks,
Revathy C
Hi sir,
This very good and i learn t from this and it is very useful to all like us. so keep it up
thanks.
UMESH KUMAR
Grt....Nice example...!
Good job...thanx..!!
thanx u so much...you give a very good example which is easy to use and understand.
hi suresh..
I have a problem when uploading to the server, .. like this
BC30002: Type 'ReportDocument' is not defined.
Dim reportdocument As New ReportDocument()
Can we use Query to fetch data from multiple table.
If yes , than how?
hi duresh garu i connected database is ado.net dataset but first page is displaying correctly when i ll click for next page it was asking logon failed incorrected parameteres.pls help me
advance thanks
thanks for it. but not display report in web page please help me.
I need to how to create a xsd file with website and how to create a crystal report with xsd files
Nice Ji Thank U.
great job ......thanks
thank u this is very useful example....
Excellent example. So easy to follow. Thank you for this!
quite helpful :)
now will you please solve my one problem ??
related to repeater ..
thanks for every think
this is very very useful
Im getting error as database logon failed for Crystal Report im using vs2010 version 4.0.
ye site developers ke liye bhagwan hai
Great Work... Its My dream Site
yes very good for learn but i want particular emp id with all details ..
how can write there code empid = 101
and given all information in report .
vijay
kya chutiyapa hai ye...
quite informative and good enough to work...
g8t example but after publishing it I am getting error :
WRN: Assembly binding logging is turned OFF.
how can i solve this issue pl help
Hello Suresh,
I have encounter a different issue during setting up crystal report for my windows application. I am using VS 2005 & Sql server 2005.Now i am not able to view any provider as u ave shown here
http://2.bp.blogspot.com/-Izb0Hxslebg/Txb8gZjST-I/AAAAAAAAA6E/jS82nd5X8G0/s1600/OledbProvider.png.
When i process like Database Expert > Create New Connection > OLEDB (ADO) a windows pops up but not provider s liseted there.Please let me what could be the issue, i have reinstalled OLEDB Provider(Downloaded form microsoft site) but of no use.I have Windows 7 32 bit is it something to do this OS.I have not even found MDAC for windows 7. Very much confused, please help me out on this, waiting for you revert.
Regards,
Manas
Hello Sir,
I have an asp.net application which is displaying the report using crystal report.The application is working properly on my local PC.I deployed this application on our dedicated server.But the following error occurring....
Retrieving the COM class factory for component with CLSID {5FF57840-5172-4482-9CA3-541C7878AE0F} failed due to the following error: 80070005...
could you pls give a reply..
Regards,
Janvi
hi,
How to increase bar height in crystal report.
really its nice buddy,
How can i displayed without probmpt of database details
its nice but on image hover not working a zooming properly then what to need to do
Excellent ! Very Useful
how to make crystal report using vs 2012 and mysql server
i am unable to make crystal report
please help for this crystal report
hi.. sir,
i am unable to make Crystal Report using visual studio 2012 and mysql
please help for this code..
thank u..
sir,
crystal report local proper run but when i online this crystal report there are not running
sir,
i have develop application in asp.net...with crystal report. It execute without any error in my pc where i developed it.
But, when i install dis application on another machine .crystal report shows error "System.MissingMethodException: Method not found: 'Void CrystalDecisions.Windows.Forms.CrystalReportViewer.set_ShowCopyButton(Boolean)'."
can u help me to solve this problem
great post helped a lot thankyou
Nice Suresh,You are doing wonderful job.
Thank a lot for this post.
Hi Friends,
Please help me to complete my task in project. I am new to make Crystal Report using VS 2005 C# with MySQL passing value through parameter. e.g. Bill_No and Acc_Year from multiple table(morethan 10 tables). Key values are Bill_No and Acc_Year. Thnaks and Advance wishes for your happy helping in this .... you can mail me the solution as soon as possible. e-mail:- nallas.murugan@gmail.com
Sir, I followed all the steps in VS2010 and CR13 . Report is working fine on sever but on client Report is not visible any guidance
Hi Suresh, I have been a fan of your site since a year. you are providing a host of umpteen examples which i found useful to rev up my coding skills. thanks again.
Hi Suresh how get crystal reports using store procedures with parameter, here i have to join three table and filter them according to Departments and Designation
thanks,
Shashi kiran
Hii.. Can you tell me how to render text we have typed using ajax control toolkit editor(HTML text) just us how we have formatted in html editor on to crystal report?
hi i want to disable all the tools and controls which is available in my report
because i don't want my (any) user to access (or) select any tools in my report except print....
i have a quizportal http://quizking.co.in/programming/Rdbms.aspx , but when i selects the option it takes time to fetch the status, i want minimize the time .how?plz view the site and answer me.
can we bind crystal report dyanmically...????
reason is i olready made a website and do not want to alter oll code... is there any way to Bind crystal report , plz let me know... thank you sir
only blank page is appearing. The crystal report is not loading. Any reason ? I followed the same steps as you did
oops...I was using .NET 4.5 and it wasnt working.. Now I tried with .NET 2.0 and its working fine :) Thanks for your awesome tutorial ! :)
i have query ... i want report like
1 sunil AAAAAAAAAAAA
BBBBBBBBBBBB
2 Suresh FFFFFFFFFFFFF
3 VISHAL LLLLLLLLLLLLLLL
KKKKKKKKKKK
UUUUUUUUUUU
Hello Suresh, I have a query that I followed above steps & created a crystal report but when I'm trying to run in browser screen shows nothing & report not showed on browser window. Why this occurs. Pleas help me with this. Thanks.
80007005 error what is this?
Hi friends,
Sub: Page is blank at run time
I am using complete this code but when i run my page, then page is blank. Please reply me with solution on ---- vbvipinbhayana88@gmail.com
Hi friends,
i want to create crystal report in vs 2013 ultimate.How to i create this report. kindly help me for this.
I have a custom web application developed in VS2005 and integrated Crystal Reports XI. This application has been in production for 10 years. I just upgraded this application using VS2012 and Crystal Reports 13. When I try to view the report it shows correctly. Clicking on drill-down also shows the Drill Down report in another tab of the Report Viewer control. But clicking on next page while in the Drill-drown report, removes the drilldown report tab and take to the next page of the Main Report.
Any ideas/.
Thanks
Ridu
thankss suresh
Very Easy To UnderStand ..and Very Usefull Thank u So much.............
Reallu nice piece. I want to know how to fetch data from mysql
I use Crystal Report v13, SQL server 2012.
When I try to connect to a Database via ADO, I got the following error.
Login failed.
Details :ADO Error Code:0x80040e4d
Source:Microsoft OLE DB Provider for SQL Server
Description:Invalid authentication Specification
SQL State: 28000
Is there anyone how has this problem?
How can I fix this?
Thanks in advance,
i am getting blank crystal report on IIS but on local working fine
how to connect multiple crystal report rpt to one crystal report viewer.
Very Very useful and easily understandable solution. I am very grateful to you.
Following code will work for dynamic DB credential
//If rptTest is a Crystal Report file (rpt).
rptTest rpt = new rptTest();
rpt.DataSourceConnections[0].SetConnection("ServerName", "DBName", "DBUserId", "DBPassword");
rpt.SetParameterValue("@Parameter_Name", null);//Optional
crv.ReportSource = rpt;
nice
Note: Only a member of this blog may post a comment.