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!
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?
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.
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