How to change the excel page properties in cognos?

[Ann]

I have a requirement in Cognos 8.4 to produce report outputs in Excel 2007. The excel outputs has to be printer friendly (should appear in one page).

My report width is the problem. report has a chart and a grid ( with 12-24 months in x axis as well as grid column) that makes the result to appear in next page while printing.

Any Idea of how we can change the excel setting (to make it fit width in one page)

[Ann]

No clue guys ??:(

Is there any way we can do this using javascript.. or cal a excel macro..?

[tjohnson3050]

In excel you can use the page setup to fit to one page wide. 

[Ann]

Thanks tjohnson3050 !

But I wanted to enable this through Cognos. By default when my cognos excel export open up, it should fit in one page.

[tjohnson3050]

Excel is fantastic for analyzing data.  That is what it is designed for, not producing printer friendly documents.

I don't think there is a single setting that will accomplish what you are looking for.  What you can do is experiment with the 'size and overflow' property on the chart objects until the excel output is what you are looking for.

In my experience though, PDF is much better format for producing print ready documents.  There is a phrase "the right tool for the right job". 

I know that sometimes we try to meet requirements as they are presented, but if the real requirement is nicely formatted for printing, I would at least try to make the argument that a PDF format would meet the need better.