Limiting number of rows returned 1

[Cognosferatu]

I am trying to create a table in Cognos that returns the top 50 "things."

Does anyone know how to limit the results of a table? Is it a property that is specified for the list...or is it something that has to be specified in the SQL?

 

[JGirl]

You could always include the whole table and use the rank() function in Report Studio reports, and add a filter in the report that is rank(...) <= 50 to return the top 50.
OR
You could get the whole lot done in the database (in a view?)
OR
You could have a database table/view created which ranks everything (ie. the rank number column is included in the database) and then you could filter by rank < 50 in the framework.

Which one is the most appropriate is for you to decide!

J