Author |
Topic |
drewgeezmoe
Starting Member
22 Posts |
Posted - 2007-02-06 : 03:29:28
|
is there a specific command that can do this using the query analyzer?Please help me on this.Thank you.Your future is made by the things you are presently doing. |
|
Kristen
Test
22859 Posts |
Posted - 2007-02-06 : 03:47:18
|
"is there a specific command that can do this using the query analyzer?"No.There are various 3rd party tools that can make a PDF file via "print" - they install as a pseudo print device, and anything you can print can therefore be sent to a PDF file instead.I use one called pdfFactory, which I'm very happy with, but there are plenty of othersKristen |
|
|
drewgeezmoe
Starting Member
22 Posts |
Posted - 2007-02-06 : 04:03:09
|
ok thank you. I was just wondering if that was possible, because it needs to be coded in vb.net and it would be easier if i can export the files directly from sql.Hope you could give me an alternative for the program that we are developing.Your future is made by the things you are presently doing. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
drewgeezmoe
Starting Member
22 Posts |
Posted - 2007-02-06 : 18:44:27
|
Peso thanks a lot. I will just try the code.Your future is made by the things you are presently doing. |
|
|
drewgeezmoe
Starting Member
22 Posts |
Posted - 2007-02-07 : 00:31:14
|
On the link given by peso.. In the stored procedure there is a word "code", does this mean that i have to put my codes here.Here is an example of what i mean: INSERT INTO #pdf (code) VALUES ('4' + @beg)Your future is made by the things you are presently doing. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-07 : 01:39:02
|
No, code is the column name in the temporary table created for the later output for pdf code.Peter LarssonHelsingborg, Sweden |
|
|
drewgeezmoe
Starting Member
22 Posts |
Posted - 2007-02-07 : 01:42:37
|
Thanks. Its only now I have encountered a stored procedure as long as this.Thank you very much peso, you have been very helpful.Your future is made by the things you are presently doing. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-07 : 02:55:00
|
it's not so big. i hear there are procs in beasts like SAP that are 20000 lines. www.elsasoft.org |
|
|
drewgeezmoe
Starting Member
22 Posts |
Posted - 2007-02-07 : 03:00:11
|
whew thats long... well my boss just asked me to research on this topic,to avoid using crystal reports in vb.net to convert sql to pdf.i dont fully understand this stored procedure yet, im still analyzing it before i go and discuss it with them.__________________________________________________Your future is made by the things you are presently doing. |
|
|
csteve274
Starting Member
3 Posts |
Posted - 2012-02-10 : 07:37:28
|
Hi,You can download the required tool which deals with pdf. Check for many more softwares and I hope this might help you.unspammedThanks |
|
|
|