Tip: How to Print a Crystal Report Programmatically in ASP.NET?

 hi

I m kavita,My problem is L want to go another page when I click a row in crystal report

suppose I have 100 row in my report n when I click  a Row I want to go detail page is it possible

please help me

priya_pooja12324@yahoo.co.in

hi, Printtoprinter method is printing on serverside.But I want to print directly on client side printer.it is very urgent.Please help me.I need to print from web based POS BIll system. Thanks, Akila

Hi,

 

I have to do the same thing. Please let me know if you solved your problem and got success in printing Crystal Report Client Side.

 

Thanks a lot in advance

hi akila I have to do the same thing. Please let me know if you solved your problem and got success in printing Crystal Report Client Side thanks

how to connect from gridview to crystalreport directly thatmeans we are adding columns in gridview dynamically so with those columns we have to generate crystal report dynamically

I don't think you can connect a GridView with Crystal Report. You will have to add that column to your DataSet, which has data in it dynamically and pass that to the report.

hi i am suresh, i need to print crystal report from web page.

Isn't this article shows how to print a report from a Web page?

how will i do this for windows based application? Please provide me the solution i need it urgently

The code will be same for Windows application as well.

Is it possible to set Paper Style in Crystal Report through AP.net. I want to set Paper Type eg. Fanfold 15 X 12 in for all report.

Hi Mr. Mahesh. May I know what are the namespace I need to include? Coz I have the following errors - 1. Dim DS As DataSet = GetData() -Name GetData is not declared 2. MyReport does not appear on the intellisense. Thanks

MyReport is the report you created as rpt file and added to your proejct.

GetData is my own method that returns the data from the database in a DataSet format. You have to write this method to get the data from the database.

Hi I am currently working on a VB.NET project with following requirements : Suppose I have to print .doc file having 10 pages using VB.Net program and after clicking on print button,suppose printer finishes printing 6 pages and then suddenly printer is out of papaer/light is off ,etc. then if I check the printer properties then it should not show remaining 4 pages in the queue. i.e. Generally what happens is that first 10 pages are taken into buffer of printer and then printing starts. But problem is that if printing operation stops due to some reason, then remaining pages will be in buffer. So I dont want that all pages should be in buffer.I want to print these pages one by one, so that if printing is stopped due to some reason then there should be no pages in queue. So how it can be done using vb.net programming

Hello experts.. Please help me.. I need to print last page of data using Crystal Report. Please reply me have any idea as soon as possible. Thank you

i want to print report with print Button in web site but when i click this button show java script error why? please help mi. thanks

Hi....

on Clicking Print _ Btn

We can Open the Crystal Report in aPdf File Format and from there we can print the Crystal report

coding:

Dim Crpt As CrystalTestReport2

Dim MyTable As CrystalDecisions.CrystalReports.Engine.Table

Dim MyLogin As CrystalDecisions.Shared.TableLogOnInfo

 

Dim oStream As New System.IO.MemoryStream

Crpt = New CrystalTestReport2

Crpt.PrintOptions.PaperSize = PaperSize.PaperA4

Crpt.PrintOptions.PaperOrientation = PaperOrientation.Landscape

 

CrystalReportViewer1.ReportSource = Crpt

For Each MyTable In Crpt.Database.Tables

MyLogin = MyTable.LogOnInfo

MyLogin.ConnectionInfo.UserID = "sa"

MyLogin.ConnectionInfo.Password = ""

MyTable.ApplyLogOnInfo(MyLogin)

Next

 

 

Dim ReportDiskDestination As New CrystalDecisions.Shared.DiskFileDestinationOptions

Dim FileName As String = "c:\TestPDF\myreport2.pdf"

ReportDiskDestination.DiskFileName = FileName

With Crpt

.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile

.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat

.ExportOptions.DestinationOptions = ReportDiskDestination

.Export()

End With

Response.Redirect("c:\TestPDF\myreport2.pdf")

hi have u finish the client side printing successfully if means can u send the method to me??? i hope soon regards riyaz

Hi Mahesh, I am getting error of Load report failed when I try to access crystal report using my asp.net application, can you give me one solution.

Hi , Using VS 2005 with integrated crystalreport On my computer is good developer parameters can be taken into consideration. But when I deploys on a client with clickonce I get an error on the reports with parameters Thanks

hi, I m shashank, my problem is that I want to print current values of web page in the form of bill by using the crystal report and also want to add the same values in the database by clicking the single button please help me........

 Hello All of You,

