on 01-11-2011 9:09 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
Create three Layouts and assign them in the Printing Sequences.
I won't think this is possible by single layout.
Regards,
Bala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.