Hi did you get any reply for this...even i have the same problem. SP running successfully but output file is not generating :crying:

I have created the procedure sql2pdf using code which you have provided. It ran successfully by i did not find the pdf generated in my C:/root directory. Can somebody please...