Date dynamic filter on cross tab runs in cycle and times out

Migrateduser

<p>I have a crosstab report with a chart using maximo database. When I hard code date range in query, it runs a for sometime but returns result with chart but when I use dynamic filter on same date field, it runs un-end and then returns error for time out.</p>