Possible BUG in Report Query, iReport 1.3.3?

[rubedogg04]

Does iReport not like the use of the "max" sql function in the "Report Query" data section?

 

When i attempt to execute a simple report using the following query below, it only exports to HTML when i specify a data range in the parameters of 29 days max. Soon as i try to specify more, it doesn't work. It just hangs at the "filling report..." phase.

 

Any clue as to why this is happening? I know for a fact that nothing is wrong with the SQL i wrote because it runs fast in SQLplus and SQLDEVELOPER. All my other reports run fine and this is the only report i have creadet that uses max(decode... functions in the select.

 

Here is the query:

 

Code:

select sales_date,
max(decode(sales_key, 2, requests, 0)) as m_req,
max(decode(sales_key, 2, sales, 0)) as m_sale,
max(decode(sales_key, 3, requests, 0)) as a_req,
max(decode(sales_key, 3, sales, 0)) as a_sale
from sales_stats
where sales_date BETWEEN $P{start_date} AND $P{end_date}
group by sales_date

 

Please help. . .thank you.

Post edited by: rubedogg04, at: 2008/01/15 16:54

[rubedogg04]

Could this be a problem in the report engine that compiles the jrxml file?