Crystal Report in Visual Studio 2010

Ayyub Mohammad

27 Comments

Join the conversation! Your thoughts help the community grow.

Rajkumar KR4y ago
The type or namespace name 'CrystalDecisions' could not be found (are you missing a using directive or an assembly reference?) It shows the error during the build
Muzaffar Munir8y ago
I have an issue using Crystal reports when i open its designer in Visual studio 2013 its designer not loaded properly and shows hexadecimal code while its works fine on run time kindly someone helps me to resolve this issue?\
veera muthu11y ago
Thankyou...It s very useful....
Nikunj Trivedi11y ago
Thank u sir, Its a very useful blog for crystal report. But here i face one problem after viewing data in crystal report viewer. When I press PRINT button then Printer List not available. No one printer display to select to print. Please Help me to solve this.
majedul islam11y ago
thanks brother
kiran raj11y ago
i cant create its not working
kiran raj11y ago
where did u make the connection to database ?
kiran raj11y ago
i am not able to get the database datas
Nirav Daraniya12y ago
To add crystal report in visual studio 2012 download setup from link is herehttp://niravdaraniya.blogspot.in/2014/04/download-crystal-report-setup-for.html
maryar cho13y ago
When I try to generate the report I get the error -the crystal report dll is not in the path. Here's the error: Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified. This error occer in Windows Application. Not at web.
Darshan Kshirasagar13y ago
Data is not fetching from the database only blank showing .
Arup Dolui13y ago
Hello sir, Crystal Report Viewer control is not showing in the tool box...plz help me out....thank you
Ayyub Mohammad13y ago
Thanks U All.......
Monika Chauhan13y ago
Thanku a Lot Sir i was facing lots of problem b'coz i m new with crystal report. But after reading this article my all doubt is clear. sir may i know sumthing more on crystal report? Sir this article pick the database value. please tell me if we want to show textbox values which are entered by the user and then show these all value into the crystal report. Please solve my query
suresh bavireddy13y ago
Really great job.. for the last few days I'm googling for the crystal reports tutorial and while developing i'm facing problems but now i think i Found solution to my problem Thank You.....
ziafat ali13y ago
Thanks a lot. I am facing a problem that is shows only Header not the underlying data. Please help me in this regard.
mayur patil13y ago
@kapil try to get crystal report frm reporting templates...
Kapil Motiyani14y ago
i hv installed sap crystal reports for vs2010 bt crystal report template is not shown in installed templates when i click on add new item.... so can u plz give soln for dat?
Ayyub Mohammad14y ago
Thanks U all................
Vaibhav Kanase14y ago
Nice
Nader Abbasi14y agoedited
hi, it's very gooooood and very easy to understand. thanks.
Ritha B14y ago
Nice..Easy To Understand....
Vipendra Verma14y ago
Thank you for providing me good knowledge about Working with a Local Database in Windows Phone 7. I want to know how to connect it with other data base.
Vipendra Verma14y ago
Thank you for providing me good knowledge about Working with a Local Database in Windows Phone 7. I want to know how to connect it with other data base.
Dinesh Beniwal14y ago
Good Start, Welcome to the C# Corner.
Arjun Panwar14y ago
Hi,is there any limitation such as number of report can be built per site in visual studio 2010?
Gaurav Gupta14y ago
Hello.. I want to know that How Many SubReports Added in One Main Report

Crystal Reports has been excluded In VS2010. Yes, what you just heard is right. That means, if you install VS 2010 then you will not get Crystal Reports built-in.

But don't worry it is available as a separate download from the SAP web site.

To download Crystal Reports, click on the following link:

http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0.exe

Introduction

This is my first article. In this article, I will show you a simple Crystal Report creation process with screenshots using Visual Studio 2010. Because a picture is worth more than a thousand words, so I always believed in an article with screenshots is much better.

Let's start by creating a new website in VS 2010.

Open VS 2010, select Visual C# and ASP.NET Web Site, and click OK as shown below.

This action will create a new Web site project.

Once we have a Web site project created, the next step is to get database access in the project. That we do use a DataSet from a database.

Creation of Dataset (xsd) File

The following figure shows you the process to create a DataSet file.
To add a DataSet file, click on Solution Explorer -> Right Click on Project -> click on Add new Item and then it will show you the following screen:
Enter the Dataset file name. Click on the ok button.
It will ask for confirmation to put that file in the App_Code folder. Just click yes and that file will be opened in the screen as a blank screen.
Now we will add one blank data table to that mydataset.xsd.
Right-click in the area of the file and select Add -> Datatable.
It will add one DataTable1 to the screen.
The following Figure 5 shows how to add a data table to the mydataset.XSD file.
Now, datatable1 is added to XSD file.
Now we will add a data column to the datatable1 as per figure 6.
Remember, whatever columns we add here will be shown in the report.
So add the columns you want to display in your reports one by one here.
Always remember to give the same name for the column and data type of column which is the same as the database, otherwise, you will get an error for field and data type mismatch.
To set the property for the columns the same as the database.
The following figure will show you how to set the property for the data columns.
The default data type for all the columns is a string.
To change the data type manually right-click on the datacolumn in the datatable and select property.
From the property window, select the appropriate datatype from the DataType Dropdown for the selected datacolumn.
XSD file creation has been done.
Now we will move on to create the Crystal Reports design.

Creation of Crystal report design

Click on the Solution Explorer -> Right-click on the project name and select Crystal Reports.
Name it as you choose and click the add button.
After clicking on the add button a .rpt file will be added to the solution.
It will ask for the report creation type of how you want to create the report.
Click the ok button to proceed.
Under Data Sources, expand ADO.NET Datasets and select Table and add to the selected table portion located at the right side of the window using the > button. Click on Next.
Select the columns that you want to show in the report.
Now click on the Finish button and it will show the next screen.
Once the report file is added, you can see the Field Explorer on the left side of the screen.
Expand Database Fields, under that you will be able to find the Datatable that we have created earlier.
Just expand it and drag one by one each field from the Field Explorer to the rpt file in the under detail section.
Now the report design part is over.
Now we have to fetch the data from the database and bind it to the dataset and then Show that dataset to the report viewer.

Crystal Report Viewer

First Drag a CrystalReportViewer control on the aspx page from the Reporting Section of the toolbox.
Add a command Button.
Configure the CrystalReportViewer and create a link with Crystal Reports.
Select the Crystal Reports source from the right side of the control.

The following is the final code for reports (Default.aspx).

Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.Visible = false;
}
protected void cmdcrystal_Click(object sender, EventArgs e)
{
CrystalReportViewer1.Visible = true;
ReportDocument rDoc = new ReportDocument();
Mydataset dset = new Mydataset(); // dataset file name
DataTable dtable = new DataTable(); // data table name
dtable.TableName = "Crystal Report "; // Crystal Report Name
rDoc.Load(Server.MapPath("mycrystal.rpt")); // Your .rpt file path
rDoc.SetDataSource(dset); //set dataset to the report viewer.
CrystalReportViewer1.ReportSource = rDoc;
}
}

Output

Summary

Crystal Reports template is not a part of Visual Studio 2010 anymore but you can download Crystal Reports support from the SAP website. In this article, I demonstrated step by step procedure of creating a Website project and add a Crystal Report support. After that, I created a DataSet from a database and in the end, built a report displaying data from the database.