Creating a PDF from a Stored Procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by M Ivica » Creating a PDF from a Stored Procedure

114 posts, Page 2 of 12

««1 2 3 4 5 »»»

Creating a PDF from a Stored Procedure

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Wednesday, October 01, 2003 5:26 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

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
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #72334

ivica

Posted Wednesday, October 01, 2003 5:33 AM

Grasshopper

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

amfps

Posted Tuesday, October 14, 2003 9:32 AM

Grasshopper

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

ivica-105479

Posted Thursday, October 16, 2003 2:54 AM

Forum 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

sokun2003

Posted Wednesday, December 17, 2003 6:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 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

ivica-105479

Posted Thursday, December 18, 2003 12:36 AM

Forum 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

sokun2003

Posted Thursday, December 18, 2003 3:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 07, 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

ivica

Posted Wednesday, January 21, 2004 12:41 PM

Grasshopper

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

gimpygoat

Posted Monday, February 23, 2004 9:45 AM

Forum 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

dgentry

Posted Monday, February 23, 2004 1:59 PM

SSC 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 »

114 posts, Page 2 of 12

««1 2 3 4 5 »»»

Permissions