How do I put Access 2000 reports onto a web site

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

MD
Sat Aug 16 05:55:39 CDT 2003

Hi M.

Sorry but it is not possible
--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
----------------------------------------------------------------------------
--------------------
If you think I'm doing a good job, let MS know at mvpga@microsoft.com

"M Skabialka" <Remove NOSPAM from reply address> wrote in message
news:e27fwq0YDHA.2284@TK2MSFTNGP12.phx.gbl...
> 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
>
>
>

Sriram
Sat Aug 16 08:56:24 CDT 2003

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 Skabialka" <Remove NOSPAM from reply address> wrote in message
news:e27fwq0YDHA.2284@TK2MSFTNGP12.phx.gbl...
> 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.

Mark
Sun Aug 17 16:43:45 CDT 2003

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 Skabialka" <Remove NOSPAM from reply address> wrote in message
news:e27fwq0YDHA.2284@TK2MSFTNGP12.phx.gbl...
> 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
>
>
>

MD
Mon Aug 18 06:28:25 CDT 2003

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?

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
----------------------------------------------------------------------------
--------------------
If you think I'm doing a good job, let MS know at mvpga@microsoft.com

"Mark Andrews" <mandrews@rptsoftware.com> wrote in message
news:OOm7giQZDHA.2404@TK2MSFTNGP10.phx.gbl...
> 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 Skabialka" <Remove NOSPAM from reply address> wrote in message
> news:e27fwq0YDHA.2284@TK2MSFTNGP12.phx.gbl...
> > 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
> >
> >
> >
>
>

M
Mon Aug 18 10:24:44 CDT 2003

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

"Sriram N A" <sriram.na@in.bosch.com> wrote in message
news:bhld74$1i4$1@ns2.fe.internet.bosch.com...
> 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 Skabialka" <Remove NOSPAM from reply address> wrote in message
> news:e27fwq0YDHA.2284@TK2MSFTNGP12.phx.gbl...
> > 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.
>
>

M
Mon Aug 18 13:43:40 CDT 2003

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

"Mark Andrews" <mandrews@rptsoftware.com> wrote in message
news:OOm7giQZDHA.2404@TK2MSFTNGP10.phx.gbl...
> 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 Skabialka" <Remove NOSPAM from reply address> wrote in message
> news:e27fwq0YDHA.2284@TK2MSFTNGP12.phx.gbl...
> > 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
> >
> >
> >
>
>

Rick
Mon Aug 18 19:30:46 CDT 2003

"M Skabialka" <Remove NOSPAM from reply address> wrote in message
news:u2FTazZZDHA.388@TK2MSFTNGP10.phx.gbl...
> 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
Tue Aug 19 07:27:10 CDT 2003

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

"Rick Brandt" <rvtjbrandt@sbcglobal.net> wrote in message
news:bhrr3k$2hf29$1@ID-98015.news.uni-berlin.de...
> "M Skabialka" <Remove NOSPAM from reply address> wrote in message
> news:u2FTazZZDHA.388@TK2MSFTNGP10.phx.gbl...
> > 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.
>
>

Mark
Mon Aug 25 12:27:21 CDT 2003

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

"MD WebsUnlimited.com" <none@none.com> wrote in message
news:eazlYvXZDHA.2464@TK2MSFTNGP09.phx.gbl...
> 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?
>
> --
> Mike -- FrontPage MVP '97-'02
> http://www.websunlimited.com
> FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
> --------------------------------------------------------------------------
--
> --------------------
> If you think I'm doing a good job, let MS know at mvpga@microsoft.com
>
> "Mark Andrews" <mandrews@rptsoftware.com> wrote in message
> news:OOm7giQZDHA.2404@TK2MSFTNGP10.phx.gbl...
> > 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 Skabialka" <Remove NOSPAM from reply address> wrote in message
> > news:e27fwq0YDHA.2284@TK2MSFTNGP12.phx.gbl...
> > > 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
> > >
> > >
> > >
> >
> >
>
>

pchq45
Thu Aug 28 23:48:45 CDT 2003

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

"M Skabialka" <Remove NOSPAM from reply address> wrote in message news:<e27fwq0YDHA.2284@TK2MSFTNGP12.phx.gbl>...
> 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