venuwin

Hi Lucian, Sorry for not reverting back for a long time. THe URL http://www.jasperforge.org/jaspersoft/opensource/business_intelligence/jasperreports/tutorial.html#Parameters that you gave me was of immense help to resolve many of the issues. Though mine is a belated reply, I must thank you very much. Thanks Once again !

Hi Lucian, I am also having the same issue of dynamically stretching the detail band. In my case i have 4 columns - so i can't resort to vertical printorder. Please suggest. Thank you very much for your valuable reply for my post related to request params in jasper report. It helped me a lot. --Venu

Hi, One more interesting thing i found. I removed 2 parameters in the query and had just put one param .. and the query looks like this : select FROM_UNIXTIME(e.timestamp/1000) as Initial,e.uniqueId,em.feature as feature, b.brandName as bName, e.appVersion FROM eventmetrics e,eventnames em,brands b where e.featureId ='AO1' and e.brandId = b.brandId and e.featureId = em.featureid and e.brandid= $P{rangeparam} limit 10,30 This works fine with one real time value for this range param but not with other values...erratic behavior. A query which has to return an empty dataset is returning values ? weird. But when i copy the query from the log and execute via mysql command line, i get an empty dataset. what exactly could cause a problem like this ? Please help. --Venu

Hi, I have just started working on Jasper. I am using iReports 2.0.5 and jasper 3. In the Report Query i have mentioned : SELECT FROM_UNIXTIME(e.timestamp/1000) as Initial,e.uniqueId,em.feature as feature, b.brandName as bName, e.appVersion FROM eventmetrics e,eventnames em,brands b where e.featureId ='AO1' and e.brandId = b.brandId and e.featureId = em.featureid and e.brandid=$P{brandname}$P{rangeparam} limit 1,10 where $P{brandname} and $P{rangeparam} are request parameters which i pass via JSPs. ALl the params are set but i get this exception : 02:27:28,324 ERROR [sTDERR] Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syn tax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' and (WEEK(FROM_UNIXTI ME(e.timestamp/1000)) = Week(CURRENT_DATE)) and (YEAR(FRO' at line 6 But when i replace the params with the values that are actually sent to the server , the same SQL works fine. It screws up. Any info would be of great help. --Venu

Pls find the attachment. It dynamically prints all the rows when placed in the detail band. previously it was in the colmnheader band. Is there a way to do this in the column header band itself ? [file name=ApplicationAccess.zip size=3094]

Hi, I am new to Jasper reports. For a report we need to display the results of a query. Query returns 2 rows of data but in the report , only the first row is displayed. Please help me display the complete data.