MSAccessUser
Registered User.
- Local time
- Today, 14:12
- Joined
- Aug 17, 2005
- Messages
- 21
I've a query that gathers data from another db via ODBC. The query takes a fairly long amount of time to run. The query outputs a PivotChart. I want to save/export this PivotChart as HTML and load it up on a webpage.
I could probably do this by saving as a DataAccessPage but that would mean running the query at the time of accessing the website. So, I want to avoid this long delay by saving it as HTML.
I also want this HTML PivotChart to have the ability to "pivot" the categories by filtering/removing/adding categories that you typically do in a regular PivotChart.
The 'Save As' option does not have the HTML option. Exporting to HTML only exported the text data but not the PivotChart itself.
I'm very certain this can be done. I know this can be done because I had done it once but now can't remember. Can anyone help?
I could probably do this by saving as a DataAccessPage but that would mean running the query at the time of accessing the website. So, I want to avoid this long delay by saving it as HTML.
I also want this HTML PivotChart to have the ability to "pivot" the categories by filtering/removing/adding categories that you typically do in a regular PivotChart.
The 'Save As' option does not have the HTML option. Exporting to HTML only exported the text data but not the PivotChart itself.
I'm very certain this can be done. I know this can be done because I had done it once but now can't remember. Can anyone help?