Creating a PDF from a Stored Procedure in SQL Server

Question

Creating a PDF from a Stored Procedure in SQL Server

Viewing 15 posts - 61 through 75 (of 152 total)

You must be logged in to reply to this topic. Login to reply

Ryan Everhart SSC Veteran Points: 203 More actions · Answer 1

Can anyone help with this this stored proc? When I open the PDF file that is created with this proc it says it has to rebuild itself, then opens fine.

Ryan

ivica Right there with Babe Points: 727 More actions · Answer 2

Try some different version of a PDF Reader.You will see is it version problem?

yzhang1121 SSC Veteran Points: 208 More actions · Answer 3

If the report row size is greater than 80, we can not use it anymore?

Thx

ivica Right there with Babe Points: 727 More actions · Answer 4

Try to change a table size and value of select substring(...,80)

yzhang1121 SSC Veteran Points: 208 More actions · Answer 5

No. Not useful. You can change table size. But one row in table is one line in pdf and it will be truncated. How can we do Word Wrap in pdf report?

Thanks

ivica Right there with Babe Points: 727 More actions · Answer 6

it is truncated in this line of a procedure select substring(...,80) but you have to change font size.

For wraping you should make a new procedure.It will make wrap and then insert into the table like 2 or more rows.

Darwin Porter SSC Enthusiast Points: 169 More actions · Answer 7

Great Tool, but what needs to be altered to copy pdf to network drive instead of 'C:\' ?

ivica Right there with Babe Points: 727 More actions · Answer 8

This line of a procedure:

SELECT @pdf = 'C:\' + @filename + '.pdf'

Darwin Porter SSC Enthusiast Points: 169 More actions · Answer 9

Yes, that line is the local directory path but if I was to point it to \\servername\d\folder on another box it will not place the pdf in that folder.

darrenkelly SSCommitted Points: 1624 More actions · Answer 10

Hi All,

First off I would like to start by saying this SP looks brillant. It does exactly what it says on the tin.

I know this topic was talked about a lot at the begining of this year, but I have just come across it and was wondering was anybody been able to answer the questions many people posed throughtout the discussion?

- An understanding of the code to create the PDF? ie a more detailed explanation of the variables?

- The ability to add in graphics in a set location into the PDF file?

- The ability to use an existing PDF template, with graphics/watermark (my idea here would be Co. letterhead template) and just populate the file then with text?

I have a few questions of my own also,

- Has anyone had any problems with this SP in a live environment? ie crashing, using high resources etc

- I need to generate either Word doc or PDF docs from my system when certain events transpire ie a creation of a record and changing of a status flag. The contents of this file will be mostly static bar for name, address, date etc. From what I can see I can achieve this easily enough by use of variables however is there a better way to achieve what I require?

Any information anyone can provide would be greatly appreciated.

Many thanks

Darren

ivica Right there with Babe Points: 727 More actions · Answer 11

ivica

Right there with Babe

Points: 727

November 18, 2005 at 4:33 am

#604591

Hi,

Darwin try to map a network drive.

T: for example

Sheshadrinath R SSC Veteran Points: 268 More actions · Answer 12

Sheshadrinath R

SSC Veteran

Points: 268

December 20, 2005 at 11:09 pm

#610762

This is really good.

Razlug SSC Enthusiast Points: 122 More actions · Answer 13

How can I add image to the generated PDF?

I know images can be stored as binary objects.

But is that something difficult to achieve?

I am curious to find out if this is achievable.

Any help or direction is appreciated.

Thanks,

Gulzar Jaggi

Natalia-252090 Right there with Babe Points: 764 More actions · Answer 14

Works awesome. Specially after adding bug fixes suggested by blinard and ivica to prevent data from being truncated:

use smaller fonts,

seting in table #pdf code nvarchar(400)

setting @trenutnired nvarchar(400)

However I would like to know if it's possible:

- add in graphics into file / or use templates with graphics/watermark

- add fonts, bold, colors, etc

- insert created file on the fly into database as a Blob without storing locally

- wrapping text inside

if anyone have solution - please post the code!

Thanks!

Natalia

Patrick-304111 SSC Veteran Points: 276 More actions · Answer 15

Patrick-304111

SSC Veteran

Points: 276

May 24, 2006 at 3:10 pm

#639912

Great! It works fine! Thanks