babs

Hi There ! I am using IReport and Jasper server 3.0. and tomcat Small reports work good --- no issues. But now I have this BIG report (few thousands of records). It gets generated and runs in Ireport (takes 20 min) and then I upload it to Jasper server by right click "Run Report Unit". On Jasper Server it gets uploaded. But when I run that report on Jasper Server (takes 20 min) it does run. But u see, 20 minutes is a long time for a report to open. considering a real time user scenario. What is the way out to minimize this time in Jasper environment ? What is way out ? thanks, k

Hi There ! I am using IReport and Jasper server 3.0. and tomcat Small reports work good --- no issues. But now I have this BIG report (few thousands of records). It gets generated and runs in Ireport (takes 20 min) and then I upload it to Jasper server by right click "Run Report Unit". On Jasper Server it gets uploaded. But when I run that report on Jasper Server (takes 20 min) it does run. But u see, 20 minutes is a long time for a report to open. considering a real time user scenario. What is the way out to minimize this time in Jasper environment ? What is way out ? thanks, k

Hi All, I am going good with developing the reports. using ireport 3.0 and jasper server 3.0 in ireport created a report. compiled and Run in Ireport. Get to see the report in IReport Jasper Viewer. (this report displayed some 1100 rows). so everything good. now, I right click the report unit in ireport and then Run Report Unit in order to fill the report on the jasper server. It takes like 10 minutes saying filling report on server and then crashes in ireport message console giving following error. How can I get rid of this error ? Any jasper export faced this issue ? Filling report on server: http://localhost:8080/jasperserver/services/repository ; nested exception is: java.net.SocketTimeoutException: Read timed out AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.net.SocketTimeoutException: Read timed out faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read(BufferedInputStream.java:235) at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:196) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.jasperserver.irplugin.wsclient.RepositorySoapBindingStub.runReport(RepositorySoapBindingStub.java:193) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:390) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:311) at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:80) at java.lang.Thread.run(Thread.java:595) {http://xml.apache.org/axis/}hostname:rpisolkar-e8210 java.net.SocketTimeoutException: Read timed out at org.apache.axis.AxisFault.makeFault(AxisFault.java:101) at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:301) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.jasperserver.irplugin.wsclient.RepositorySoapBindingStub.runReport(RepositorySoapBindingStub.java:193) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:390) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:311) at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:80) at java.lang.Thread.run(Thread.java:595) Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read(BufferedInputStream.java:235) at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:196) ... 14 more

Hi All, I am going good with developing the reports. using ireport 3.0 and jasper server 3.0 in ireport created a report. compiled and Run in Ireport. Get to see the report in IReport Jasper Viewer. (this report displayed some 1100 rows). so everything good. now, I right click the report unit in ireport and then Run Report Unit in order to fill the report on the jasper server. It takes like 10 minutes saying filling report on server and then crashes in ireport message console giving following error. How can I get rid of this error ? Any jasper export faced this issue ? Filling report on server: http://localhost:8080/jasperserver/services/repository ; nested exception is: java.net.SocketTimeoutException: Read timed out AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.net.SocketTimeoutException: Read timed out faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read(BufferedInputStream.java:235) at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:196) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.jasperserver.irplugin.wsclient.RepositorySoapBindingStub.runReport(RepositorySoapBindingStub.java:193) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:390) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:311) at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:80) at java.lang.Thread.run(Thread.java:595) {http://xml.apache.org/axis/}hostname:rpisolkar-e8210 java.net.SocketTimeoutException: Read timed out at org.apache.axis.AxisFault.makeFault(AxisFault.java:101) at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:301) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.jaspersoft.jasperserver.irplugin.wsclient.RepositorySoapBindingStub.runReport(RepositorySoapBindingStub.java:193) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:390) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:311) at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:80) at java.lang.Thread.run(Thread.java:595) Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read(BufferedInputStream.java:235) at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78) at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106) at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413) at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973) at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735) at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:196) ... 14 more

