Output report as HTML

[neileg]

I have a report based on a relatively simple query. This is formatted to fit on a single A4 ladscape page. I use conditional formatting to highlight some fields in the report. This all works fine.

I want to use some of these reports on our website. I don't want them to be interactive, just a simple snapshot on a single web page for each version of the report. How can I do this?

I have tried publishing the report to Word. I loose some of the formatting including the conditional formatting, the whole page is laid out using tabs and it's just a mess when I try and save as HTML.

I have thought about setting up a template in Word using a table, and doing a merge from my Access query. I could then save this as HTML. I don't know if I can apply conditional formatting in Word to get my highlighting.

Anyone got any ideas?

I'm using Access 2k and Word 2k.

 

[WayneRyan]

neileg,

I haven't seen any response, do any of these help?

http://databases.about.com/library/weekly/aa010801a.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acactOutputTo.asp

http://www.itc.virginia.edu/desktop/web/database/access.html

Wayne

 

[neileg]

Thanks Wayne.

I guess if all else fails, read the Help file!

I don't have my database to hand, but your pointers have to be the place to start!

 

[neileg]

No, Wayne, I can't get the format I want. I'm attaching a snapshot of the report.

As you can see, this is not too complex, but it's not like the tabular report that the export to html routines are geared towards.

Any ideas, anyone?

 

[stormin_norm]

I haven't messed with DAP yet...
But how 'bout lazy HTML--

Creat text fields with html tags in your report. Surround the data fields you wish to format.

for example: <B> Textfield </B>

and save the report to disk.

 

[neileg]

Thanks, norm. I understand your idea. Perhaps I'll have to learn a bit more about html than I know presently.

 

[jon98548]

Neil, what about snapshot view? I use this for some of my reports and it retains all formating. If you are using code, use acFormatSNP. A macro will give you the choice for Snapshot view also.

 

[neileg]

Thanks Jon, but that doesn't realy help to publish this on the web. I want people to see the report on the website.

It seems that there is a snapshot viewer free to download, but ideally I want the report just there without loading a viewer.

 

[jon98548]

It doesn't need an external viewer. It is a viewer of its own. Say you save a report in Snapshot view to your file that holds your web documents. When you link to this file it will open and show the report with your formatting. But, it wouldn't be viewed as a webpage, it would be like opening a document. Maybe getting away from what you were looking for.

 

[neileg]

No, Jon, that's closer to my ideal than I thought it was. I was going to select these reports from a list anyway, so opening as a document is not that much diferent from opening as a separate web page.

Thanks for your help, I'll pursue this.