on 06-10-2013 8:00 AM
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.
HI,
Please close the Thread if your Question is Closed
Regards,
Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create Original,Duplicate and tripicate ->3 reports and Use printing sequence while printing.
Regards,
Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
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.