creating Powerpoint presentations (etc) from SS 2000 T-SQL

I have a need to create Powerpoint presentations from T-SQL queries (SS
2000). Contents will involve sharts and tables. Now, I can think of some
crude hacks to accomplish this but I'm looking for the most elegant method
that doesn't require an intranet server (not a possibility at the moment).
So my questions are:
1) What is the best way to do this?
2) How do I make xp_cmdshell transactions run on the client instead of the
server?
Thanks,
Randall ArnoldOops, "sharts" should be "charts".
"Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
news:3nUmg.32998$_k2.579673@.news2.nokia.com...
>I have a need to create Powerpoint presentations from T-SQL queries (SS
>2000). Contents will involve sharts and tables. Now, I can think of some
>crude hacks to accomplish this but I'm looking for the most elegant method
>that doesn't require an intranet server (not a possibility at the moment).
>So my questions are:
> 1) What is the best way to do this?
> 2) How do I make xp_cmdshell transactions run on the client instead of the
> server?
> Thanks,
> Randall Arnold
>|||I assumed that you were creating 'charts' for attorneys...
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
news:wFUmg.32999$_k2.579608@.news2.nokia.com...
> Oops, "sharts" should be "charts".
> "Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
> news:3nUmg.32998$_k2.579673@.news2.nokia.com...
>|||Shart is something completely different in this neck of the woods. ;)
Arnie Rowland wrote:
> I assumed that you were creating 'charts' for attorneys...
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
> news:wFUmg.32999$_k2.579608@.news2.nokia.com...|||Yeah, yeah, yuck it up : P.
But-- no suggestions?
: (
Randall
"PSPDBA" <DissendiumDBA@.gmail.com> wrote in message
news:1151083679.040836.66940@.i40g2000cwc.googlegroups.com...
> Shart is something completely different in this neck of the woods. ;)
> Arnie Rowland wrote:
>|||Why would you not consider SQL Reporting Services?
With SRS you have extensive formatting control over the presentation output.
I assume you mean that you desire to have 'sharts' (couldn't resist) and
tables reflective of data -not DDL or DML.
With SRS the learning curve is relatively short for relatively simple
presentations.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
news:CkZmg.33001$_k2.579688@.news2.nokia.com...
> Yeah, yeah, yuck it up : P.
> But-- no suggestions?
> : (
> Randall
> "PSPDBA" <DissendiumDBA@.gmail.com> wrote in message
> news:1151083679.040836.66940@.i40g2000cwc.googlegroups.com...
>|||I *have* considered it. I just can't get our IT guys on the ball to respond
to requests about it (services not currently running). In the meantime,
I've got this growing daily demand for reports in a company that lives on
Powerpoint presentations...
Randall Arnold
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23WOmwBxlGHA.4772@.TK2MSFTNGP04.phx.gbl...
> Why would you not consider SQL Reporting Services?
> With SRS you have extensive formatting control over the presentation
> output. I assume you mean that you desire to have 'sharts' (couldn't
> resist) and tables reflective of data -not DDL or DML.
> With SRS the learning curve is relatively short for relatively simple
> presentations.
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
> news:CkZmg.33001$_k2.579688@.news2.nokia.com...
>|||It would seem that if the company 'lives on Powerpoint presentation" then
you would be able to gain significant management support for getting SSRS
installed.
Go around the "IT guys" and directly engage management in asking for the
support tools they need to get their work done.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
news:wFaog.32765$Nb2.602046@.news1.nokia.com...
>I *have* considered it. I just can't get our IT guys on the ball to
>respond to requests about it (services not currently running). In the
>meantime, I've got this growing daily demand for reports in a company that
>lives on Powerpoint presentations...
> Randall Arnold
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23WOmwBxlGHA.4772@.TK2MSFTNGP04.phx.gbl...
>|||The problem is that this is an immediate need yet this facility may not be
open much longer. So I'm in a catch-22 where purchases are concerned. I've
been stuck with doing things with free or cheap tools and I'm reaching the
limits of what I can do under that constraint...
Randall
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uflvIffmGHA.3844@.TK2MSFTNGP04.phx.gbl...
> It would seem that if the company 'lives on Powerpoint presentation" then
> you would be able to gain significant management support for getting SSRS
> installed.
> Go around the "IT guys" and directly engage management in asking for the
> support tools they need to get their work done.
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
> news:wFaog.32765$Nb2.602046@.news1.nokia.com...
>|||A short term solution would be to use Microsoft Excel as a front end
for your charts, and then use OLE to embed the spreadsheet in the
PowerPoint presentation. Not the most ideal scenario, but might get
you through.
If it were me, based on what you describe, I'd work on the Excel
solution AFTER I blew the dust off my resume. :)
Randall Arnold wrote:
> The problem is that this is an immediate need yet this facility may not be
> open much longer. So I'm in a catch-22 where purchases are concerned. I'
ve
> been stuck with doing things with free or cheap tools and I'm reaching the
> limits of what I can do under that constraint...
> Randall
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:uflvIffmGHA.3844@.TK2MSFTNGP04.phx.gbl...