I know you can limit the number of rows in PREVIEW mode etc. Is there a setting that limits the number of rows a given fex can return? We have a weird situation where IS sometimes fills a particular table with thousands of rows when only hundreds should ever be there. This creates and issue on a particular report...long story..anyway can we set a given fex to only return the first X numbers of ordered rows it finds?

This message has been edited. Last edited by: FP Mod Chuck,

Robert

When creating a report under the Filter's option choose Limit and you can set READLIMIT and/or RECORDLIMIT that will apply to that fex.

Worked. THANK YOU!