Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Creating a PDF from a Stored Procedure Expand / Collapse
Author
Message
Posted Wednesday, October 1, 2003 5:26 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 7:55 AM
Points: 6,779, Visits: 1,858
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
http://www.sqlservercentral.com/columnists/awarren/




Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #72334
Posted Wednesday, October 1, 2003 5:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 4:58 AM
Points: 13, Visits: 20
Where do you find the specs for the PDF format?

http://partners.adobe.com/asn/tech/pdf/specifications.jsp




Post #72335
Posted Tuesday, October 14, 2003 9:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 25, 2008 4:42 AM
Points: 22, Visits: 24
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.




Post #72336
Posted Thursday, October 16, 2003 2:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 18, 2003 12:00 AM
Points: 4, Visits: 1
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



Post #72337
Posted Wednesday, December 17, 2003 6:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 7, 2013 2:36 AM
Points: 9, Visits: 13
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





Post #72338
Posted Thursday, December 18, 2003 12:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 18, 2003 12:00 AM
Points: 4, Visits: 1
convert int column into varchar by cast




Post #72339
Posted Thursday, December 18, 2003 3:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 7, 2013 2:36 AM
Points: 9, Visits: 13
quote:

convert int column into varchar by cast



i dont get what u said...sorry...coz the column of psopdf is already in varchar
why sqlserver tried to convert 'TOTO' in to the INT column? where does this "INT column" come from ? i really dont get it...sorry

can u pls explain ? tks




Post #72340
Posted Wednesday, January 21, 2004 12:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 4:58 AM
Points: 13, Visits: 20
try like this --> SELECT CAST(nb_client AS VARCHAR) + ' ' + CAST(tx_shor_name AS VARCHAR) ...


Post #96471
Posted Monday, February 23, 2004 9:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 27, 2008 1:10 PM
Points: 1, Visits: 23
WOW! A++++++ this is a super procedure! Kudos to you for all your hard work! I am using this on a production DB that logs all firewall / web traffic event logs. I then setup this up as a job that runs daily and creates pdf reports based upon various criteria. Again, great job on the procedure and thanks for giving those easy to understand screenshots and how to's!


Post #101777
Posted Monday, February 23, 2004 1:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 19, 2012 8:15 AM
Points: 42, Visits: 187
Excellent, excellent sp!


Post #101829
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse