How to Print Using Crystal Reports

Submitted by: 
Visitors have accessed this post 137963 times.

This tutorial is part of Database Programming Made Easy Series.

How to Print Using Crystal Reports

Somebody is asking if I can add sample on how to print a report. So here it is. I just tweak some little changes from our previous tutorial on Windows Forms – CheckBox Control.

I did not test this from other computer so if you encounter problem on the database location just change the report data source to the directory where you save this files.

Previous: Windows Forms - TreeView Control


I am a teacher in school. I want to create an application where Multiple Choice Question Paper can be generated from listbox items. I want crystal report part of coding. Please help me.

plz help.....
how to get recode in crystal report by using SQL JOIN QUERY in C# ?


hi, got a deep interest in software development, i have a system am developing, my challenge is to link print command code to my crystal report,

i.e how to print crystal reports using, my database is ms sql....

please help, [email protected]

as for crystal reports i know a resource about it: barcode for crystal reports SDK

what version that you use sir..?
i cant open it using visual studio 2005 :(

VS 2008

thank you sir for your reply ..

it will be really nice with a video tutorial but an advice or some piece of code will be fine ..

i just need a code on how to make the output comes out .. i follow and copy some of your code that will help my program but no luck ..

by the way .. i'm using service-based database(.mdf) in visual studio 2008 .. sorry for wrong information ..

you can send me some codes or advice ..
[email protected] ..
thanks ..


i don't know if any one will answer me but, i think i have no choice but to check it out,

i been studying for crystal report in visual studio 2008 and it took me 2 weeks but i can't make it ..

i follow the tutorial in every website i came up to and i know i'm in the right track but in the end there were no output, it just show the fields and no data coming from my database, i'm really lost ..

and i try to copy this program that i downloaded here,
and no luck ..

maybe its because i'm using local database, and no server .. so if anyone know how to work with crystal report in visual studio 2008 (visual basic), using local database as back end .. email me for some advise or a program with the same case it will really help me a lot
this is my email, [email protected]

regards ..

regards ..

Wait for my video tutorial.

crystal report print previous report only

When I have "A" or "B" or "C" found in remark column of detail table, I want to print value of corrosponding record value of Mark in the header section of report how to do it

Anyone help me to submit source code of above project



i cant connect to the database in ms access, i want to save my details in database what cn i do? Please give me data connectivity code...

I need a sample code of using Crystal Report 2011 in Visual Studio .Net with C# language
I haven't found sample at internet.

please help me

I have code first u create a connection through sql.and then u bind report it will work

I need a sample code for using Crystal report 2011 in Visual studio .Net (C#)

Please help me.

how to create IBlob field in crystal report

plz send me vb code for get input.
email id - [email protected]

Hi Sir,

We have an application in our dept. "Patient information system" that was created in visual basic 6. The said system was
endorsed to me of our doctor. However, after installing the system in our desktop computer and executing it, there is an
error message "an unheld exeption has occured in your application. If you click Continue, the application will ignore and attempt to continue. If you click Quit, the application will shutdown immediately. SQL server does not exist". If we will going
to click the Continue button same error message will appear.

While SQL server 2000 was also installed in our desktop, and still theres nothing happen in our system, it does not connect on the SQL server 2000.

What should i do regarding this matter?

Thank you very much.

my email add: [email protected]

Hello Admin,

I tried to run the downloaded code, and I got this message.
Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

What I need to do to run the application?


I would like to link to MYSQL database wq table r1.

The table r1 got column RID, Rname, RAddress, REmail.

How to put all this data to DataDataSet.xsd?

Please assist.

Dear Admin,

How to make changes to the DataDataSet.xsd file? I would like to load the MYSQL database wq and table r1.

How to make the changes?

Please assist.


sir, how to manage crystal report in vb 2010, using access 2007?


I am printing labels & I want to set the limit for printing. just like only one print will be allowed to the user he cant take its multiple print how can i set this?
Pl. reply

Sir I'm a newbie in programming and I found your sample program useful and easy.. I've been searching the internet to learn crystal report in easy way..can you teach me the step by step procedure you've made..I noticed that it has dataset and I don't know how to add it and lastly how did you designed your crytal report?


i need code n step to generate crystal report in visual studio 2008 using c# n sql database... kindly send me @ [email protected] help me

ds = new DataSet();
clsActvityForm clsobj = new clsActvityForm(strCon);
ds = clsobj.GetAllReport(ViewState["SearchCriteria"].ToString());
if (ds.Tables[0].Rows.Count > 0)
CR = new ReportDocument();
CR.SetDatabaseLogon(ReportUId, ReportPWD, ReportServer, Reportdb);//"sa", "@rajkumar", "SQL2005DB\\SQLSERVER2008", "InternalProject");

ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();

crParameterDiscreteValue.Value = ViewState["SearchCriteria"].ToString();
crParameterFieldDefinitions = CR.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Criteria"];

CrystalReportViewer1.ReportSource = CR;
CrystalReportViewer1.HasCrystalLogo = false;
// CrystalReportViewer1.Zoom(82);

I am Vanita and I am New to Crystal Reports My requirement is to create a static table in report with out using any data set and parameters .
can anyone help me?


I have following questions:-

1)I want to prepare a report which user wants in his own format which contains the blocks for Full names etc...

2)The report which user require is less than A4 size paper.How to customize to exact the format of Customer?

