August 26, 2003 at 12:00 am
Comments posted to this topic are about the item Creating a PDF from a Stored Procedure in SQL Server
August 26, 2003 at 12:58 am
Wow.
Any idea how well this would scale on a production system?
Edited by - kenwallacedesign on 08/28/2003 10:09:41 PM
August 26, 2003 at 4:20 am
Very nice procedure - but the example data you provide doesn't match the graphs you display as output - or am I missing something?
August 26, 2003 at 5:36 am
I'll check on it tonight, I think something went wrong in the loading process. Bear with me!
Just guessing, I think scaling wouldnt be bad as long as the docs werent super huge. Not sure its a good idea to run on a server, but thats another story.
Andy
August 26, 2003 at 9:18 pm
Fantastic Stored Proc, however it did start to drive my server hard when I started to increase the calls. Looks like there is a lot of overhead in the OA_create calls.
August 27, 2003 at 8:29 am
Great Proc,
it works very fine!
Thanks
August 27, 2003 at 5:46 pm
Where do you find the specs for the PDF format?
I would also like to make a suggestion. I personally think that code that is shared with others should be easier to follow. One of the things that helps with that a lot is clear variable names. I have no idea what @cr, @pr, or @ti are for. Comments are also helpful. I'm not complaining, just suggesting.
James Loesch
James C Loesch
August 28, 2003 at 9:45 pm
Excellent!
Very very cute procedure for creating PDFs.
September 23, 2003 at 1:36 am
a very good one !!!
October 1, 2003 at 3:47 am
Very nice work done for PDF.
Please provide some comments in your procedure for declaring variables for PDF Format.
October 1, 2003 at 5:26 am
I agree about the comments and I'll take the blame - I load the content, should have gotten it cleaned up. I'll try to do better!
Andy
October 1, 2003 at 5:33 am
Where do you find the specs for the PDF format?
October 14, 2003 at 9:32 am
I've tried and it works quite great.
However I would like to know if it's possible to use different letter sizes and formats (bold, italic) and if it's possible to save the file in any directory.
October 16, 2003 at 2:54 am
Now, you can't use different letter properties, maybe later
to save the file in any directory
try this EXEC sql2pdf 'backup\demo'
backup is direcory
December 17, 2003 at 6:24 am
i have the following error message :
SYNTAXE ERROR TO CONVERT varchar 'TOTO' TO DATA COLUMN TYPE int...
when i tried to insert the data into psopdf
(insert psopdf(code) select nb_client + ' ' +
tx_shor_name + ' ' +
tx_full_name + ' ' +
id_acco_offi + ' ' +
cd_cli_stat from bdaccess..bsycl)
do i miss something ?
tks in advance
Viewing 15 posts - 1 through 15 (of 152 total)
You must be logged in to reply to this topic. Login to reply