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

115 posts, Page 12 of 12

«««8 9 10 11 12

Creating a PDF from a Stored Procedure

Rate Topic

Display Mode

Topic Options

Author

Message

chandan.pednekar

Posted Thursday, February 28, 2013 11:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:49 AM
Points: 3, Visits: 31

Hey Ivica. Your stored procedure is very good. Thanks for that. I just want to know one thing. I am trying to get 20 columns per row. I have changed column lengths of #pdf , #xref, #text and also modified substring part to include the length.. tables and all that. The query executes properly.
The problem is that the pdf displays rows only upto a certain length. Rest of the columns are discarded or maybe cutoff.

How do I turn the orientation of pdf from portrait to landscape?
OR
How do I increase page width?

I have taken a look at Acrobat Reference Manual but didn't find anything useful as for page width or orientation.
I got some annotations for Font and RichMediawindow. For eg.
3 0 obj
<< /Type /Page
/Parent 4 0 R
/MediaBox [0 0 612 792]
/Resources << /Font << /F3 7 0 R
/F5 9 0 R
/F7 11 0 R
>>
/ProcSet [/PDF]
>>
/Contents 12 0 R
/Thumb 14 0 R
/Annots [ 23 0 R
24 0 R
]
>>
endobj

Is there anything like this I can change in sp to increase page width or orientation.

BTW. Thanks again. Your SP is great.

Post #1425362

chandan.pednekar

Posted Friday, March 01, 2013 3:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:49 AM
Points: 3, Visits: 31

Anyway I solved my problem. Apparently acrobat api doesn't have any width or orientation properties.
Width is controlled by Mediabox parameters and orientation is controlled by Rotation property.
I was able to accommodate 15 columns with consistent spacing among all rows by increasing mediabox's parameters.

That gives it a landscape orientation effect.

Also whatever formatting I did was only before the sql2pdf execution. i.e. By using SPACE() function in sql.
Maybe I'll look into how to directly enter a whole table as a parameter.

Once again.
Thanks alot.

Regards,
C.Pednekar.

Post #1425407

Mario_Williams_1988

Posted Wednesday, May 15, 2013 12:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 7:41 PM
Points: 2, Visits: 6

for creating psd files , a good software is abusolutely indispensible. I do this almost daily. I use a PDF generator driver which is found on the internet . Install it and it becomes a selectable generator option.Then you can create PDFs in any program at all, including Adobe Acrobat reader! Just open a PDF, select print, and specify the page range you want to print and select the Raster edge generator driver

Post #1452945

garethc18

Posted Wednesday, May 15, 2013 4:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 6:28 AM
Points: 1, Visits: 15

Has anyone been able to increase the max line length above 80 characters?

Nevermind. found it.

FOR SELECT SUBSTRING((code + SPACE(81)), 1, 80) FROM #text WHERE idnumber BETWEEN ((@nopg * 60) + 1) AND ((@nopg + 1) * 60 )

To

FOR SELECT code FROM #text WHERE idnumber BETWEEN ((@nopg * 60) + 1) AND ((@nopg + 1) * 60 )

Post #1453007

chandan.pednekar

Posted Thursday, June 13, 2013 5:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 5:49 AM
Points: 3, Visits: 31

I am sorry I couldn't respond to you any early. Didn't you read my previous comment?
I have clearly stated that length of the pdf horizontally can be controlled by MediaBox parameter.

But here is the catch.

Before running the sql proc you have to make sure of three things.

1. Apply consistent spacing using the SPACE() function in sql server.
2. Increase width of following parameters -
- #pdf , #xref, #text and MediaBox
3. Enable a monospace font in the sql2pdf proc. If you don't then despite of equivalent and consistent spacing the formatting would be messed since other fonts which are not monospace output characters in different widths.

Finally fill the table with the formatted data and then run the query.

TBH you can work a lot on this and get a decent enough output but its really not worth the effort.
I asked my manager and got this functionality replaced with SSRS 2005.

Anyway.
Later.

Post #1462998

« Prev Topic | Next Topic »

115 posts, Page 12 of 12

«««8 9 10 11 12

Permissions