Answer / chiru

Apart from SQL Queries... When we need to generate a report
as per above requirement, first of all drag and drop deptno
(lets assume having deptno=10, 20, 30), After that drag and
drop "workers" Query item.... After that apply grouping on
deptno Query Item.... If u apply grouping on deptno.. it
automatically gets totals of all workers group by deptno...
But as per our requirement go to cummary and apply total icon
on workers Query item...
after that again apply average option from summary on workers
Query Item...
Now u can get both average and summary for deptno wise.. i.e
when u run the report......

Answer / lakshmi reddy

select avg(depttotal) from (select sum(sal) as depttotal
from emp group by deptno)

What is a Complex report and explain?

4 Answers   IBM, Satyam,

---

-----------------What is Singleton?

1 Answers   BoA, Cap Gemini, TCS,

---

why we r using report studio in webbased only and fm windows based only

1 Answers  

---

what is filter?give me one example that you created a report in your project?

3 Answers   IBM,

---

what r the claims? how many type of claims we face from client side?

1 Answers  

---

what is report burn and where it occurs

3 Answers   IBM, Target,

---

What do you understand by the term 'aggregate advisor?'

0 Answers  

---

How do we implement Check Box Prompt in COgnos Report Studio?

2 Answers  

---

what are the errors faced while bursting the reports and how to solve those errors?

0 Answers   EDS,

---

what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?

2 Answers   HCL,

---

--------------How to do Report Testing in Reports?

1 Answers   IBM,

---

what are the limitations of cognos reportnet?

11 Answers   IBM, Nestle, TCS,

---