Wednesday, March 7, 2012

Matrix - Limiting the width

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