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 «««910111213»»»

Creating a PDF from a Stored Procedure Expand / Collapse
Author
Message
Posted Thursday, July 21, 2011 5:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, September 10, 2011 6:39 AM
Points: 2, Visits: 3
Hi. I tried this stored procedure and the example given. In Sql Server 2005, it runs fine but i m not able to locate the file("demo2" in this case) created.

I even searched it but no result found.

Please tell me where is the file created and how can i locate that.
Post #1145750
Posted Thursday, July 21, 2011 5:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, September 10, 2011 6:39 AM
Points: 2, Visits: 3
I changed the directory to D: in the following line...

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

Its working fine now.


Great work done by the creator of this sp!!
Post #1145760
Posted Thursday, September 22, 2011 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 27, 2011 6:07 AM
Points: 1, Visits: 5
this script creates extra overhead. how do you prevent the extra overhead? file sizes are increased by 60% at least because of this.

ideas?
Post #1179478
Posted Wednesday, September 28, 2011 4:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 8, 2013 10:09 PM
Points: 4, Visits: 25
i dont know why but it's not working for me menas not creating pdf file even no any errors saw to me any idea
please help me
Post #1182901
Posted Thursday, September 29, 2011 8:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 8, 2013 10:09 PM
Points: 4, Visits: 25
Hi

Could you reply me quick

this sp not working for me
any idea about it
it not display any error but also not creating pdf file for me
please help me it's urgent

Thanks in advance
Post #1183504
Posted Thursday, September 29, 2011 8:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 8, 2013 10:09 PM
Points: 4, Visits: 25
have you got any solution for this i have same prob like you not solved yet
thanks in advance
Post #1183509
Posted Tuesday, December 13, 2011 4:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 23, 2011 1:36 AM
Points: 1, Visits: 2
I run SQL2PDF it is running fine but pdf file is not getting created...
Post #1220751
Posted Thursday, April 5, 2012 6:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 5, 2012 6:04 AM
Points: 1, Visits: 2
Hi,

I am able to run the SQL2PDF procedure, but .pdf is not creating... someone pls. help...
thanks in advance

Thanks
Sandeep
Post #1278722
Posted Friday, May 18, 2012 3:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 21, 2012 3:20 PM
Points: 2, Visits: 2
I want to create a file with at least 100.000 rows but there is a problem, I get error 104 when open the pdf file created...please any suggestions are welcome...??
Post #1302365
Posted Friday, February 8, 2013 11:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 7:15 AM
Points: 5, Visits: 145
Reviving a somewhat zombified thread here, but....

Has anyone figured out how, using this procedure, to put a graphic image into the created pdf?
Post #1417838
« Prev Topic | Next Topic »

Add to briefcase «««910111213»»»

Permissions Expand / Collapse