shivac

Hi I have 2 select boxes.First selection box has the list of regions and the second selection box has the list of cities.What i want is it possible that on selection of a region in the first selection box,cities related to that region appear in the second selection box? Please help

Hi Anadhraj... Hey its working now. Thanks a lot. But Its good for one subreport. If we have two subreports and when called from JS now its giving this following error. What error is this? whats the cause and how to fix it? Plz help. com.jaspersoft.jasperserver.api.JSExceptionWrapper: java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence. the files are same. Here instead of one subreport the report1.jrxml calls two subreports.

Hi Anandhraj,After following your instructions now I'm getting another error. I have attaced the code also. My Main report name is : report1 Subreport name is : catLine (which is a line graph) both are loaded to JS. The error now is com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error loading object from URL : repo:/catLineCode:<subreport isUsingCache="true"> <reportElement x="11" y="16" width="166" height="100"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA["repo:/catLine"]]></subreportExpression> </subreport>

Hi there can anybody help me how to do a subreport, I m using iReport 3.1.2 and JasperServer 3.1 . In my main Report I gave a Report Expression as "<subreportExpression class="java.lang.String"><![CDATA["repo:/Reports/SubReportDealer"]]></subreportExpression>" i tried like "/Reports/SubReportDealer" but no use it giving a error massage as "java.lang.ClassCastException: com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.client.ReportUnitImpl". "/Reports/SubReportDealer" Under a Report folder I created a JasperServer Report. What's the mistake i commited here?. can anybody help me out this?. Thanks in advance Shivac

Hi Is there any proper documentation for JasperServer 3.1 and iReport 3.1.2 ? (Other Than JS Pro). Thanks in Advance Shivac Post Edited by siva chidhambaram at 04/02/09 10:59

Hi Anandharaj, I m not getting your point, can you please give me some clear details about where i have to upload my main & subreport xml?.can you explain me What is "repo" Where can I use this. I m created simple chart in subreport, then in main report i m just give a path for "use existing report : D:iReport_Examples catLine.jrxml " then "Connection Exp : using the Master Report" Then no parameters. Then i give a preview its working. what mistake i commited here?. Then I call main Report .jrmxl file to JasperServer. Is this correct or have to change anything?. Thanks in advacne Shivac Post Edited by siva chidhambaram at 04/06/09 03:37

Hi Thanks for your Help. $X{} is Working fine for me. Thanks in advacne Shivac

Hi Anandharaj Thanks for your quick replay, I m using JasperServer 3.1 and iReport 3.1.2. when I give a preview in iReport it is working fine and when I run from JasperServer then it Shows "net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist". here I attached Master Report xml file. Thanks in advance Shivac

Hi Lucian Thanks for your quick replay Thanks in adavance Shivac

Hi there, I created a master report which having a subreports, When I give a preview in iReport it is Working fine. I m getting the following error message when I was running from jasperserver "net.sf.jasperreports.engine.JRRuntimeException: Parameter "DATABASE_TIMEZONE" does not exist". I refered earlier forum posts, but nothing turned out to help. My subreport contain only graphs I m not passing any parameters, then i called that subreport in master report. please help me out. Thanks in advance Shivac

Hi Lucian, Thanks for your quick replay, Lucian can you send me some detailed manner. Thanks in advance, Shivac

Hi there, I created a dashboard using iReport 3.1. Actually I want to set width and height of chart in percentage, because monitors are not in same pixel. so iif any body know how to do this in percentage please guide me. Thanks in advance, Shivac

Hi there, Event Handling option Is there in JasperServer, like ItemClick Event in chart, etc., What I actually want is Drilldown for chart . If so how can achieve it?. (Consider I have a bar chart which has a 4 bars like A,B,C,D. If I click the D bar then it should create a drilldown based on the D. Is it possible in JasperServer?). Thanks in Advance, Shivac Post Edited by siva chidhambaram at 03/31/09 04:56

Hi there I created a report using iReport 3.1 and now if I want to click a text Field then another report should open, is it possible?. and is it possible to pass the parameter from master report to linked report?. if so please guide me . Thanks in advance Shivac

