we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?
Answers were Sorted based on User's Feedback
Answer / shivani nadkarni
What i can think of is related more with the admin setup for Cognos.
Got to Cognos Administration -> System->Status
Under BatchReportService add the below parameters:
RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET - <true>
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS - <increase the row limit here>
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shivani
In continuation to my admin related change above I figured that using Excel 2007 can address this issue too. The limit has been increased on 2007 and all versions above it.
https://www.ibm.com/support/pages/ibm-cognos-icm-excel-row-limitation
Is This Answer Correct ? | 0 Yes | 0 No |
What is defined as Query studio?
Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
Define cognos report net?
What is the use of Generated Prompt? Where is it used in realtime project?
How we check the errors before running the report,plz let me know the answer
what is the difference between aggregation and role up aggregation ?
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
How can I change reports to another package???
What is difference between primary key and unique key constraints?
Can you define set to be cardinality?
what is render variable
5 Answers Accenture, Cap Gemini, Systime, TCS,
How to create a Ratio in Cognos Report studio Reports?