Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w excel 2000 and excel 2002 sheets if any
body know this answer plz tell me
- 4 Answers
- 8829 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / haribhm
In Excel 2000, data is shown in a single excel sheet.If the
cognos report have multiple report pages to be displayed,
excel 2000 is not a right choice.
If the cognos report have multilpe report pages to be
displayed, excel 2002 is the correct choice as it can show
multiple report pages output in multiple worksheets in a
single excel file.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / prashant
There are multiple versions of Excel output for backwards
compatibility reasons.
CSV - raw data, no formatting, only possible with single
Query reports. Delivered in email as a .CSV file.
Excel 2000 Single Sheet - all report pages rendered to one
Excel 2000 worksheet. Delivered in email as a .HTML file.
Excel 2002/2003 - each report page is rendered to its own
Excel 2002/2003 worksheet, in a single Excel 2002/2003
workbook. Delivered in email as a .MHT file.
So the difference will be type of extension of the the file
and the way the report O/P gets generated.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manju
Excel 2000 having limitation upto 65,536 rows and 236
columns.
Excel 2002 doesnot have limitation.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / srinivas naidu
cognos 8 can produce reports in excel foramt.three options
are available:
EXCEL 2000 single sheet:in this we can see the data earlier
than 2002.
EXCEL 2000 :You can view the data Microsoft EXCEL versions
2002 and later
EXCEL 2002:You can view the data Microsoft EXCEL versions
2002 and later
| Is This Answer Correct ? | 2 Yes | 9 No |
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
What do you understand by the term 'aggregate advisor?'
How do we create row level security in cognos8?
--------------Diff b/w ODS and OLAP?
What is the difference between macro & Parameter
Can i apply drill through on master detail relationship report?
What are the components of the report studio?
What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?
whats the difference between previous version of cognos and cognos 8 BI?
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
What is a Folder?
I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows
Teradata 
