Crystal report to dot matrix

Question

0.00/5 (No votes)

See more:

Hi there !

I am using Crystal Reports to print a report directly to the printer. When the report is sent to the printer, it always prints A4 size. Below is the code I'm using:

VB

Dim pd As New PrintDocument()

pd.DefaultPageSettings.PaperSize = New System.Drawing.Printing.PaperSize(&quot;Reserved48&quot;, 280, 3276)
Cmd.Connection = Con
Cmd.CommandTimeout = 0
Cmd.CommandType = CommandType.Text
SQL = &quot; Select * from City &quot;
Cmd.CommandText = SQL
DA.SelectCommand = Cmd
DA.Fill(DS, &quot;Rep&quot;)
oReport = New CrystalDecisions.CrystalReports.Engine.ReportDocument
oReport.PrintOptions.CustomPaperSource  =
Dim strSystemName As String = &quot;\\main\&quot;
Dim strPrinterName As String = &quot;EPSONLQ-&quot;
oReport.PrintOptions.PrinterName = strSystemName &amp; strPrinterName
oReport.PrintOptions.PrinterName = printername
Dim doctoprint As New System.Drawing.Printing.PrintDocument()
doctoprint.PrinterSettings.PrinterName = &quot;\\main\&quot; '(ex. &quot;Epson SQ-1170 ESC/P 2&quot;)
Dim i As Integer
oReport.Load(&quot;d:\Invoice.rpt&quot;)

Response.Write(oReport.PrintOptions.PageContentHeight)
Response.Write(oReport.PrintOptions.PageContentWidth)

oReport.Database.Tables(0).SetDataSource(DS.Tables(&quot;Rep&quot;))
oReport.PrintOptions.PaperSize = CType(System.Drawing.Printing.PaperKind.Custom, CrystalDecisions.Shared.PaperSize)
oReport.PrintToPrinter(1, False, 0, 0)

The desired size is 3 by 9 inches. Please guide me in this. Thanks in advance!

Posted 26-Jan-11 8:39am

Nauman Sarwar

Updated 26-Jan-11 11:25am

Smitha Nishant

v3

Add a Solution

Comments

Manfred Rudolf Bihy 26-Jan-11 14:51pm

Added code tags.

Nauman Sarwar 26-Jan-11 15:00pm

Hi Manfred!

I do not get your answer ?

Manfred Rudolf Bihy 26-Jan-11 15:14pm

That was not an answer it is called a comment. My comment was purely informational and tells you that I edited your question to add code tags. Using code tags makes program code that you include in your questions (or answers) look neatly formatted with a fixed width font and including syntax highlighting.

Christian Graus 26-Jan-11 15:50pm

Do you REALLY want your website to print to a physical printer in the server room ?

Nauman Sarwar 26-Jan-11 15:59pm

Yes i really want that and its locally hosted

Christian Graus 26-Jan-11 17:33pm

Your question still has nothing to do with ASP.NET, the printer has no idea it's printing from a web server.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

thatraja · Answer 1 · 2011-01-26T15:12:00

Solution 2

Already I have answered for this kind of question on last month.

Crystal report change paper size[^]

Also take a look at this one

Crystal report: resizing papersize[^]

Posted 26-Jan-11 15:12pm

thatraja

Updated 26-Jan-11 15:16pm

v2