Publishing reports on the web

[neileg]

I have already posted this problem and thought I had an answer, but I haven't.

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.

Thanks for all the help so far. I thought my answer was to use a snapshot, and indeed this would be OK, but reading a snap shot file requires having the viewer. I know this is free to download, but readers will need to do this.

Any ideas how I can convert my report to html without too much pain?

 

[IMO]

Is the conditional formatting still there if you don't use Word but just output to html?

DoCmd.OutputTo acReport, "YourReport", "HTML(*.html)", "", True, ""

 

[neileg]

Thanks, IMO. The trouble is that exporting to html like this works reasonably well for a tabular report, but anything else gets screwed up, bigtime!

 

[IMO]

I see what you mean. Just another idea, What about saving it as a .PDF for your website?

IMO

 

[IMO]

Maybe this Link could help.

IMO

 

[neileg]

Thanks again, IMO, but not the right thing. This product produces live reports based on user supplied parameters. You need to be running IIS on your web server, which is a no-no for us. I just want to extract some data from my databse and publish it as a web page. I may have to hand code this in html but I've dozens, if not hundreds to do.

 

[IMO]

I may have to hand code this in html but I've dozens, if not hundreds to do.

Not much fun

If I come across something I'll let you know

IMO

 

[neileg]

What have decided to do;
1) I have created a merge document in WOrd that draws its data from my Access query
2) I hand format where I would have used conditional formatting
3) I save the word doc as a web page

This works and is fairly easy, but it illustrates how Office's 'integration' is a bit of a sham!

Thanks for your interest IMO.

 

[jon98548]

This viewer thing has me baffled. I thought the snapshot viewer was contained within the SNP file. Or is it in Access and everyone I send a snapshot to has Access? Do the people viewing your report have Access installed? Not questioning you, Neil, I just thought I understood the snapshot viewer better than that. It's a shame to have to hand format all that.

 

[neileg]

Jon

The viewer is available as a freedownload from MS but is installed as part of Access 2000 and up (maybe a different version for A97 too). This had me fooled for a while, too.