COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 05 May 2009 05:02:13 PM

Title: Report output should come in excel when user run the report
Post by: jd on 05 May 2009 05:02:13 PM
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??
Title: Re: Report output should come in excel when user run the report
Post by: crn.siva on 06 May 2009 02:46:29 AM
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,
Title: Re: Report output should come in excel when user run the report
Post by: jd on 06 May 2009 10:40:23 AM
Thanks you very much kss00.

it worked exactly how I wanted.

Thanks again to sharing this information.