| Author |
 Topic  |
|
|
dayve
Forum Moderator
USA
5820 Posts |
 Posted - 29 September 2003 : 22:56:56
|
| What are the best options for being able to take an active server page and exporting the page to RTF, PDF and WORD? I read a lot of TIDS at Microsofts website but having to use all the control codes is a bit much to handle so I am willing to check out recommended components or other options... TIA. |
 |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 30 September 2003 : 05:07:06
|
Have you considered using ActivePdf?quote:
Originally posted by dayve
What are the best options for being able to take an active server page and exporting the page to RTF, PDF and WORD? I read a lot of TIDS at Microsofts website but having to use all the control codes is a bit much to handle so I am willing to check out recommended components or other options... TIA.
We use it at work, and it seems to work well... 
|
Cheers,
David Greening |
 |
|
|
gelliott
Junior Member
USA
268 Posts |
Posted - 30 September 2003 : 12:32:57
|
I have recently researched all of this -- PDF - I can't find a way to do this without having a component installed on the system or using a remote server to do the conversion for me. I wasn't impressed with the only free remote service I found.
- XLS - I knew thatTableEditor offered Excel dumps which worked purely in ASP, so I looked at their codes. Basically, all they do is dump an html table into an ascii file and give it an .xls extension. So I wrote my own streamlined routine for XLS dumps. Excel will open and auto-convert the (ascii/html) .xls file on the fly. I was not able to get Excel to auto-convert CSV-formatted .xls files correctly (numbers and text values and quotes mishandled)
- DOC/RTF - while I have not yet implemented this, I have it half written. After my success with the XLS conversion, I had intended to do the same for Word. I would write ascii RTF codes to a .DOC file, and Word will auto-convert upon opening as if it were a true DOC file. The format codes for RTF are easy enough to find, and I had intended to use this for form-letters as well (I will make an include file with strings of formatted letters already prepared - I use the Replace function to pull out my placeholders and insert my db merge data, and out pops the word file...) For reports, I will use a similar approach, using pre-built headers and footers and inserting the formatting around the data on the fly as I read the data from the db).
Hope this helps... |
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized. |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 30 September 2003 : 14:06:34
|
I no longer need the PDF option, although it would be nice someday.
XLS was super easy to do since HTML tables convert nicely to Spreadsheet Formats
DOC/RTF - I'm too lazy to do all the control codes, not worth the time and effort right now.
Thanks anyway, I was just putting too much time into something that is really not that big a deal for the project I am working on.
On a side note, I decided to provide a Crystal Web Report through Crystal Enterprise so that worked out nicely, but we don't want to use this for public usage. |
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 30 September 2003 : 20:48:55
|
I have an article somewhere explaining how to create very simple PDF files using a SQL Server SP kinda cool actually, lemme see if I can dig it up
http://www.sqlservercentral.com/columnists/mivica/creatingapdffromastoredprocedure.asp
Not much use to you if your not needing PDF's now, but an interesting read anyway. You'll need to be a sqlservercentral member to read it, but thats just a matter of registering if you aren't already anyway. |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 30 September 2003 20:52:34 |
|
|
| |
Topic |
|
Topic Locked
