2006 Jun 14 9:28 AM
How Do Everyone
I am about to use the program RSTXPDFT4 which converts
a spool file into a PDF file. This is ok when there there
is only say one invoice on each file.
The problem I have is that a certain spool file can have
say 100 reminder letters. If I run RSTXPDFT4 the spool
file is successfully converted into a PDF containing 100
pages. I need to split the PDF up into one file per reminder letter. In this case 100 PDF's.
Does anybody know how I can split the one spool file into
multiple PDF's.
Any help would be much appreciated.
Cheers
Andy
2006 Jun 14 10:17 AM
Hi Andy,
<b>1</b>.
Instead of splitting PDF file into 100 PDFs ,Try to generate 100 spool requests per 100 reminder letters.
<b>2</b>.
Moreover Splitting PDF is not easy .Inconsistency problem is there.
<b>Thanks,
Venkat.O</b>
How Do Everyone
I am about to use the program RSTXPDFT4 which converts
a spool file into a PDF file. This is ok when there there
is only say one invoice on each file.
The problem I have is that a certain spool file can have
say 100 reminder letters. If I run RSTXPDFT4 the spool
file is successfully converted into a PDF containing 100
pages. I need to split the PDF up into one file per reminder letter. In this case 100 PDF's.
Does anybody know how I can split the one spool file into
multiple PDF's.
Any help would be much appreciated.
Cheers
Andy
2006 Jun 14 9:39 AM
Hi andy,
why can't you generate the Separate spool for each reminder letter. this makes your Job easy.
But splliting the PDF file cause the Damage of PDF file. some times file may corrupt.
so generate Spool for each reminder. and for each get a PDF file.
Regards
vijay
2006 Jun 14 9:43 AM
Hi,
u can use these FM to convert from OTF to PDF. OTF files are avilable in system directory(AL11).
CONVERT_OTF_2_PDF
CONVERT_OTFSPOOLJOB_2_PDF
CONVERT_OTF_2_PDF_ARCHIVELINK
SX_OBJECT_CONVERT_OTF_PDF
2006 Jun 14 9:54 AM
Hi Andy,
You can use RSPO_RETURN_SPOOLJOB
with the Parameters FIRST_LINE LAST_LINE wich you have
to calculate first.
Regards, Dieter
2006 Jun 14 9:56 AM
Hai Andy
Go through the following Code
report zabap_2_pdf.
*-- Enhancements: only allow to be run with variant. Then called
*-- program will be transparent to users
*-- TABLES
tables:
tsp01.
*-- STRUCTURES
data:
mstr_print_parms like pri_params,
mc_valid(1) type c,
mi_bytecount type i,
mi_length type i,
mi_rqident like tsp01-rqident.
*-- INTERNAL TABLES
data:
mtab_pdf like tline occurs 0 with header line,
mc_filename like rlgrap-filename.
*-- SELECTION SCREEN
parameters:
p_repid like sy-repid, " Report to execute
p_linsz like sy-linsz default 132, " Line size
p_paart like sy-paart default 'X_65_132'. " Paper Format
start-of-selection.
concatenate 'c:\'
p_repid
'.pdf'
into mc_filename.
*-- Setup the Print Parmaters
call function 'GET_PRINT_PARAMETERS'
exporting
authority= space
copies = '1'
cover_page = space
data_set = space
department = space
destination = space
expiration = '1'
immediately = space
in_archive_parameters = space
in_parameters = space
layout = space
mode = space
new_list_id = 'X'
no_dialog= 'X'
user = sy-uname
importing
out_parameters = mstr_print_parms
valid = mc_valid
exceptions
archive_info_not_found = 1
invalid_print_params = 2
invalid_archive_params = 3
others = 4.
*-- Make sure that a printer destination has been set up
*-- If this is not done the PDF function module ABENDS
if mstr_print_parms-pdest = space.
mstr_print_parms-pdest = 'LOCL'.
endif.
*-- Explicitly set line width, and output format so that
*-- the PDF conversion comes out OK
mstr_print_parms-linsz = p_linsz.
mstr_print_parms-paart = p_paart.
submit (p_repid) to sap-spool without spool dynpro
spool parameters mstr_print_parms
via selection-screen
and return.
*-- Find out what the spool number is that was just created
perform get_spool_number using sy-repid
sy-uname
changing mi_rqident.
*-- Convert Spool to PDF
call function 'CONVERT_ABAPSPOOLJOB_2_PDF'
exporting
src_spoolid= mi_rqident
no_dialog = space
dst_device = mstr_print_parms-pdest
importing
pdf_bytecount = mi_bytecount
tables
pdf = mtab_pdf
exceptions
err_no_abap_spooljob = 1
err_no_spooljob = 2
err_no_permission = 3
err_conv_not_possible = 4
err_bad_destdevice = 5
user_cancelled = 6
err_spoolerror = 7
err_temseerror = 8
err_btcjob_open_failed = 9
err_btcjob_submit_failed = 10
err_btcjob_close_failed = 11
others = 12.
call function 'DOWNLOAD'
exporting
bin_filesize = mi_bytecount
filename = mc_filename
filetype = 'BIN'
importing
act_filename = mc_filename
tables
data_tab = mtab_pdf.
----
FORM get_spool_number *
----
Get the most recent spool created by user/report *
----
--> F_REPID *
--> F_UNAME *
--> F_RQIDENT *
----
form get_spool_number using f_repid
f_uname
changing f_rqident.
data:
lc_rq2name like tsp01-rq2name.
concatenate f_repid+0(8)
f_uname+0(3)
into lc_rq2name separated by '_'.
select * from tsp01 where rq2name = lc_rq2name
order by rqcretime descending.
f_rqident = tsp01-rqident.
exit.
endselect.
if sy-subrc ne 0.
clear f_rqident.
endif.
endform." get_spool_number
Thanks & regards
Sreenivasulu P
2006 Jun 14 10:17 AM
Hi Andy,
<b>1</b>.
Instead of splitting PDF file into 100 PDFs ,Try to generate 100 spool requests per 100 reminder letters.
<b>2</b>.
Moreover Splitting PDF is not easy .Inconsistency problem is there.
<b>Thanks,
Venkat.O</b>
2014 Feb 19 11:05 AM
When we run a crystal report for statements let us say for 100 growers, we get 100 statements all in one report.
Is there a functionality in Crystal Reports where the 100 statements in one report can be generated as 100 individual files(one file for each grower) in the file system ?
2014 Feb 19 11:10 AM
Hi,
I don't know Crystal Reports but I my guess would be 'No'.
Best bet is to download some free software. Just google PDF splitter and do
it manually
Andy