R
rfuscjr via AccessMonster.com
In general we create reports by running queries in Access, make some tables,
open Excel sheets linked to those tables, refresh and write to a designated
spot on a server that is attached to a web page. The user opens the webpage
and clicks the hyperlink for the report they want and it pops open in Excel.
I have been given a number of MsAccess reports that 1) must remain in
MsAccess format and 2) should be delivered to the web in smilar fashion. So,
we should be able to export the Ms Access report to a spot on a server where
it can get picked up by a web user.
These MsAccess reports have graphs. I did a search and found here that I am
not going to have any luck exporting my Access report that contains a graph
as an RTF file for MsWord...you loose the graph. Besides, it appears that
the user is then prompted as to which program to use to open the rtf file and
we do not want them to have to make any decisions...just have the report pop
open when they click the hyperlink on the web page. Tha may even be my first
problem....not sure.
I can save the report as a snap shot. The trouble is I do not know if
snapshot viewer is available network wide on our network. Is it typicaly?
If the user clicked a .snp file, would automatically open or would they be
prompted as to which product to open it with? Thoughts....?
A third way I thought of would be to convert it to an Adobe file. The only
way I know to do this is to set up an adobe *printer* and print the report to
it. When that is done, somehow the output is converted to Adobe format.
The trouble here is it appears as though the adobe *printer* is hardcoded (so
to speak) to write to a particular folder by default. My reports need tp go
to various folders. I do not want to have all the reports written /
converted to adobe in a particular location only to have to manually move
them around.
Am I missing anything...any ideas? Is the snp file the best way to go...is
there another method for adobe conversion.....
open Excel sheets linked to those tables, refresh and write to a designated
spot on a server that is attached to a web page. The user opens the webpage
and clicks the hyperlink for the report they want and it pops open in Excel.
I have been given a number of MsAccess reports that 1) must remain in
MsAccess format and 2) should be delivered to the web in smilar fashion. So,
we should be able to export the Ms Access report to a spot on a server where
it can get picked up by a web user.
These MsAccess reports have graphs. I did a search and found here that I am
not going to have any luck exporting my Access report that contains a graph
as an RTF file for MsWord...you loose the graph. Besides, it appears that
the user is then prompted as to which program to use to open the rtf file and
we do not want them to have to make any decisions...just have the report pop
open when they click the hyperlink on the web page. Tha may even be my first
problem....not sure.
I can save the report as a snap shot. The trouble is I do not know if
snapshot viewer is available network wide on our network. Is it typicaly?
If the user clicked a .snp file, would automatically open or would they be
prompted as to which product to open it with? Thoughts....?
A third way I thought of would be to convert it to an Adobe file. The only
way I know to do this is to set up an adobe *printer* and print the report to
it. When that is done, somehow the output is converted to Adobe format.
The trouble here is it appears as though the adobe *printer* is hardcoded (so
to speak) to write to a particular folder by default. My reports need tp go
to various folders. I do not want to have all the reports written /
converted to adobe in a particular location only to have to manually move
them around.
Am I missing anything...any ideas? Is the snp file the best way to go...is
there another method for adobe conversion.....