Answer Posted / adiubar

Open report studio >> add data item in the sequence EMP name , Emp Number , salary >> sort the salary column in descending order
Go to query explorer >> drag a data item from the toolbox >> open the data item you have created and use rank function on salary
i.e. Rank(salary)
Now add a detailed filter value [Data Item1] <= 20 and run the report .

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2013

---

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

1039

---

What are the two types of framework manager?

1340

---

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

2049

---

1. Explain your project.

2054

---

What are the ways to import data into catalog?

1087

---

What are the components used in web tier?

992

---

5. Which type of report you build more, list, crosstab or chart and why?

2020

---

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.

2543

---

What is the model filter?

1022

---

difference between impromptu and cognos8

2448

---

What are slice and dice?

933

---

how to merge 2 crosstabs thans

2643

---

how you create security to reports?

1059

---

What is the function of cognos dispatcher?

1216

---