Hi Fgar, my case was, I had a hyperlink(drilldown) on report1 and say user clicks on hyperlink "xyz inc" then i have report2 that will show the correct records for xyz inc. bcaz in report2 i have a where clause like ......... WHERE companyname=$P{CustomerName} so the challenge i was facing was how to pass that "xyz inc" to report2 SQL where clause. so the key is, in report1 u have to have a correct URL that will get invoked after hyperlink click. rightclick the hyperlink ---- Hyperlink tab ---- Self ----- Report Execution --- Reference "http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/samples/ oracletomysqllimit6&standAlone=true&ParentFolderUri=/reports/samples" oracletomysqllimit6 is the reportunit name of report2 Sililarly under Hyperlinktab --- Link Parameters tab ---- give yours as -- CustomerName and $F{CustomerName} similarly TextField tab ----- java.lang.String (since mine parameter is string) ---- Now --- $F{CustomerName} Now select report2 "Input Control" in ireport repository and right click ----- "Create a new input control" give CustomerName every where under General tab and then under "Input Control details" tab select "Single Value" and check Mandatory checkbox. Now report two you already must have query ....... WHERE companyname=$P{CustomerName}. compile both reports. and then rigth click "Run both Report Units". Now both are sitting on JasperServer repository. Run repot1 in server, click hyperlink, that will pass the clicked value to WHRE clause of report2 and that SQL gets executed and you have report2 displayed with correct records. boom you have drill down working. !!!!!!!!!!!! remember CustomerName is ur hyperlink column in report1 that appears on report1 (in design mode). and its case senssitive where ever u pass it. so take special care as u reference it throughout. remember I am using IReport 3.0 version. check urs. hope that helps. Enjoy !! keshub

Thanks to All. I got this working. Now what I have is Hyperlink in report1 that generates a correct URL with parameters and then calls the report2 (located in seperate Report UNit) and parameter from report1 is passed to SQL $P of report2 VIA URL. I have a real dynamic hyperlink working !!!! that was so cool !!!

Thanks to All. I got this working. Now what I have is Hyperlink in report1 that generates a correct URL with parameters and then calls the report2 (located in seperate Report UNit) and parameter from report1 is passed to SQL $P of report2 VIA URL. I have a real dynamic hyperlink working !!!! that was so cool !!!

