Hi,

Darwin try to map a network drive.

T: for example

 This line of a procedure:

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

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...

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

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

You don't need to install any fonts. Check IE version. Those 2 files are OK. Start html file from c: drive and that's it!

New procedure

After EXECUTE @ole

SELECT  @ole

have to be

-----------

0

help link:

http://www.databasejournal.com/features/mssql/article.php/10894_1459181_1

or read previous posts

Page dimension is 80x60 chars.You can make virtual table:

INSERT psopdf(code)

  SELECT SUBSTRING((city+ SPACE(20)),1,20)

  + SUBSTRING((state+ SPACE(10)),1,20)

  + SUBSTRING((address+ SPACE(25)),1,20)

FROM  authors

EXEC sql2pdf 'demo1'

Playing with SUBTRING you can get text alignment (demo1...

If I have about 1650 rows in the table

psopdf the SP will crash at line

162:

Server: Msg 8152, Level 16, State

4, Procedure sql2pdf, Line 162

String

or binary data...

Hi,

Excellent script.

However, there is  a glich. No sorting in #text and in psopdf, hence you cannot guarantee

the resulting pdf report data order.

So, can you please include:

CREATE TABLE psopdf (

pkey int...

try like this --> SELECT CAST(nb_client AS VARCHAR) + ' ' + CAST(tx_shor_name AS VARCHAR) ...

Where do you find the specs for the PDF format?

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