how to find the rank in report studio?
i need steps for this question.

Answer Posted / gangadhar

1.select the list
2.drag the Data item1 & Data Item2 into the list.
3.drag query calculation into list.
4.name it as 'rank'
5.develop the expression as----rank ([Data item1] for [Data
item2]) = 1.
6.If query item is number then it will display the ranks to
that number.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is requery in cognos?

2260


what are the features in cognos8ui

1786


1. Explain your project.

1792


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

754


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3370


faq's on cognos

3829


How to publish a package by running Java Script?

1805


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1803


What is meant by junk dimension?

805


What are the components used in web tier?

736


What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

1821


What do you mean by query studio?

703


Name the types of gateway?

763


What is a Pivot?

726


How to deploy from one server to another server?

2216