rubedogg04 Posted January 15, 2008 Share Posted January 15, 2008 I am not sure if this problem is related to the reporting engine or iReport itself. Does iReport or jasperserver 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_salefrom sales_statswhere 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 17:16 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now