Click here to Skip to main content
15,400,390 members
Articles / Programming Languages / C#
Posted 13 Jan 2006


118 bookmarked

Creating Crystal Reports using C# with Datasets

Rate me:
Please Sign up or sign in to vote.
4.40/5 (56 votes)
13 Jan 2006CPOL3 min read
This is a sample that guides you to create reports with Crystal Reports using C# Datasets, which is the best and the easiest way to create reports.
Sample screenshot


This article is about creating Crystal Reports using C#.NET. About two weeks ago, one of my friends asked me for this kind of example. He also searched through the Internet and said that he couldn't find a sample. When I was doing this kind of development, I also looked for samples, but I couldn't find one. That’s why I wrote this article on The Code Project without creating reports separately using Crystal Reports other than using .NET IDE.

Create a Dataset

First you should create a Dataset to get data from the DB. By clicking the “Add New Item” in the “Project” menu, you can add a Dataset. A picture of an added Dataset looks like the following window and you can add elements to the Dataset by dragging and dropping elements from the toolbox. This Dataset is used to fill the data, which it gets from the DB by using a query. Because of that, the names of the elements in this Dataset should be equal to the names of the elements in the DB. For an example, this Dataset can fill using the following query.

String connString = @"Provider=Microsoft.Jet.OLEDB.4.0;_
	Data Source=..\\..\\myDB.mdb;User ID=Admin;Password=";

OleDbConnection conn = new OleDbConnection(connString);
string query = "SELECT studentID, firstName, lastName, birthDate, _
				address, contactNo FROM studentInfo";
OleDbDataAdapter oleDA = new OleDbDataAdapter(query,conn);
Sample screenshot

Create a Report using Crystal Reports

Now that we have a created Dataset, we can use it to fill the report with data, which we will be getting from the DB. As I mentioned before, you can add a Crystal Report to the project by clicking “Add New Item” in the “Project” menu. Then the following window will appear, and you can select your choices and click OK.

Sample screenshot

The next window looks like the following and you have to select your created Dataset under “Project Data”, and click “Insert Table”, then click next.

Sample screenshot

Then you have to add the field, which you want to display in the report through the following window and click next.

Sample screenshot

You can also go to other tabs of this window and select/deselect your choices. Use the last tab “Style” to select the format of the report. You can also type a Report Title here and click finish.

Sample screenshot

Then your report creation is done by the .NET IDE. If you want to make any changes to the report, you can do so by using the .NET IDE.

Set the Created Report to Display in the Form

Then you have to set a “crystalReportViewer” in your form to load the report that you created earlier. Moreover, you need to set the report source of this “crystalReportViewer” component, which falls in the properties panel or you can set the report source by using the code like the following:

// code to get data from the DB
DBConnection DBConn = new DBConnection();
OleDbDataAdapter myDataAdapter = DBConn.getDataFromDB();

// use the created Dataset to fill it with data got
// from the DB by using the DataAdapter
DataSet dataReport = new DataSet();
// create a new report from the created CrystalReport
myDataReport myDataReport = new myDataReport();

// set the data source of the report

// set the report source of the created "crystalReportViewer"
// component to the created report
crystalReportViewer1.ReportSource = myDataReport;

Additional Information

You can also create reports using Crystal Reports separately without using the .NET IDE. For that, you have to install Crystal Reports as well, and you should save those reports in a directory. Then you have to set the report source of the “crystalReportViewer” component to the particular report under your report Directory. For example:

crystalReportViewer1.ReportSource = @"..\Reports\salesReport.rpt";

But a better way is the previous one, because we can get data from the DB according to the inputs, which are done by the user of the Applications.

Regarding this article, you can send any questions to I will send you any information that you want for your development.


  • 13th January, 2006: Initial post


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Ishara Gunarathna
Web Developer
Sri Lanka Sri Lanka
I'm Ishara Gunarathna, working as a Software Engineer. If you meet me someday, somewhere say hi to me.

Comments and Discussions

QuestionPrint multiple pages Pin
Peter River17-Nov-15 1:36
MemberPeter River17-Nov-15 1:36 
QuestionThanks! Pin
resgistrosmails30-Apr-15 7:04
Memberresgistrosmails30-Apr-15 7:04 
Questioncrystal report login promt Pin
Member 933429120-Jan-15 23:50
MemberMember 933429120-Jan-15 23:50 
Generalmy vote 5 Pin
An@nd Rajan1017-Dec-13 19:23
professionalAn@nd Rajan1017-Dec-13 19:23 
GeneralRe: my vote 5 Pin
leveena13-Feb-14 20:16
Memberleveena13-Feb-14 20:16 
GeneralMy vote of 5 Pin
Suman Zalodiya19-Jun-13 18:52
MemberSuman Zalodiya19-Jun-13 18:52 
QuestionCrystal Report Pin
ntitish5-Mar-13 21:24
Memberntitish5-Mar-13 21:24 
QuestionHow Print Customer Recepiet??? Pin
kashifjaat29-Nov-12 16:45
Memberkashifjaat29-Nov-12 16:45 
GeneralMy vote of 5 Pin
Chathura Roshan1-Nov-12 20:05
MemberChathura Roshan1-Nov-12 20:05 
QuestionC# .net Pin
Janu Kya Kar Rahi ho6-Sep-12 21:17
MemberJanu Kya Kar Rahi ho6-Sep-12 21:17 
QuestionThanks Pin
Internee@C#16-Jul-12 1:54
MemberInternee@C#16-Jul-12 1:54 
QuestionThanks Pin
Soheera19-Jun-12 0:58
MemberSoheera19-Jun-12 0:58 
Questioncrystal report Pin
devmurari hitarthi16-Apr-12 20:50
Memberdevmurari hitarthi16-Apr-12 20:50 Pin
devmurari hitarthi16-Apr-12 19:43
Memberdevmurari hitarthi16-Apr-12 19:43 
GeneralMy vote of 5 Pin
Manoj Kumar Choubey30-Mar-12 3:21
professionalManoj Kumar Choubey30-Mar-12 3:21 
GeneralMy vote of 2 Pin
sravan_34128-Mar-12 0:07
Membersravan_34128-Mar-12 0:07 
GeneralMy vote of 5 Pin
nitinpandit21-Mar-12 21:04
professionalnitinpandit21-Mar-12 21:04 
GeneralCrystal reports from data gridview??? Pin
Chathurange17-Jun-11 6:55
MemberChathurange17-Jun-11 6:55 
Questioncreating crystal reports Pin
080702728-Apr-11 4:16
Member080702728-Apr-11 4:16 
GeneralSetting page header dynamically in crystal report Pin
Member 401433910-Aug-10 16:58
MemberMember 401433910-Aug-10 16:58 
GeneralGetDataFromDB method Pin
yandroide22-Apr-10 6:32
Memberyandroide22-Apr-10 6:32 
QuestionWhere did myDataReport class come from? Pin
crystalriver27-Feb-10 4:07
Membercrystalriver27-Feb-10 4:07 
AnswerRe: Where did myDataReport class come from? Pin
Thesisus28-Apr-10 5:59
MemberThesisus28-Apr-10 5:59 
GeneralGood job dude ! Pin
balaji_ram25-Feb-10 3:10
Memberbalaji_ram25-Feb-10 3:10 
GeneralTitle Set Pin
eusufkhan21-Feb-10 21:36
Membereusufkhan21-Feb-10 21:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.