|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
creating Powerpoint presentations (etc) from SS 2000 T-SQLI 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 Oops, "sharts" should be "charts".
Show quote "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...
-- Show quoteArnie 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... >>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 >> > > Shart is something completely different in this neck of the woods. ;)
Arnie Rowland wrote: Show quote > 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... > >>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 > >> > > > > Yeah, yeah, yuck it up : P.
But-- no suggestions??? : ( RandallShow quote "PSPDBA" <Dissendium***@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: >> 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... >> >>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 >> >> >> > >> > > 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. -- Show quoteArnie 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" <Dissendium***@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: >>> 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... >>> >>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 *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 Show quote "Arnie Rowland" <ar***@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... >> Yeah, yeah, yuck it up : P. >> >> But-- no suggestions??? >> >> : ( >> >> Randall >> >> "PSPDBA" <Dissendium***@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: >>>> 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... >>>> >>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 >>>> >> >>>> > >>>> > >>> >> >> > > 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. -- Show quoteArnie 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" <ar***@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... >>> Yeah, yeah, yuck it up : P. >>> >>> But-- no suggestions??? >>> >>> : ( >>> >>> Randall >>> >>> "PSPDBA" <Dissendium***@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: >>>>> 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... >>>>> >>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 >>>>> >> >>>>> > >>>>> > >>>> >>> >>> >> >> > > 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 Show quote "Arnie Rowland" <ar***@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... >>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" <ar***@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... >>>> Yeah, yeah, yuck it up : P. >>>> >>>> But-- no suggestions??? >>>> >>>> : ( >>>> >>>> Randall >>>> >>>> "PSPDBA" <Dissendium***@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: >>>>>> 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... >>>>>> >>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 >>>>>> >> >>>>>> > >>>>>> > >>>>> >>>> >>>> >>> >>> >> >> > > 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: Show quote > 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" <ar***@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... > >>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" <ar***@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... > >>>> Yeah, yeah, yuck it up : P. > >>>> > >>>> But-- no suggestions??? > >>>> > >>>> : ( > >>>> > >>>> Randall > >>>> > >>>> "PSPDBA" <Dissendium***@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: > >>>>>> 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... > >>>>>> >>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 > >>>>>> >> > >>>>>> > > >>>>>> > > >>>>> > >>>> > >>>> > >>> > >>> > >> > >> > > > > Yeah, I've been trying that but that solution has problems of its own.
Excel will occasionally crash while updating query results and corrupt the spreadsheet. Haven't found a rhyme or reason behind the crashes; they're seemingly random. And when Excel crashes, so does the Powerpoint host. And the resume thing is covered. We've been told for some time the future here is grim, so no surprises. I'm just trying to ride it out as best I can and keep updating that dust-free resume. ; ) Randall Show quote "Stu" <stuart.ainswo***@gmail.com> wrote in message news:1151522464.368571.7620@p79g2000cwp.googlegroups.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" <ar***@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... >> >>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" <ar***@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... >> >>>> Yeah, yeah, yuck it up : P. >> >>>> >> >>>> But-- no suggestions??? >> >>>> >> >>>> : ( >> >>>> >> >>>> Randall >> >>>> >> >>>> "PSPDBA" <Dissendium***@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: >> >>>>>> 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... >> >>>>>> >>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 >> >>>>>> >> >> >>>>>> > >> >>>>>> > >> >>>>> >> >>>> >> >>>> >> >>> >> >>> >> >> >> >> >> > >> > > SSRS is a 'free or cheap' tool.
-- Show quoteArnie 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:muAog.33257$_k2.585512@news2.nokia.com... > 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" <ar***@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... >>>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" <ar***@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... >>>>> Yeah, yeah, yuck it up : P. >>>>> >>>>> But-- no suggestions??? >>>>> >>>>> : ( >>>>> >>>>> Randall >>>>> >>>>> "PSPDBA" <Dissendium***@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: >>>>>>> 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... >>>>>>> >>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 haven't even found a way to acquire it. I have scoured Microsoft's site
for info and can't find a single thing that tells me how to acquire anything but the trial for SSRS-- where 2000 is concerned. Any info would be appreciated. Randall Show quote "Arnie Rowland" <ar***@1568.com> wrote in message news:eRvlzqumGHA.2316@TK2MSFTNGP04.phx.gbl... > SSRS is a 'free or cheap' tool. > > -- > 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:muAog.33257$_k2.585512@news2.nokia.com... >> 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" <ar***@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... >>>>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" <ar***@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... >>>>>> Yeah, yeah, yuck it up : P. >>>>>> >>>>>> But-- no suggestions??? >>>>>> >>>>>> : ( >>>>>> >>>>>> Randall >>>>>> >>>>>> "PSPDBA" <Dissendium***@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: >>>>>>>> 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... >>>>>>>> >>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 >>>>>>>> >> >>>>>>>> > >>>>>>>> > >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > Trial version is 120 days -how long did you say this needed to last?
-- Show quoteArnie 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:U7Dog.33264$_k2.585586@news2.nokia.com... >I haven't even found a way to acquire it. I have scoured Microsoft's site >for info and can't find a single thing that tells me how to acquire >anything but the trial for SSRS-- where 2000 is concerned. Any info would >be appreciated. > > Randall > > "Arnie Rowland" <ar***@1568.com> wrote in message > news:eRvlzqumGHA.2316@TK2MSFTNGP04.phx.gbl... >> SSRS is a 'free or cheap' tool. >> >> -- >> 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:muAog.33257$_k2.585512@news2.nokia.com... >>> 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" <ar***@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... >>>>>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" <ar***@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... >>>>>>> Yeah, yeah, yuck it up : P. >>>>>>> >>>>>>> But-- no suggestions??? >>>>>>> >>>>>>> : ( >>>>>>> >>>>>>> Randall >>>>>>> >>>>>>> "PSPDBA" <Dissendium***@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: >>>>>>>>> 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... >>>>>>>>> >>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 >>>>>>>>> >> >>>>>>>>> > >>>>>>>>> > >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > Only $7.50 for Reporting Services CD. (Not the eval).
http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx -- Show quoteArnie Rowland, YACE* "To be successful, your heart must accompany your knowledge." *Yet Another Certification Exam "Arnie Rowland" <ar***@1568.com> wrote in message news:%23hXx36wmGHA.4700@TK2MSFTNGP02.phx.gbl... > Trial version is 120 days -how long did you say this needed to last? > > > > -- > 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:U7Dog.33264$_k2.585586@news2.nokia.com... >>I haven't even found a way to acquire it. I have scoured Microsoft's site >>for info and can't find a single thing that tells me how to acquire >>anything but the trial for SSRS-- where 2000 is concerned. Any info would >>be appreciated. >> >> Randall >> >> "Arnie Rowland" <ar***@1568.com> wrote in message >> news:eRvlzqumGHA.2316@TK2MSFTNGP04.phx.gbl... >>> SSRS is a 'free or cheap' tool. >>> >>> -- >>> 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:muAog.33257$_k2.585512@news2.nokia.com... >>>> 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" <ar***@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... >>>>>>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" <ar***@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... >>>>>>>> Yeah, yeah, yuck it up : P. >>>>>>>> >>>>>>>> But-- no suggestions??? >>>>>>>> >>>>>>>> : ( >>>>>>>> >>>>>>>> Randall >>>>>>>> >>>>>>>> "PSPDBA" <Dissendium***@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: >>>>>>>>>> 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... >>>>>>>>>> >>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 >>>>>>>>>> >> >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > BEAUTIFUL!!!!
Thanks much Arnie! I was just unable to find that. Randall Show quote "Arnie Rowland" <ar***@1568.com> wrote in message news:eaj19V0mGHA.1204@TK2MSFTNGP04.phx.gbl... > Only $7.50 for Reporting Services CD. (Not the eval). > > http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx > > > -- > Arnie Rowland, YACE* > "To be successful, your heart must accompany your knowledge." > > *Yet Another Certification Exam > > > "Arnie Rowland" <ar***@1568.com> wrote in message > news:%23hXx36wmGHA.4700@TK2MSFTNGP02.phx.gbl... >> Trial version is 120 days -how long did you say this needed to last? >> >> >> >> -- >> 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:U7Dog.33264$_k2.585586@news2.nokia.com... >>>I haven't even found a way to acquire it. I have scoured Microsoft's >>>site for info and can't find a single thing that tells me how to acquire >>>anything but the trial for SSRS-- where 2000 is concerned. Any info >>>would be appreciated. >>> >>> Randall >>> >>> "Arnie Rowland" <ar***@1568.com> wrote in message >>> news:eRvlzqumGHA.2316@TK2MSFTNGP04.phx.gbl... >>>> SSRS is a 'free or cheap' tool. >>>> >>>> -- >>>> 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:muAog.33257$_k2.585512@news2.nokia.com... >>>>> 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" <ar***@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... >>>>>>>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" <ar***@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... >>>>>>>>> Yeah, yeah, yuck it up : P. >>>>>>>>> >>>>>>>>> But-- no suggestions??? >>>>>>>>> >>>>>>>>> : ( >>>>>>>>> >>>>>>>>> Randall >>>>>>>>> >>>>>>>>> "PSPDBA" <Dissendium***@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: >>>>>>>>>>> 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... >>>>>>>>>>> >>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 >>>>>>>>>>> >> >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > Probably 6 months.
Randall Show quote "Arnie Rowland" <ar***@1568.com> wrote in message news:%23hXx36wmGHA.4700@TK2MSFTNGP02.phx.gbl... > Trial version is 120 days -how long did you say this needed to last? > > > > -- > 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:U7Dog.33264$_k2.585586@news2.nokia.com... >>I haven't even found a way to acquire it. I have scoured Microsoft's site >>for info and can't find a single thing that tells me how to acquire >>anything but the trial for SSRS-- where 2000 is concerned. Any info would >>be appreciated. >> >> Randall >> >> "Arnie Rowland" <ar***@1568.com> wrote in message >> news:eRvlzqumGHA.2316@TK2MSFTNGP04.phx.gbl... >>> SSRS is a 'free or cheap' tool. >>> >>> -- >>> 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:muAog.33257$_k2.585512@news2.nokia.com... >>>> 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" <ar***@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... >>>>>>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" <ar***@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... >>>>>>>> Yeah, yeah, yuck it up : P. >>>>>>>> >>>>>>>> But-- no suggestions??? >>>>>>>> >>>>>>>> : ( >>>>>>>> >>>>>>>> Randall >>>>>>>> >>>>>>>> "PSPDBA" <Dissendium***@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: >>>>>>>>>> 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... >>>>>>>>>> >>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 >>>>>>>>>> >> >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics