Hi,
I have a matrix object in a report that sometimes runs off the side of the page based on the underlying data. Essentially if there are more than 11 columns it stretches out my page.
How can I fix this? Ideally, I would like to show only the Top 11 results but cannot seem to figure out how (or where, or on what data element) to properly set a filter.
Thanks.
Brad
You mean if there are more than 11 rows?
To get the top 11 results, you can do this:
select top 11 * FROM ... WHERE ....
No comments:
Post a Comment