Thanks for your response. I am using IReport 3.0, JasperServer and Tomcat. a>Created Report1 and Report2 using IReport's "IReport Wizard". Both these reports are in seperate REPORT UNITS. In wizard I put the respective SQLs. My Report2 SQL does have the ............ WHERE CustomerName = $P{CustomerName} the value 'IBM' or 'Sun' or 'Oracle' etc I am expecting to provide from Report1's CustomerName --- Hyperlink column click. I used the "Hyperlink" tab ------ "Self" ------ "Report Execution" and in Link Parameter tab added two parameters _report as "/reports/samples/report2" and CustomerName as $F{CustomerName} In report2 "Add Value Parameter" defined parameter as Parameter Name as CustomerName and Default Value Expression as "" Hoping this is the parameter I have in Report2's SQL as $P{CustomerName} and it would noe get its value from report1 hyperlink. b>I compiled both the reports in IReport. Compile successful. ! c>So each of these report units, I right click and "Run Report Unit". Both reports now go sit in the Jasper Server repository. d>I go JasperServer UI and then open my Report1 from repository. It opens successfully. Then in column1 I notice Hyperlinks show up like IBM Oracle HP etc so i click say IBM hyperlink. This click opens the Report2 with the URL in the browser of JasperServer showing up as follows........................................ http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow& reportUnit=%2Freports%2Fsamples%2Foracletomysqllimit6 &CustomerName=FUJITSU+LIMITED&_eventId_drillReport= &_flowExecutionKey=_c6F8AD19C-001F-3214-D548-CD9EF0BA6E21_k039A41B2-C696-C776-F942-F1AFD14EC883 &reportLocale=en_US Please notice in above URL, report2 and CustomerName is correctly constructed. It also opens the report2 in the JasperServer browser, but unfortunately its shows "The report is empty." UPtill now I am happy, the FULL circle from report1 hyperlink click to opening the report2 in jasperserver is succeesful ---- EXCEPT report2 is empty. I know why it says empty. REASON is ------ report2's SQL WHERE clause is just not getting that "IBM LIMITED" value (either from the URL OR whichever other option/wizard etc might be. I just dont know, what is the way you can transport the parameter value between 2 report units and be able to supply to SQL param$P{CustomerName} ???? Now can u please help me how to solve this last part of puzzle using IReport JasperServer combination ? Most important point is both these reports are in two seperate Report Units. If this is resolved then I am going GOOD !!! thanks, keshub

THE url got trimmed in above port so sending again ............. http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow& reportUnit=%2Freports%2Fsamples%2Foracletomysqllimit6 &CustomerName=FUJITSU+LIMITED&_eventId_drillReport= &_flowExecutionKey=_c6F8AD19C-001F-3214-D548-CD9EF0BA6E21_k039A41B2-C696-C776-F942-F1AFD14EC883 &reportLocale=en_US

Not sure how you generate the report2, but I suppose you have some kind of server that takes care to generate the second report. " "BOTH reports generated using "Report Wizard" of IReport 3.0 Both reports are in seperate "Report Units" Both report has their own SQL statements I put during wizard. Both report inits compile success within Ireport and also get uploaded to JasperServer. "" Then I suppose this url will take a parameter (CustomerName?) so you have to pass this parameter in the url (or let jasperreports to add it for you declaring an Hyperlink parameter. ""Yes used Hyperlink parameter and created 2 additional parameters using IReport wizard so CustomerName and report2 unit does appear in URL. Actually it also open report2 on click of hyperlink. except the report2 says "the report is empty" Then the responsability of passing the parameter to the report2 is up to the code you use to generate it. "As I said, Since I used IReport wizards to generate both report units --- I DO not have my own java code. Thought my own code is NOt needed since I am using WYSIWUG IReport designer and Jasper Report" JR alone has not drill down capabilities, you need a backend app like JasperServer, or your one. "Drill down/Hyperlink I implement using help from book --- definative guide to Ireports I DO have JasperServer where both report units are sitting at this point" tomcat is my web server. "" My report2 SQL where clause $P{CustomerName} is not getting the real value say ..... "IBM LIMITED" and hence report2 keeps showing empty. Thats the issue. Hi Giulio, Thanks for your response. I am using IReport 3.0, JasperServer and Tomcat. a>Created Report1 and Report2 using IReport's "IReport Wizard". Both these reports are in seperate REPORT UNITS. In wizard I put the respective SQLs. My Report2 SQL does have the ............ WHERE CustomerName = $P{CustomerName} the value 'IBM' or 'Sun' or 'Oracle' etc I am expecting to provide from Report1's CustomerName --- Hyperlink column click. I used the "Hyperlink" tab ------ "Self" ------ "Report Execution" and in Link Parameter tab added two parameters _report as "/reports/samples/report2" and CustomerName as $F{CustomerName} In report2 "Add Value Parameter" defined parameter as Parameter Name as CustomerName and Default Value Expression as "" Hoping this is the parameter I have in Report2's SQL as $P{CustomerName} and it would noe get its value from report1 hyperlink. b>I compiled both the reports in IReport. Compile successful. ! c>So each of these report units, I right click and "Run Report Unit". Both reports now go sit in the Jasper Server repository. d>I go JasperServer UI and then open my Report1 from repository. It opens successfully. Then in column1 I notice Hyperlinks show up like IBM Oracle HP etc so i click say IBM hyperlink. This click opens the Report2 with the URL in the browser of JasperServer showing up as follows........................................ http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=%2Freports%2Fsamples%2Freport2&CustomerName=IBM+LIMITED&_eventId_drillReport=&_flowExecutionKey=_c6F8AD19C-001F-3214-D548-CD9EF0BA6E21_k039A41B2-C696-C776-F942-F1AFD14EC883&reportLocale=en_US Please notice in above URL, report2 and CustomerName is correctly constructed. It also opens the report2 in the JasperServer browser, but unfortunately its shows "The report is empty." UPtill now I am happy, the FULL circle from report1 hyperlink click to opening the report2 in jasperserver is succeesful ---- EXCEPT report2 is empty. I know why it says empty. REASON is ------ report2's SQL WHERE clause is just not getting that "IBM LIMITED" value (either from the URL OR whichever other option/wizard etc might be. I just dont know, what is the way you can transport the parameter value between 2 report units and be able to supply to SQL param$P{CustomerName} ???? Now can u please help me how to solve this last part of puzzle using IReport JasperServer combination ? Most important point is both these reports are in two seperate Report Units. If this is resolved then I am going GOOD !!! thanks, keshub

Hi All, I have created report 1 and report 2. Both have different SQL queries. Report 1 has a column called CustomerName that I made as Hyperlink. On click of Hyperlink CustomerName, I want a report 2 to open, after successful execution on SQL in report 2. I have everything working except --- not able to pass the CustomerName value to report 2 SQL query. report 2 SQL query has where part as ...... WHERE customer_name = $P{CustomerName} This $P{CustomerName} is just not getting the value say IBM when customer clicks IBM hyperlink in report 1 like the report 2 query should become like WHERE customer_name = 'IBM' kind of thing. What is the way in IREport 3.0 to pass parameter value from Report1 TO SQL query param of report 2 ?? What wizard steps can do this ? thanks again, keshub

Hi All, I have created report 1 and report 2. Both have different SQL queries. Report 1 has a column called CustomerName that I made as Hyperlink. On click of Hyperlink CustomerName, I want a report 2 to open, after successful execution on SQL in report 2. I have everything working except --- not able to pass the CustomerName value to report 2 SQL query. report 2 SQL query has where part as ...... WHERE customer_name = $P{CustomerName} This $P{CustomerName} is just not getting the value say IBM when customer clicks IBM hyperlink in report 1 like the report 2 query should become like WHERE customer_name = 'IBM' kind of thing. What is the way in IREport 3.0 to pass parameter value from Report1 TO SQL query param of report 2 ?? What wizard steps can do this ? thanks again, keshub

Hi, Using IReport 3.0 community edition. Created two sepearte reports (seperate report units). Each has its own SQL query report1 --- has a field called customer name. i want this field tobe hyperlink. and on click of hyperlink say "xyz customer inc" it should supply the parameter value (xyz customer inc) to report2's SQL. So report2 will open up with table for xyz customer inc. I have given correct $P{customername} in report2 query. How this would grab the real value coming from report1 ?? Is it possible in IReport 3.0 ?? what steps ? thanks !

Hi I downloded the jasper server professional edition and it also comes with IReport. bundled. I tried to open IReport designer and keep getting following error. any idea ? clue ? C:PROGRA~1jasperserver-pro-secondinstall3.0ireport>ireport.bat Exception in thread "main" java.lang.UnsupportedClassVersionError: it/businesslo gic/ireport/gui/MainFrame (Unsupported major.minor version 49.0) at java.lang.ClassLoader.defineClass0(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:509) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:12 3) at java.net.URLClassLoader.defineClass(URLClassLoader.java:246) at java.net.URLClassLoader.access$100(URLClassLoader.java:54) at java.net.URLClassLoader$1.run(URLClassLoader.java:193) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:186) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265) at java.lang.ClassLoader.loadClass(ClassLoader.java:262) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:322) thanks, babs

