Powerpoint-Reporting with SQL2005 Reporting Services

Hi All,
the SQL Server Business Intelligence Development Studio is not equipped with
an option to output powerpoint presentations.
we have to migrate an legacy application which has been coded in access-vba.
the vba code uses data within an MSSQL Database and a powerpoint template
(.pot) and the output is a powerpoint presentation with lots of graphs and
charts in it.
we are thinking about porting the vba code into a code module within the SQL
Server Business Intelligence Development Studio.
does anybody know if it would technically be possible to use plain vba code
(ported from the access application) within SQL Server Business Intelligence
Development Studio to fill a powerpoint template and thus to generate a
whole powerpoint presentation? (provided that this whole vba-magic is
working within the access-application)
if the above stated idea is complete rubbish then please let me know. if it
might be possible to use SQL Server Business Intelligence Development Studio
to achieve this aim, please let me also know which steps this should
involve.
thanks a lot in advance!
best regards, janYou'd need to convert from VBA to VB.net.. I would really reccomend
writing some of the core logic in DLLs or something; I dont think that
putting hundreds of pages in code inside of a report would make a lot
of sense.. more importantly; you don't want 100 different copies of
this code; that would make maintenance difficult.
Then you would just digest this code inside the report properties
section; there is a 'code' window.
Why do you use powerpoint; anyways?
by chance do you work for a large auction web company in the Bay Area?
LoL?
We use OfficeWriter by SoftArtisans.. If I were you; I would push them
HARD to see if they can come up with a solution and then stand on the
shoulders of giants.
I just think that exporting to PPT might be a major pain.
Now.. for example.. if you wanted to talk about something that might be
a LOT LOT LOT easier to deal with?
you probably could just export the reports to XML format; and then
maybe make an XSLT that would 'translate' the XML out of SSRS into the
XML for PPT 07 or even 03.
Hope that helps; SSRS rocks!
-Aaron
Jan wrote:
> Hi All,
> the SQL Server Business Intelligence Development Studio is not equipped with
> an option to output powerpoint presentations.
> we have to migrate an legacy application which has been coded in access-vba.
> the vba code uses data within an MSSQL Database and a powerpoint template
> (.pot) and the output is a powerpoint presentation with lots of graphs and
> charts in it.
> we are thinking about porting the vba code into a code module within the SQL
> Server Business Intelligence Development Studio.
> does anybody know if it would technically be possible to use plain vba code
> (ported from the access application) within SQL Server Business Intelligence
> Development Studio to fill a powerpoint template and thus to generate a
> whole powerpoint presentation? (provided that this whole vba-magic is
> working within the access-application)
> if the above stated idea is complete rubbish then please let me know. if it
> might be possible to use SQL Server Business Intelligence Development Studio
> to achieve this aim, please let me also know which steps this should
> involve.
> thanks a lot in advance!
> best regards, jansql

Powerpoint Integration

Is it planed to save data's on powerpoint file?

or better, to get data on a powerpoint template?

Thanks for answer

You can read or write directly PowerPoint file (or PowerPoint template) if this file is in XML style.

Office 2007 offer XML file as a standard, and you can save office 2003 files as XML files.

If you want to have a test, you need to write an Office 2003 Document (with Microsoft Word) and save as XML file (for example c:\TEST.XML). After you save this file you can open c:\TEST.XML file with NOTEPAD.EXE (or other text editor), and you can cange the text from that file (without affecting structure). You need to reopen c:\test.xml with Microsoft Office Word 2003 and you will see what it happend.

PowerPoint format possible?

Hello,

we plan to use Reporting Services in the company in the near future. However, management prefers power point reports, a format which reporting services does not support (please correct me if I am wrong here).

Is there a third party extenstion tool for RS available which can produce PPT reports?

Best regards,

Michael Fuchs

Hello,

I'm not aware of any third-party PowerPoint renderer.

Can you explain your scenario that calls for PowerPoint rendering? Any insight you can offer will help to justify the possibility of providing this functionality in the future.

Thanks,
Chris

|||

Hello,

Management presents the reports in periodic meetings, currently pdf slides are used (these pdfs don't come from RS but from a self developed program), but this is not desired by management anymore, as pdf is not optimal for a presentation. What we need is nothing too fancy, just a slide with some formatting options (i.e. different templates) and the relevant charts and data presented on the slide.

I heard that ppt output is planned anyway in the next version of reporting services and that it already is in the testing stage. Is that just a rumor or can you confirm that?

Thanks,

Michael