Report output should come in excel when user run the report

[jd]

Please any body can help me on below situation.
I have 1 prompt in my report. when user select the prompt report out put should come in excel.
is it possible??

[crn.siva]

Hi Laxmi,

You can try this way,

goto the cognos connection, in that what ever report user want to display output in excel select that report--> right side select the set properties --> in that click on report tab --> in report options --> select check box for Override the default values --> in that set format as excel.
and click ok.

I think it is useful for you,

any grammer mistakes excuse me.

Thanks,

[jd]

Thanks you very much kss00.

it worked exactly how I wanted.

Thanks again to sharing this information.