Data format changing to text when importing in Excel 2007 Data

[v2k4u]

Hi Gurus,

I have a quick question on the formatting of a report, i am trying to export the report to Excel 2007 Data and the numbers are getting displayed in Text format instead of Number but when i try to import the data to Excel 2007 everything displays as expected. I have this requirement as Excel 2007 has a limitation to display 65,000 rows per page.

Any valuable suggestions and inputs would be of great help...

Thanks.

[cognos810]

Hello v2k4u,
You can set the advanced parameter RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS  to a value of 1,048,576 and then use Excel 2007 as your output format.

-Cognos810

[v2k4u]

Hi,

Can you please specify where exactly i can set this advanced parameter RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS to a value of 1,048,576 ?

Thanks.

[cognos810]

-Logon as an Administrator
-Go to Launch > IBM Cognos Administration
-Click on Configuration tab
-Click on Dispatchers and Services
-At top right you will see a series of icons, click on the icon for "Set Properties - Configuration". See document attached for image.
-Next, click on Settings tab
-Click on "Edit" for Advanced Settings for the Environment Category. See document attached for image.
-Click on OK
-Click on OK again.

[bdbits]

I feel obligated to point out that exporting that many rows to Excel usually means you are not really making the best use of Cognos.

But what do I know.