How to Print Using Crystal Reports

Submitted by admin on Sunday, July 12, 2009 - 12:06.

This tutorial is part of Database Programming Made Easy Series.

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

Comments

data searching

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]

PRINTING IN ASP USING CRYSTAL REPORT

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 to make crystal report

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

Customize the Print File according to USer requirements.

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]

code for crystal report using c# n sql

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

Example fro Crystal Report in VS2008

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);

Hi

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?

Step by step procedure

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

how to set the print quntity

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

vb 2010

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

Change the DataDataSet.xsd

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

How to change the DataDataSet.xsd

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.

Error Code

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?

How to connect an existing application in sql server 2000

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]

Take input from Weight Machine

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

error

how to create IBlob field in crystal report

I need a sample code

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

sample 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

Ho k

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

i want help for my software in vb.net

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

you can search through the net for connection string

you can find connection string for all the database in http://connectionstrings.com/

C# net 2010 with Access 2010 conect from oledb

Anyone help me to submit source code of above project Thanks Lalith

Crystal Report

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

crystal report print previous report only

Crystal Report Basic for Visual Studio 2008

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

Wait for my video tutorial.

thank you sir for your reply

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