Hi Anandharaj For multiple selection parameter, how can I use $P!{parameterName}. what is clean-up have to use any script to perform clean-up?. can u help me out this, can u post your samples so that I will get clear understand. Thanks in advance Shivac

Hi lucian Thanks for ur quick replay, I tried WHERE $X{IN, columnName, paramName} . This gives all the rows which are there in a table, then Imake a query like this WHERE v_name $X{IN, columnName, paramName} then it give a error massage that Error filling print... Error executing SQL statement for : classic net.sf.jasperreports.engine.JRException: Error executing SQL statement for : classic my query is "SELECT v_name, v_minval,v_maxval, v_defval FROM table1 WHERE v_name $X{ IN ,v_name,MyParam} GROUP BY v_name, v_minval, v_maxval, v_defval ORDER BY v_name ASC, v_minval ASC, v_maxval ASC, v_defval ASC" What the /mistake i commit can u help me please.. Thanks in advance shivac

Hi Anandharaj Thanks for ur quick replay. Ya after generating the report, if i want to click the column header then the clicked column should be sort. Thanks in advance Shivac

Hi I have a one query How can I use the column sorting in jasperserver 3.1? is it possible, if so how can achieve it. any help Thanks in advacne Shivac

Thanks for your quick replay, Thanks in advance shivac

ya i here with attached my .jrxml file. Thanks ain advance Shivac

hi Anandharaj, I tried both the possibilities "SELECT a,b,c,d FROM table1 WHERE a IN ($P!{MyParam}) GROUP BY a,b,c,d ORDER BY a,b,c,d " -- and parameter class as "java.util.Collection as well as java.lang.Object" and my default expression is "$P{MyParam}" as well as "SELECT a,b,c,d FROM table1 WHERE a IN ($X{MyParam}) GROUP BY a,b,c,d ORDER BY a,b,c,d" -- and parameter class as "java.util.Collection as well as java.lang.Object" and my default expression is "$P{MyParam}" both are not working. where i commit mistake can u guide me. if I use Collection then it shows "Error executing SQL statement for : classic" and lang.jang.Object it shows "No clause function for id Month found". help me out this.. Thanks in Advance shivac

hi there, I created a report using iReport 3.1 and now i want to implement the css for that report is it possible, if it so can u send me how to do that. Thanks in advance Shivac

hi Thanks for ur quik replay, i changed type as java.lang.Object and now after gave the input it produce an error massage like "Error filling print... No clause function for id MyParam found net.sf.jasperreports.engine.JRRuntimeException: No clause function for id MyParam found " But i gave a param name as MyParam and default value Expresion is also like this $P{MyParam} and i changed the Query editor as where a = ($X{MyParam}) any suggestion can help me out this. Thanks in advance Shivac

hi there, i m nebie to iReport & jasperserver, i m using JasperServer 3.1 here i m facing multi select list input values problem. the report is working fine for single input whenever i m trying to use multi select list then i facing the problem jasperserver shows "the Report is Empty". in iReport i m using the following method Parameter Properties are --> Parameter Name : MyParam -->Parameter Class Type : java.lang.String -->Use as a Prompt: Checked -->Default value Expression : $P{MyParam} (using Express Editor) -->Parameter Properties : Name - MyParam Value - Jan in my query report i m using like this: select a, b, c, d FROM table1 WHERE a IN ($P{MyParam}) ( i try like $P!{MyParam / (P!{MyParam}) ) GROUP BY a, b, c, d ORDER BY a, b, c, d; whenever i m using a static query like : select a, b, c, d FROM table1 WHERE a IN ('Jan','Feb','Mar') GROUP BY a, b, c, d ORDER BY a, b, c, d; this is working fine, so i want to know clear detail about how to use multi select list parameters dynamically, can any one help me out this?. Thanks in Advance, Shivac Abiba Systems Pvt Ltd.,

hi there, I have created a report using iReport 3.1, now I want to implement css for that report is it possible or not please give a clear idea. Thanks in advance Shivac