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
- 8594 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 |
15. If I select the current month and year how can we display previous 11 months data?
wat is bus schema?
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
What are the different uses of a repository manager?
------------------What is Focalpoint?
Define the cognos reporting tool?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
Interval Prompt's Usage? Example for usage in Project
Which studio is used to create reports?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What are the different ways of adding data in Transformer?
If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?
Teradata 
