formatting doesn't apply in datapump

[tomkrier]

I have a model that produces a report that has different formatting including a page break between different key values. When you export with an .xmod no formatting is made what-so-ever. I used that same .xmod and saved it as a .mod and exported and it at least did the color and heading format, but still no page breaks. I have it set so it should 'Apply formatting to XLS files'. Was wondering what is up with this issue.

[Gareth Horton]

Tom

You need to ensure that Excel is installed on the machine where Data Pump is installed to get the Excel formatting.

Additionally you need Monarch 8 and MDP 8 to get the page break formatting in Excel. That feature was only introduced in V8.

Gareth

Originally posted by tomkrier:
I have a model that produces a report that has different formatting including a page break between different key values. When you export with an .xmod no formatting is made what-so-ever. I used that same .xmod and saved it as a .mod and exported and it at least did the color and heading format, but still no page breaks. I have it set so it should 'Apply formatting to XLS files'. Was wondering what is up with this issue.