ReportML

[Ed]

Under Access 2002 there is a ReportML format that
supposedly allows you to output an Access Report such
that it is viewable (the same as if you had used print
preview in access) on a client PC without them having
access installed.

Has anyone gotten this to work? I saw some documentation
mentioning that you had to use the ExportXML via
vbscript, but I have not been able to get this to work.

My goal is to be able to distribute reports via web.

 

[Mark Andrews]

As far as I know the only usable formats are pdf and snaphot for most
reports.
Excel will work ok if you want to just show tabular data with maybe some
grouping. So in short PDF is the best format for distributing reports over
the web.

In the upcoming Access 2003 I believe the XML export might be good enough
that
with some work and transformation it will be able to make XML readable by
Microsoft
Word (that actually maintains all the formatting). I saw a demo at an Access
conference.
I haven't heard of anyone using XML with Access 2002?

Until then use PDF. Checkout our products they might help you out. We make
two products
designed to help with Access report delivery over the web. A simple batch
reporting product and
a dynamic reporting product that works with ASP and a simple COM interface
or ASP.NET.

Feel free to send me an email I looked at probably every product available
that does reporting
over the web. High end and low end.

HTH,
Mark
RPT Software
http://www.rptsoftware.com