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?
Answer Posted / 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 |
Post New Answer View All Answers
how to connect datamarts
What is a Folder?
9. What was the most complex type of report you dealt with?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
write a query to display the departments with no employee?
What are the other methods working as deployment functionality?
What is the difference between a cascading report and drill through report?
what is log in cognos?
What are the message flows?
How can create users and permissions in cognos?
What is the size of the cube?
What are all the types of report?
What is Fullouterjoin?
New coloums are added in database, then how you know in report level
What is drill down and slicing and dicing whats the difference between them?