3)How to print data exactly into the blocks contained in the printer paper and how to make the report according to the print template.

Can anyone please help to find out the solutions.
my email id :[email protected]

dear sir,
am doing my final semestr main project in php and mysql.I need to prepare manufacturing reports using crystal reports.please help me to use crystal reports in php

i just want to ask what is the code in the ASP to print a map using the crystal report? .. we are having hard times in thinking on how to code it .. please help us .. and also how to crop the image in ASP ..

how can i search data from database (mdb file) by on enter i am using a code in vb 6 the code is like this Private Sub Command5_Click()
dataPlay.Recordset.FindFirst Text39.Text
End Sub
so here is some problem is i should write (the filed name = " the id") then press ok
so i want write only the id no and press Enter please help me and send the code fore me my mail is [email protected]

i need the code to transfre textbox data to crystal report so sir if you have a code than sir please send it in my email id [email protected]

Hello hw can I get this application in C-sharp or how do I lay hands on C-Sharp reporting

Hi Jaypabs. I was checking your code. I really need you help me with a sample. If I have not included my *.mdb file in my project ¿how can I change the pathfile where the program is deployed? ¿Could you add this code in your example ? I'm using 2008 and access 2007.
I will apreciate your help.

[email protected]

i have five tab page and inside of it there are many textbox that is linked into a database using access.....plz help

sorry for the english

I want to print Barcode report accocrding to quantity which is sale to a customer.
the barcode print in many times ,as the quantity of product, how to do it by coding
send me on [email protected]

admin. i tried ur code but when i change the path of the datbase(i transfered to drive C) i got an error stating that it was an invalid path. how was that?

i want a report using programatically(using sql,select statement just like in vb 6.0)
w/o using any dataset. Help Please. Crystal report or RDLC

for instance:
I design the report (2 txtboxes/field) then i will select a data(Select * from table where ID = 'values')

then what i want is that fill the two txboxes/field in the crystal report with the requested data(base on the request(select statement))

NEED IT! Tnx sir!

how to connect several mdb databases for one crystal report at runtime in C# coding give some sample code

what if I am using sql database not access or any dataset
how do I print crystal report? pls give me the codes...


Plz send vb code for take input from weight machine


My email is [email protected]
[email protected]


sir i have to show listbox items in crystal reports with their respective data stored in their database?

ex: listbox items contain only name of the student while printing i have to show their stream class & rollno in the crystal reports...

please help me sir!!!

is it possible to print unlimited data using crystal report?
kasi ang pwede lng iprint during run time is < 20 copies lng and pag sumobra nagkakaroon ng runtime error '20544'.. panu po ba ito madebug?

can i use crystal report in PHP system??i'm now doing
e-timesheet system using,now,i need to do a report from that,can crystal report solve it??or i need another method??

Yes you can as long as you know the method. For your reference please read this:

I always use pdf as a reporting tool for my PHP script so I cannot really give you an idea on how to do this.

sir i need crystal report with (useing 2 table one master having address of party and 2 is transtaion table i want to gv billno from trasation table i need its print but address of party is with first table(master) will u help me both table shoud be in sql server

if you can please put c# code
i don't realize vb
my mail [email protected]

How do you make report to print only a row of data? And not the entire data on the database


Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.