• the query runs good for any values in less than a minute. even the reprot runs good on BIDS. The problem is on the report manager. FYI... the report is Matrix the row values are displayed as columns.