Exporting Cognos PowerPlay data to MS-Word

[Spud2]

Hi,

I have a need to create an MS-Word document report
that has text that dependends on the data in an
Oracle database. The document has the company logo,
text that depends on the data and MS-Word tables
that also depend on the data.

Anyone know if this can be done with PowerPlay ?
If so, what methods exist?

Ultimately the report also needs to be e-mailed to
a group of people in the company.

Thanks.

 

[Draoued]

I would say that Impromptu is a better tool for this purpose.
but the output will be a PDF document.

 

[drlex]

I agree with Draoued - I use Impromptu to save data in .dbf format and then use the mailmerge feature of M$ Word to bring in the data.
lex

 

[semby]

I've done similar work to load powerplay graphs into PowerPoint documents.

What we did was build two macros:

Macro #1 in powerplay to save the appropriate reports out to .jpg files

Macro #2 in PowerPoint to import the images into the PowerPoint document, and apply formatting to it.

It shouldn't take much effort to extend such functionality into a word document.

 

[Spud2]

Thanks for the replies.

The issue that we only have PowerPlay here. Also, the whole
process needs to have no user intervention. As the scheduler
kicks of the report, the PowerPlay report needs to be saved in
an MS-Word format and e-mailed out to the users.

From what I gather from semby's post, I can do this with
macros or scripts. Also, PDF or JPG will not work, as the
users should have the ability to change the MS-Word document
or add text to it.

The user does not prefer CSV/Excel either.

Any other thoughts?

Thanks.

 

[semby]

You should be able to change the text of the ms-word docunment with the embedded images option, as long as the text is not in the powerplay reports

On our PowerPoint app, I left spots in the slides for comments to be inserted into the reports.

However there was manual intervention, someone had to open powerpoint and run the powerpoint macro. I'm sure if I knew vb a little better I could have automated this as well.

You may also be able to use the linking features of office to link to some type of rendering of the report, you would be limited to everything that powerplay can 'save as'

Cheers!

Charles