EPSON LQ - 2180 ESC/P2 : print setting problem from SAP b1 8.8 PL 19

[Former Member]

Hi All,

we are SAP Business One Customer, I have created Crystal Report and using Printer : 'EPSON LQ - 2180 ESC/P2',

I have selected Same Printer in Printer Option

Orientation is 'Portrait'

Paper Size 'US Std Fanfold'

but print out comes in Vertical Format, we want to print it in Horizontal format

I Tried many times in Landscape and Portrait format but print comes in Vertical format.

I have checked some following conditions:

1. If printer is in 'Portrait' format then test print is OK..

2. If Crystal Report is in 'Portrait' format then test print is OK..... directly print from Crystal Report

3. whenever I take print out from SAP B1 for same Crystal Report with same setting but print comes in vertical format.

I am attaching Print Setup screen print with this mail, pls kindly find the attachment.

Pls give me feasible Solution as soon as possible.

Thanking you in an obligation.

Regards,

Babu Terve

[former_member541807]

hi Babu,

check this SAP Note: [1535606 - Printer preference setting for the Crystal Layouts|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3030303135333536303626]

Note: you need to use your S-Account to access this note

regards,

Fidel

[Former Member]

Hi Fidel,

I din't get it, Pls can u explain in details...

Regards..

Babu

Edited by: Datta Kharat on Dec 21, 2011 8:45 AM

[former_member541807]

hi Datta,

when you say S-Account, this account is needed when we use the SAP Portal. Contact your SAP Partner to get your S-Account. regarding the note i will quote it here

1535606 - Printer preference setting for the Crystal Layouts


Symptom

Print Crystal Report layout does not consider Business One (B1) printer preferences changed by user before printing.

In order to enable B1 to make print preferences changes in application the Crystal Report Layout must have ticked off the "Dissociate Formatting page Size and Printer Paper Size" option in page setup.

The following preferences are enabled for the Crystal Reports Layouts:
1. Orientation: "Portrait" or "Landscape".
Note! In case the report is too wide to fit on rotated page, error message is returned.
2. Document Options: Duplex printing (Print on both sides).
3. Paper Options: Paper size.
Note! The options Custom Size will not be considered by B1.
Note! In case it is not possible to print on some paper size error message is returned.
4. Paper/Quality: Print Quality/Printer Resolution, Paper Source.
5. Color Options.

Note! Crystal does not resize the report to fit the selected paper or format.


Cause

Application error


Solution

As a workaround, please change the Page Setup to Landscape in Crystal
Report designer itself.

SAP intends to provide a patch or patches in order to solve the problem
described. The section Reference to Related Notes below will list the
specific patches once they become available. The corresponding Info file of the patches in SAP Service Marketplace will also show the SAP Note number. Please note that these references can only be set at patch
release date. SAP will deliver patches only for selected releases at its own discretion, based on the business impact and the complexity of the implementation.



Other terms

Print Setup, print preference



Header Data

Released on	06.12.2010 15:05:56
Release status	Released for Customer
Component	SBO-REP-CR Crystal Reports 2008 for SAP Business One
Other Components	
SBO-GEN-PRT Printing Issues
Priority	Correction with medium priority
Category	Program error

References

This document refers to:

SAP Business One Notes
1540128	 	Overview Note for SAP Business One 8.8 Patch 18
This document is referenced by:

SAP Business One Notes
1540128	 	Overview Note for SAP Business One 8.8 Patch 18


Validity

Software Component
Version
SAP BUSINESS ONE
8.8

regards,

Fidel

[former_member210693]

Hi Fidel,

Thanking you...

Now print out print in Landscape format, but print in letter format, I want to print in "US Std Fanfold". Report has 21 coloumn, it is very wide page. our previous print out in SQL Server Reporting Service but speed is very less so now I designed in Crystal Report format to print directly from SAP B1 8.8..

Regards..

Babu Terve

[former_member541807]

hi,

install your Printer driver from the PC w/c you design your Crystal Report. then choose your paper size "US Std Fanfold". . n your Crystal Report IDE goto File -->> Page Set up, then set your paper size in Page options.

regards,

Fidel

[former_member210693]

Hi Fidel,

I installed EPSON printer drivers on the System, but print out print in Letter format, Report has 21 coloumns,

It print only 15 columns in Small size and remaining 6 columns are not printing,

May I know your E-Mail Id so I will mail you Print Setting and Print format.

Thanking You..

Regards

Babu Terve

[former_member541807]

hi,

yes you send it to me. check my profile

regards,

Fidel

[former_member210693]

Hi....

Pls give me some solution, I hav mailed u all screen print s.

Thanking u

Regards,

Babu