Hi Matt, I am not able to see the Add Parameter wizard in my IReport ---- Is it because I am using IReport community edition ? thanks, babs

Hi Matt, Thanks for your reply. See thing is i am using IReport 3.1.0 I also purchased a paper book "definative guide to IReport" for ref. Book is based on IReport 2.0 I opened the File oracletomysqllimit9_subreport2 in IReport editor. and I am looking for a wizard to define parameter (CustomerName). "I am just not finding the wizard that would add parameter in my subreport jrxml." I also searched web. and got a old post perhaps referring to older IReport 2.0 that says :::: " Create 2 parameters in your SUBREPORT... gNum and dNum View > Parameters ... click New for each parameter you create. NOTE: make sure your Parameter Class Type is what you want to use I believe your query will be fine as it is." As in above like View > Parameter in IReport 2.0 ---- I am looking similar wizard in my IReport 3.1 and I am JUST NOT finding it. Also there isnt IReport 3.1 documentation on jasper site, I want to buy. It would be great help if you can tell me (in IReport 3.1):--- a>where is that Add Parameter wizard, that would add the parameter in my jrxml ? You can just tell me like click this this and this in IReport designer to all parameter in opened oracletomysqllimit9_subreport2 file. I am stuck here since yesterday here :-) :-) thanks in advance babs

Hi Matt, After looking those 2 master subreport jrxml, did u get any clue why the parameters passing is failing ? thanks in advance ! babs

In short I am asking about "Drill Down" functionality :-)

