Excel formatting

[jp92506]

I have an issue with exporting a report into excel from cognos impromptu 7.4. When I preview the report in cognos it appears fine and fits into one page, but when I export it into excel it does not maintain the same formatting and fits into multiple pages. There is a lot of reformatting that needs to be manually done and this is not very productive. Does anyone have any ideas or suggestions on how to fix this?

Thanks for your help,
Joe

 

[almeids]

Joe-
I thought there was no formatting at all, just a dump of query items without regard to the report content, but I may be confusing it with .csv output. In any case, Cognos did not do as good a job in preserving formatting with Impromptu's Excel output as they do in their newer products (in their defense, perhaps due to Excel design/limitations at the time). This is my long winded way of saying I believe you are stuck with it, and will have to do any additional formatting post-facto in Excel with a macro if it's critical.
Steve

 

[drlex]

Joe,
I second what Steve has already posted - my macros are three times as long as they need to be, due to the need for post-report processing.
Since you're using 7.4, you might get a better result in the export if you set the Export version to "Excel 2002" (Report Properties > Excel Tab > Version ) and see how the check boxes affect the formatting.
Lex

soi la, soi carré

 

[jp92506]

Thanks for the comments. Unfortunately, I guess it appears that I am stuck with what is exported into Excel.

 

[mcgrathl]

Does anyone by chance know how to make the formatting for Excel into Landscape and not Default to Portrait. I have created a report that is going to be sent out but it needs to be in a landscape format and I have made the changes to landscape but when you open the excel it is portrait. Our company currently uses:ReportNet 1.1 MR 3

 

[almeids]

I looked into this at one point and there is no way to control that from ReportNet (boy, I'm really turning out to be Mr. Bad News in this thread!).
Even in Excel it's on a document by document basis, i.e. you can't set it as a default (at least not in 2003). The best you might be able to do is set Landscape in the page setup of Excel's default document template, though I'm not sure if that would apply when opening a CRN report. If it works you'd have to do it on a client by client basis and then you'd have the opposite problem with anything you wanted to come up Portrait.
I may have read something about Cognos 8 correcting this but am not sure.
If you find a solution please post back!
Steve

 

[stewm]

I think the landscape issue has been corrected in 8.3.

Mark Stewart
Business Intelligence Consultant
Consultants Club Corp.
Windsor, Ontario
Canada