COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pooja on 12 May 2010 08:16:25 AM

Title: report run in PDF & EXCEL
Post by: pooja on 12 May 2010 08:16:25 AM
is there any way we can set up a report runs in pdf and alternatvely to run as excel output also
Title: Re: report run in PDF & EXCEL
Post by: MFGF on 12 May 2010 09:52:00 AM
Sure - you can have the report run and render as multiple types in one go.  This can either be done on an ad-hoc basis using the 'run with options' button (then into advanced options) or via a schedule.

MF.
Title: Re: report run in PDF & EXCEL
Post by: pooja on 12 May 2010 10:19:56 AM
i do appolizize being a newbiee..

could you please explain in details please,

thank you in advance MFGF
Title: Re: report run in PDF & EXCEL
Post by: MFGF on 12 May 2010 12:31:22 PM
Quote from: pooja on 12 May 2010 10:19:56 AM
i do appolizize being a newbiee..

could you please explain in details please,

thank you in advance MFGF

A newbie?  Surely not - you have the highest count of New Posts on the entire forum by a large margin, and you're currently up at number 6 in the list for time spent online here.  :)

To run a report ad-hoc and produce both pdf and Excel outputs, do the following:
From Cognos Connection, click on the 'Run with options' button for the report.  Check the radio button next to 'Save the report', then click on the 'Advanced Options' link in the top right corner.  In the Formats area, select PDF and the Excel option you desire, then click Run.

To schedule a report and produce both pdf and Excel outputs, do the following:
From Cognos Connection, click on the 'Schedule' button for the report. Set the desired schedule frequency, then check the 'Override the default values' checkbox in the Options area.  Select both PDF and the desired Excel formats, then click OK.

Regards,

MF.
Title: Re: report run in PDF & EXCEL
Post by: pooja on 12 May 2010 12:39:57 PM

thank you so much. hope this helps other users too.
kindly appreciate.

(reason for newbiee = as a COGNOS prospective)
Title: Re: report run in PDF & EXCEL
Post by: MFGF on 12 May 2010 12:52:08 PM
Quote from: pooja on 12 May 2010 12:39:57 PMthank you so much. hope this helps other users too.
kindly appreciate.

You're welcome!  ;D

Quote from: pooja on 12 May 2010 12:39:57 PM(reason for newbiee = as a COGNOS prospective)

???  Nope - I'm not buying that at all.  You have been posting on here for over 18 months.  12 months ago, you posted that you had two years experience of Cognos already...

Quote from: pooja on 07 May 2009 12:21:21 PMi have been in cognos since couple of years....but no idea about sdk

And in this post you told us you are certified, which takes a lot of knowledge and experience to achieve...

Quote from: pooja on 30 Sep 2009 12:28:39 AMlooking for new assignment  on COGNOS as Cognos Developer (I am certified)

You're kidding about being a newbie really!  ;D ;D
Title: Re: report run in PDF & EXCEL
Post by: pooja on 12 May 2010 12:56:15 PM
..hang me UP.....


heheh

thank you again for your help
Title: Re: report run in PDF & EXCEL
Post by: MFGF on 12 May 2010 01:06:36 PM
 ;D ;D ;D