I am sapna,I have problem of print crystal report on server .when i Click on print option it is not tak any action

please help me

goldsapna@gamil.com

C# Code.
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
//_strFileName = Report Path
rptDoc.Load(_strFileName);

CrystalDecisions.Shared.TableLogOnInfo logOnInfo = null;

// Get the ConnectionInfo Object.
CrystalDecisions.CrystalReports.Engine.Tables  rptTable;
rptTable = rptDoc.Database.Tables;
for(int i=0 ; i < rptTable.Count ; i++)
{
 logOnInfo = new CrystalDecisions.Shared.TableLogOnInfo(); 
 logOnInfo = rptDoc.Database.Tables[i].LogOnInfo;
 ConnectionInfo connectionInfo = new ConnectionInfo();
 connectionInfo = logOnInfo.ConnectionInfo;

 // Set the Connection parameters.
 connectionInfo.DatabaseName = _strDBSName;
 connectionInfo.ServerName = _strDSN;
 connectionInfo.Password = _strUserID;
 connectionInfo.UserID = _strUserPWD;
 rptDoc.Database.Tables [i].ApplyLogOnInfo(logOnInfo);
}
PageMargins margins;
// Get the PageMargins structure and set the
// margins for the report.
margins = rptDoc.PrintOptions.PageMargins;
margins.bottomMargin = 350;
margins.leftMargin = 350;
margins.rightMargin = 350;
margins.topMargin = 350;
// Apply the page margins.
rptDoc.PrintOptions.ApplyPageMargins(margins);
rptDoc.PrintOptions.PrinterName = strPrinterName;
rptDoc.PrintToPrinter(_nCopies,false,0,0);

Hi All,
Do you have any snippet code to print crystal report in client side?
Thanks.

Dear Sir,
             I have a doubt in print receipt, I created one application which shows data fully in crystal report and it print in A4 sheet. I dont want like that , i want to print data as like as a Medical Shop billing Paper. I think you may understand what i am trying to say.


Looking for your Anticipation reply

Thanks and Regards
Aravind G
g_aravind6@yahoo.com
Chennai

Hi,
I did this code to my project but it is working only on local machine it is not working on server.
Please, Help Me.

Thank You,
Maulik

i'm using crystal reports in Asp.Net with C#. But in this Print Button is not working.

Hi,
I have an application which is developed on VS 2005, and I am able to take a Printout which is designed in Crystal Reports which comes with VS2005 Default. But when I host the same app on the Server, then I am unable to take the Printout. The Images on CR is showing Cross Marked. Please suggest me on the same.
Thanks in Advance.
RaviPola.

Hi, I have a crystal report which i created for my POS system. Is there a way to automatically grow the size of the Details section of the report depending on the amount of rows that are going to be added to the report. It's really very urgent. Plz reply, Thanks in advance, Zehan

Hi Mahesh, I am trying to print a Crystal report thru a WCF service. When I am running the WCF service in a stand alone mode the Crstal report is getting printed correctly. Now when a client is trying to call that service [which in turn prints the report], is giving the following error : "RPC server not available". Stach Trace : at System.Drawing.Printing.StandardPrintController.OnStartPrint(PrintDocument document, PrintEventArgs e) at System.Drawing.Printing.PrintController.Print(PrintDocument document) at System.Drawing.Printing.PrintDocument.Print() at CrystalDecisions.CrystalReports.Engine.FormatEngine.PrintToPrinter(Int32 nCopies, Boolean collated, Int32 startPageN, Int32 endPageN) at CrystalDecisions.CrystalReports.Engine.ReportDocument.PrintToPrinter(Int32 nCopies, Boolean collated, Int32 startPageN, Int32 endPageN) at CISPrintService.PrintService.DoBatchPrint(PrintDC PobjPrintDC) in C:\Inetpub\wwwroot\CISPrintService\PrintService.svc.cs:line 91 I have checked all the following service is up & running: 1)Printer Spooler 2) RPC 3) RPC Locator Could you please help me in this regard? Thanks, Anirban

report.PrintToPrinter(1, False, 0, 0) this code doesn't work while i deploy the application on iis server.. please help

Hi.. Can u send ur code to my mail(send2mm@gmail.com)..... if not means add script manager to ur code.. that will works fine.

hi mani, report.PrintToPrinter(1, False, 0, 0) this code doesn't work on server its works fine on localhost... and what is the purpose to add script manager?

Hi, Sometimes when u hosting on server the Print button won't works because of DLL problem. So you need to add Script Manager.If you send that code means i'll say exact problem.