Open Word Document from COGNOS

[KANUL]

Hi all.
Can anyone please help me in creating a link in cognos report studio which will work as a link to pass the parameter and open the word doc related to that parameter.
I want 2 fields.
Name     Link
a            ?Name?.doc
b            ?Name?.doc

so when i click on link value, word doc should open .
can this be done ... any help is highly appriciated.

 

[Rajesh_Vanam]

Hi,

Your requirement can be done with cognos.

I am not 100% clear with your requirement. I will tell you the way i did as per my understanding. You can change same that suits your requirement.

First create a folder named shareddocuments under \cognos\c8\webcontent folder. Copy all the word documents to the shareddocuments folder.

In report studio add text prompt to prompt page by assigning parameter 'p1' to it.

Then in your report page drag hyperlink from Toolbox. Click on hyper link, then in properties pane under URL Source, change Source Type to Report Expression and give report expression as follows,

'http://localhost/cognos8/sharedocs/'+ParamDisplayValue('p1')+'.doc'

Tats it. If you run this report enter name of document you want to retrieve, in report page by clicking hyperlink it will opens the word doc by the name given in text prompt.

Even though it is not matching 100% to your requirement you can make changes to make it work to your case.


Regards,
Rajesh

[Gollapudi]

Hi,

I think this will match the above requirement...
And Can you tell me if therez any option to open our current output in word format if I click on some link....

Thanks,
Gollapudi.

[Rajesh_Vanam]

Hi,

We don't have any option to export report output in word document. We not even have work around for this.

Instead we are using Go Office to export reports to Word and PowerPoint.

Cheers,
Rajesh

[Gollapudi]

Thats ok... But I am actually looking at some Javascript options.. if it can convert the entire report into word format...

Thanks,
Gollapudi.