Thoughts on data storage format for realtime PPT queries

  • Thread starter Thread starter Nick Weekes
  • Start date Start date
N

Nick Weekes

Dear all,

I am in the process of designing an app + PPT front end, which will
take data from a data file and render charts or reports on the fly.

Has anyone attempted this, and got any ideas for low footprint data
storage?

The data file has to be offline, so Im unable to use MDX/ODBC etc, so
id appreciate any ideas for efficient data storage...

Cheers.
 
If the data file is offline, how do you expect to create charts/reports
"on the fly?"

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Tushar,

I will be building the powerpoint objects programmatically either from scratch or from predefined templates, and dynamically feeding the data source...

Nick
 
I'm sure it makes sense to you and it probably makes sense to someone
else, but I'm still at a loss. Irrespective of how you create the
presentation, as long as the data file is offline, how do you expect to
dynamically feed the presentation with the data?

The best I can visualize is to merge the data into the presentation at
some point when you have access to the data file. After that point,
the presentation will be 'frozen' -- at least, until the next time the
data file is accessible.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Tushar

Its probably my wording, by offline I meant that ppt cannot requery the source database (which happens to be proprietary to my company), as the ppt application will be used 'on the road', so needs data stored in some format locally

My current idea is to use ADO to create recordsets from a local Access database (potential local storage format), and then populate the ppt range with the recordset data.

Does this sound feasable?
 
Sure.

If you have the data on the same computer as the PPT presentation,
check the PowerPoint / 'Interactive PivotTables' page of my web site.

You could probably also write some ADO code if you prefer that
approach.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Tushar

That is a very interesting article on your site. My PPT has to run on Office 2000 and XP, so I wonder if the Office Web components will work on 2000. Id be interested to hear how you would achieve my ultimate goal, of having a Pivot object feed a Chart object, with the ability to change the pivot options while in Slide Show mode (thus offering a data selection interface outside of the chart and pivot)?

Nick
 
Back
Top