Hi There, "Is this Possible ?" How ? I have created a report1 that has 5 columns. It has one column called "Country". In my database, I have table that list 5 states in each country. So now u know what I want to do :-) This report1 correctly displays in my IReport (version 3.1). All I want to do now is :--------- 1> Convert the Country column into a Hyperlink. 2>Say User clicks hyperlink "USA" then another report2 open, that will list 5 states from USA. QUESTIONS:---- a> How do I convert my current static column "Country" into a html hyperlink for user to click ??? b> Would report2 be a second report (select states from ........) , OR is it going tobe a subreport (select states from .....) what is standard IReport procedure to achieve this. ?? c> How do I pass the clicked value USA from first report hyperlink to second states page SQL where clause ?? b> How do I mention to Hyperlink ------- ok go here and open the second report................ Something like we do in HTML ------ <a href="www.go.com">Jump to next </a> kind of thing Last but important ----- I want to achieve this in IReport 3.1 NOT older versions thanks in advance as always, babs

Oh God ! If you use Attachment1 and Attachment2 to upload two files, it shows one file uploaded twice. Ok, now here I am uploading the file again, which I beleive did not got uploaded before. So ---- In all there are only two files ------- Master and Subreport thanks, babs

Hi Matt, Dont refer to those two files. They were wrong. Please refer two files with this post. These are correct. thanks, babs

Hi Matt, Ok. I moment u release IReport 3.1 documentation, I am sure to buy. If u have any mailing list, u can send me email at javaraje@hotmail.com the moment ireport 3.1 doc is released. I will buy it immediately. So nice to know --- reports, charts etc developed using IReport 3.1 can work in Jasper Server Community edition without any version/incompatability issues. Yes, as I dropped the subreport element on master report, I did click subreport element and then went to properties --------- and then filled the connection with $P{REPORT_CONNECTION} ----------- then clicked the parameters---------- and in subreport return values window that opened inputted the Name and Expression fields with parameters. So yes that part is done. I suspect the subreport MySql query's parameter placeholder is the culprit. though I am not sure. I have attached master and subreport -------- jrxml for ur reference. and am using Mysql database. Let me know if this helps ! thanks, babs P>S So I will continue my devep using IReport 3.1 and Jasper Server community edition since no version issues.

Additional Info is : I am using IReport version 3.1.0 and IReport is connecting to Jasper Server community edition to upload the reports (Hope there are no version issues, as I go ahead with my development. Are there any ??) Am I getting above Query Parameter not Found because of this ??? Bcaz I am getting error in the IReport itself. Any idea ? My ireport 3.1.0 is a GNU GENERAL PUBLIC LICENSE. Hope its not limited to 30 days or so. I want to download "How to use ireport 3.1.0 ........." documentation from development (developing reports, subreports, passing parameters, cross tab etc etc etc). I do not see documentation available TO BUY on jaspersoft site. anyone has the correct link ? thanks, babs

Hi There, Ok using IReport 3.1.0 Created a master report. Created a Subreport ---- part of subreport query is WHERE bill_to_customer_name = '$P{Name}' and meaning, I have a parameter Name in subreport query, which will get its value from master report. I have added the subreport element in master report. correctly added the subreport parameter and value expression linking to master report parameter $F{Name} I have correctly specifiled the subreport .jasper location in the master report. Now, when I go compile the subreport ----------- "It JUST does not allow me to compile always giving Query Parameter not Found:Name error in ireport. I even checked the directory and there isnt any .jasper subreport file. This error is due to the parameter ('$P{Name}' ) I have defined in the subreport. So now i am in a loop :--------- 1> Parameter is defined in subreport 2> due to parameter, ireport keeps complaining Query Parameter not Found:Name and JUST DOES not create the .jasper of subreport 3> since there is no subreport .jasper, I simply CANnot compile the master report 4> I am STUCK. 5> Whats is the way out. I am damn sure, so long the ireport would not create a .jasper file, with that parameter in my subreport sql, I am just stuck. 6> Is it BUG ? Whats is way out ? thanks ! bab

Hi There Not sure if this will help. But after looking at the following link, I am of strong opinion "COmmunity edition is NOT work with ORACLE or Oracle Application server. Community Edition CAN work with MySql" "Professional edition WILL work with Oracle and Oracle App server " http://www.jaspersoft.com/JasperSoft_Supported_Platforms.html any Inputs from Jasper folks welcome !!!