How do I put Access 2000 reports onto a web site

M

M Skabialka

I have a database with complex reports (graphs, boxes and lines, subforms,
etc) which users want to run, convert into something usable on the web and
put on a web site.

They don't want the database on the web yet (later on this year - that's
another project I will need help with then) but they want to select
parameters, generate reports, then put the reports on the web site. Or even
better, have the web site look at the database, choose the paramteres, and
create the reports on the fly.

The critical part is that they HAVE to look the same as they do now.

How can this be done!
(Sorry about posts to multiple NGs, not sure who would have the info I
need!)

Thanks,
Mich
 
S

Sriram N A

I presume Access report snapshots (and the free snapshot viewer) can be used
for this? A static copy of the report would be available for visitors, and
authors can run and update the snapshot at any time...
 
M

Mark Andrews

We make a product to do exactly what you want. You can choose our most
popular product (Report Server) to create the reports on the fly where the
report comes back to the user as a PDF file (or any of the standard Access
exports SNP, RTF, XLS, RTF).

Our you can choose to use what I would call a batch processing method where
you crank out report files on a scheduled basis and push them to your web
site.
Our second product "Batch Reporting Module" supports this method.

You have total control on how the web site looks and just need a few lines
of
code to use either product.

Download a free eval and try it out,
Mark Andrews
RPT Software
http://www.rptsoftware.com
 
M

MD WebsUnlimited.com

Hi Mark,

With your product will you not need access to install a COM object? Most ISP
/ WPP will not allow foreign COM objects. Are there any ISP that offer your
component as a standard COM object?
 
M

M Skabialka

Snapshot reports remove all of the lines, boxes, graphs etc which make the
report so unique and useful. Users vetoed those a long time ago when we
were trying to export to PowerPoint slides. For these I use .emf files
based on each page of the report.

Thanks anyway
Mich
 
M

M Skabialka

I was unable to figure out how this will help me reproduce reports I have
already spent much time formatting. I don't want to select fields and
produce simple tables, I want to magically re-create these reports in some
kind of .html format.

Mich
 
R

Rick Brandt

M Skabialka said:
Snapshot reports remove all of the lines, boxes, graphs etc which make the
report so unique and useful. Users vetoed those a long time ago when we
were trying to export to PowerPoint slides. For these I use .emf files
based on each page of the report.

You're thinking of RTF. Snapshot format should retain all graphical formatting.
 
M

M Skabialka

Come to think of it, the shapshots were the ones that couldn't be resized to
fit PowerPoint or Word documents without distortions, which is why I am
using .emf (enhanced metafiles) which can be stretched and resized.

Mich
 
M

Mark Andrews

Mike,

Unfortunately yes our product does require both a COM object or some .NET
code
as well as a server-side EXE that needs to run on the server. We do not
have any ISPs
that run our product. Most of our customers use our products internally
within their organization
or host their own web server.

Sorry,
Mark
RPT Software
http://www.rptsoftware.com
 
P

Phillip Kennedy

Did you findou how to do this?? I am needing to do the
same thing but I can't get the graph object to work on a
DAP.....
 
M

M Skabialka

I am trying my best to save some money here, we only gett allocated so mch
for each project, and it each user needs the Report Server software it will
blow our budget way out of the water!

I'm still trying other code until I find something...
 
P

Peter Chong

If the report is simple, it is possible to use wizard tool from
exmlsoft
or you could load database to web environment using wizard tools to
generate anasp.net code too.
this wizard tools are available on www.exmlsoft.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top