BO report to Power Point

sdk development
1

Is there any way to get a report to export to PowerPoint and maintain all the header, footer, and chart information :?: Any add-ins or VBA code available?

mouse_m (BOB member since 2002-08-27)

2

You can copy your report using Edit - Copy All, then paste into Powerpoint, but that only pastes a picture of the report. That’s the only option I know of, but it may work fine for you.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Actually, the one time I was in Business Objects in Page View mode, I did a copy all and pasted it into Excel. That brought the headers and footers over. It wasn’t what I meant to do, but it might be what you’re looking for! :mrgreen:

Eileen King :us: (BOB member since 2002-07-10)

4

Wouldn’t a straight screenprint be all you need for a powerpoint presentation (hit PrintScreen in BOBJ, hit Paste (Ctrl-V) in PowerPoint) … or … are you trying to dynamically link the report as an OLE object?

Chris Pohl :us: (BOB member since 2002-06-18)

5

Actually I am looking for away to publish to power point and have the broadcaster send it out via outlook.

mouse_m (BOB member since 2002-08-27)

6

[Moved to VBA forum - you know it makes sense! - Nick]

Sounds like a job for VBA.
Unfortunately, I would have no idea how to do that with VBA. Perhaps someone else has some ideas.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

7

Was anyone successful in doing this? We have a request of this sort and would like to know if there was some success in the attempts discussed above. We have tried to save the report as a pdf and then port the pdf to power point but the report loses it’s resolution. Is there way to plug the report into a power point directly?

anand (BOB member since 2002-08-14)

8

I’m not 100% sure how to get the content into PPT via the full client SDK as I have never personally done it… but I think it should be possible. I have successfully loaded HTML formatted report content into PPT on the fly via the WebI SDK.

Basically all of the products in the MS Office Suite are capable of accepting HTML content and converting (sometimes not all that well, but converting it nonetheless…) into the host application’s proprietry format.

I think [and people please feel free to correct me if I’m wrong] you should be able to get this up and running quite easily… you will just need to create a VBA macro in your BO document that exports the report content to HTML in a temp directory somewhere. It will then be a case of creating an instance of Powerpoint, opening the temp HTML report export with the Powerpoint instance, and then saving the PPT file before sending it via CDO or MAPI.

Please note that if you are planning to execute these reports via BCA, you will need to have Powerpoint installed on the server!

Hope this helps…

GraemeSmith :switzerland: (BOB member since 2002-08-16)