Report Studio 8.2 Is there a simple way to restrict the list of results to, for

[tinas]

Hi all -

Is there a simple way to restrict the list of results to, for example, 100 account numbers?  I'm not looking for a ranking; just want to return a list of 100 account number.

Thanks for your help!

[sir_jeroen]

what are you trying to accomplish? Does your result set only need to return 100 acc numbers or does it have to be based on 100 acc numbers?

[tinas]

This particular report only needs to return 100 acc numbers.  There are times when the researchers will want the report to return a set of 100 random records.

[sir_jeroen]

you could specify in your Query Subject in FM only to use 100 records... 
For SQL Server:
select top 100 * from tableX
For Oracle:
select * from tableX where rownumber <101
For DB2:
???? :D

If it's only for 1 report you could try adding a filter like "Rownumber() < 101" to your query