cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal report copies

Former Member
0 Kudos

Hi experts,

                I have created customized crystal report in SAP B One. I need report copies, first as original second as duplicate  & third as triplicate, Can any .help for this issue and please tell the steps for how to do this, Its very urgent.

Accepted Solutions (0)

Answers (5)

Answers (5)

pvsbprasad
Active Contributor
0 Kudos

HI,

Please close the Thread if your Question is Closed

Regards,

Prasad

former_member917522
Participant
0 Kudos

Hi Bharat

use the following procedure and make 2 groups in crystal report

1. "Docentry"

2. procedure field "CopyDesc"

*===============*

Createprocedure [dbo].[SP_Printing_Copy]

as

begin

SELECT     1 AS 'CopyNo', 'Original for Buyer' AS 'CopyDesc'

FROM         OADM

UNION

SELECT     2 AS 'CopyNo', 'Duplicate for Transporter' AS 'CopyDesc'

FROM        OADM

UNION

SELECT     3 AS 'CopyNo', 'Triplicate for Assets' AS 'CopyDesc'

FROM        OADM

UNION

SELECT     4 AS 'CopyNo', 'Office Copy' AS 'CopyDesc'

FROM       OADM

order by CopyNo

end

and then

write this in record formula selection

{OINV.DocEntry} = {?DocKey@}

and

(if {?My Parameter}<>''then 

{SP_Printing_Copy;1.CopyDesc}={?My Parameter}

else

true

)

Regard

Akshaya Raut

Former Member
0 Kudos

Hi,

Please refer to the link :

http://scn.sap.com/thread/2007445

Hope it helps you.

Regards

pvsbprasad
Active Contributor
0 Kudos

Hi,

Create Original,Duplicate and tripicate ->3 reports and Use printing sequence while printing.

Regards,

Prasad

Johan_H
Active Contributor
0 Kudos

Hi Bharath,

The quickest and easiest way is a dedicated printer.

Just choose one printer to only print this report, and nothing else. Then set this printer to always print 3 copies.

Regards,

Johan