cancel
Showing results for 
Search instead for 
Did you mean: 

Print multiple copies in Crystal Report

former_member689126
Active Contributor
0 Kudos

Hi All,

I have created layouts with Crystal 2008 . I need to print first copy as original , second as duplicate and the third as triplicate . I know it is possible using PLD but i need it in CR. Is there any work-around for this problem ? I am using SAP Business One 8.8 PL 10 , Crystal Reports Basic 2008 and SQL Server 2008.

Thanks in advance

Regards

ARUN

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Arun

Create a view which has a record for each copy and the docentry. I tested using the view below but it could easily be extended to include the object type and be useful for all documents.

CREATE VIEW [dbo].[Test_Copy]

AS

select 1 as 'CopyNo',

'Original' AS 'CopyDesc',

DocEntry AS 'InvDocentry'

from oinv

union

select 2 as 'CopyNo',

'Duplicate' AS 'CopyDesc',

DocEntry AS 'InvDocentry'

from oinv

union

select 3 as 'CopyNo',

'Triplicate' AS 'CopyDesc',

DocEntry AS 'InvDocentry'

from oinv

Add this view to your layout and inner join to docentry of the OINV table

Add the copy number as the main group level, before the document etc.

You will then need to fiddle around setting the current page header details into the group 1 header and sort the paging out but you will get 3 copies.

Hope this helps

Rob

former_member689126
Active Contributor
0 Kudos

Hi Rob

Thanks for your reply.It helped a lot. The problem is solved. Thanks a lot..

Regards...

Arun

Former Member
0 Kudos

Hi there,

can you explain how you achieve this:

"Add the copy number as the main group level, before the document etc.

You will then need to fiddle around setting the current page header details into the group 1 header and sort the paging out but you will get 3 copies."

I cant find a main group level before the document.. i have the report header on the top, then page header a, b and c, then the Group Header #1 and so on..

Need help.

Thank you.

LB

Former Member
0 Kudos

Hi Luis

The first group is on docentry.

Using the group expert, add another group on the copy number and then move it to be the first group.

Hope this helps.

Rob

0 Kudos

Hi Rob,

Your solution is working fine, but my existing report have subreport which got deleted as crystal does not allow multi level subreport.

Please help on this.

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Sir Can you please explain me , because i have same problem arise. i required 4 invoice copy each one stated wirh 'ORIGINAL','DUPLICATE','TRIPLICATE','EXTRA' COPY..

kvbalakumar
Active Contributor
0 Kudos

Hi Arun,

Create three Layouts and assign them in the Printing Sequences.

I won't think this is possible by single layout.

Regards,

Bala