Skip to main content

How to Print Using Crystal Reports


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

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Submitted byAnonymous (not verified)on Fri, 09/24/2010 - 20:25

sir 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]
Submitted byAnonymous (not verified)on Wed, 10/13/2010 - 18:22

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 ..

Submitted byAnonymous (not verified)on Wed, 10/13/2010 - 19:36

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

Submitted byAnonymous (not verified)on Sat, 11/27/2010 - 00:31

Sir,

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]

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.Load(Server.MapPath("ReportActivityChart.rpt"));
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();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinitions = CR.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["@Criteria"];
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

CrystalReportViewer1.ReportSource = CR;
CrystalReportViewer1.DataBind();
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?

Submitted byAnonymous (not verified)on Fri, 03/11/2011 - 13:01

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?

Thanks

Submitted byAnonymous (not verified)on Wed, 03/23/2011 - 20:58

HI,

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

Submitted byAnonymous (not verified)on Tue, 04/05/2011 - 19:07

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

Submitted byAnonymous (not verified)on Tue, 04/12/2011 - 10:31

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.

Regards,
Alice

Submitted byAnonymous (not verified)on Tue, 04/12/2011 - 10:34

Admin,

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.

Submitted byAnonymous (not verified)on Tue, 04/12/2011 - 10:50

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?

Submitted byAnonymous (not verified)on Tue, 05/17/2011 - 14:35

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.

William
my email add: [email protected]

Submitted byAnonymous (not verified)on Thu, 07/28/2011 - 21:08

how to create IBlob field in crystal report

Submitted byAnonymous (not verified)on Sun, 08/21/2011 - 16:38

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

Please help me.

Submitted byAnonymous (not verified)on Sun, 08/21/2011 - 16:46

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

Submitted byAnonymous (not verified)on Tue, 09/27/2011 - 19:05

In reply to by Anonymous (not verified)

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

Submitted byAnonymous (not verified)on Wed, 10/26/2011 - 19:56

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...

Submitted byrajesh Kumar (not verified)on Wed, 01/25/2012 - 19:50

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

Submitted bysukamichi (not verified)on Sat, 05/12/2012 - 20:49

Hi,

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 ..

Submitted bysukamichion Mon, 05/14/2012 - 15:57

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 ..

Submitted bysaiful (not verified)on Wed, 05/16/2012 - 22:23

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

Submitted byjames ndungu (not verified)on Sat, 01/18/2014 - 13:19

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 vb.net, my database is ms sql....

please help, [email protected]

Submitted bykr kumawaton Sat, 12/13/2014 - 02:26

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

Submitted byThadani Govind (not verified)on Wed, 05/06/2015 - 22:28

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.

Add new comment

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.