thevoice

hello there, i have one server on which my ruby is running. From the ruby application i try to put report on the jasper server that is running on other server. In ruby code i use java code to put jrxml on jasper server and in return i get the report in html format. When i try to get report in html format the i get the following on server where ruby code is running: Processing ReportController#images (for 124.125.154.192 at 2008-06-03 03:51:41) [GET] Session ID: 034432fsdf43343324fdj343kdffd434 Parameters: {"action"=>"images", "id"=>"px", "controller"=>"report"} User Columns (0.000621) SHOW FIELDS FROM users User Load (0.000597) SELECT * FROM users WHERE (users.`id` = 1) Controlleraction Load (0.000391) SELECT * FROM controlleractions WHERE (controllername = 'report' and actionname = 'images' ) LIMIT 1 and shows me the same report that i upload on the jasper server instead of the new report that is generated from the ruby+java code. Why i am getting the same report each time? What is reason of above details that i got from the server(running ruby code). Please help to solve these problem :) Regards, TheVoice

Hello alex.chan Thank you very much for your reply. PLEASE CAN YOU TELL ME WHAT I HAVE TO PASS IN ResourceDescriptor.setParentFolder()?? I have tried tried to call ResourceDescriptor.setParentFolder() and pass the path(like /root/myfolder) where i wanna to put my main report unit. I want to put whole report unit on the server. Report unit includes datasource and jrxml. CAN YOU GUIDE ME WHAT I HAVE TO PASS IN ResourceDescriptor.setParentFolder() METHOD CALL?

Hello there, I have java program which puts whole report on jasper server. Following is java method which puts report on the server. public static void putReportUnit(JServer srv,String reportName,String resName) throws Exception { ResourceDescriptor rd = new ResourceDescriptor(); File resourceFile = null; ResourceDescriptor tmpDataSourceDescriptor = new ResourceDescriptor(); tmpDataSourceDescriptor.setWsType(ResourceDescriptor.TYPE_DATASOURCE); tmpDataSourceDescriptor.setReferenceUri("/reportResources/dbconnection"); tmpDataSourceDescriptor.setIsReference(true); rd.getChildren().add(tmpDataSourceDescriptor); ResourceDescriptor jrxmlDescriptor = new ResourceDescriptor(); jrxmlDescriptor.setWsType(ResourceDescriptor.TYPE_JRXML); jrxmlDescriptor.setName(reportName); jrxmlDescriptor.setLabel("Report Label_" + reportName); jrxmlDescriptor.setDescription("Main jrxml_"+reportName); jrxmlDescriptor.setIsNew(true); jrxmlDescriptor.setHasData(true); jrxmlDescriptor.setMainReport(true); rd.getChildren().add(jrxmlDescriptor); File jrxml = new File("/sites/launchcomm/app/reports/" + resName +".jrxml"); srv.getWSClient().addOrModifyResource(rd,jrxml); } The program get compiled successfully. When i try to run the program then i got the following error: java.lang.Exception: 6 - No URI given at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.modifyReportUnitResource(WSClient.java:500) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.addOrModifyResource(WSClient.java:440) at PutReportResourceOnServer.putReportUnit(PutReportResourceOnServer.java:141) at PutReportResourceOnServer.main(PutReportResourceOnServer.java:75) Exception in thread "main" java.lang.Exception: 6 - No URI given at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.modifyReportUnitResource(WSClient.java:500) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.addOrModifyResource(WSClient.java:440) at PutReportResourceOnServer.putReportUnit(PutReportResourceOnServer.java:141) at PutReportResourceOnServer.main(PutReportResourceOnServer.java:75) FROM THE ERROR I COME TO KNOW THAT SOME URI IS MISSING. WHAT I HAVE TO SET FOR MAIN REPORT'S URI? OR ERROR IS OCCURRED DUE TO SOME OTHER REASON? PLEASE HELP ME SOLVE MY ERROR :) Regards, TheVoice

Hello there, The error related to resource not found is get solve. After tracking execution of my report from ruby application i find that resource name from my ruby application to my java program is not pass properly. So i correct it and my error get solved :) Regards, TheVoice

Hi lucianc, Thank you very much for your reply :) Well,from my ruby application,i try to update existing resource. When i run java program from command prompt then its run without giving any error and also update resource on the server. Problem comes when i run my java program from ruby on rails. SO,PLEASE HELP ME TO SOLVE THIS ERROR :) Regards, TheVoice

Hello there, i have ruby application in which i have to generate report from jasperserver Following is my java code which puts jrxml on server: public static void putJRXMLOnServer(JServer srv,String resourceName) throws Exception { ResourceDescriptor rdis = new ResourceDescriptor(); rdis.setResourceType(ResourceDescriptor.TYPE_JRXML); rdis.setName(resourceName); rdis.setLabel("TestJRXMLLabel"); rdis.setDescription("Test JRXML Description"); rdis.setParentFolder("/reportResources"); rdis.setUriString(rdis.getParentFolder() + "/" + rdis.getName()); rdis.setWsType(ResourceDescriptor.TYPE_JRXML); File jrxml = new File("/sites/launchcomm/app/reports/Report.jrxml"); rdis.setHasData(true); rdis.setIsNew(false); // rdis.setIsNew(true); srv.getWSClient().addOrModifyResource(rdis, jrxml); } When i run my java program ruby on rails application then i get the following error: java.lang.Exception: 2 - The resource was not found at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.modifyReportUnitResource(WSClient.java:500) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.addOrModifyResource(WSClient.java:440) at MyDynamicReport.putJRXMLOnServer(MyDynamicReport.java:226) at MyDynamicReport.main(MyDynamicReport.java:73) Exception in thread "main" java.lang.Exception: 2 - The resource was not found at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.modifyReportUnitResource(WSClient.java:500) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.addOrModifyResource(WSClient.java:440) at MyDynamicReport.putJRXMLOnServer(MyDynamicReport.java:226) at MyDynamicReport.main(MyDynamicReport.java:73) WHAT IS REASON FOR SUCH ERROR? I AM UNABLE TO FIND THE REASON FOR SUCH ERROR. Regards, TheVoice

Hello Lucianc, Can you tell me how to escape '$' characters to get proper .jrxml output from the velocity? Actually i don't understand how to preserved '$' character in .jrxml file.so can you give some more information related to it Thank you, thevoice.

Hello there, I have to generate dynamic reports using ireport and jasper server.After searching on google,i come to know about velocity which allows to generate reports templates dynamically. I am new to velocity so as try i have created dummy .jrxml file which have velocity code to generate columns dynamically. When i have tried to upload this dummy .jrxml file on jasper server then i get validation message like "The selected Jrxml could not be parsed." Can anybody tell me the reason of such validation message? Or can anybody tell me how to generate and compile .jrxml file along with velocity to generate dynamic reports? What i have to do to generate dynamic reports using ireport and jasper server along with velocity? Something more information... To generate reports,field selection is done by user. Thank you, thevoice. Post edited by: thevoice, at: 2008/04/22 07:20

Hello tfr, From your post i come to know that you have used velocity to generate dynamic columns in jrxml. Can you post your sample code of it? As i have to generate reports with dynamic columns.Also i have search on google about velocity and jaspers.But failed in getting proper way for reports. Can you post your sample code with bit explanation so that i can get some guidance from it. Or can you suggest me that how i can combine velocity and jrxml so that i can create dynamic reports from it. Thanks in advance, by, thevoice.

Hello swood, Thank you very much for your reply. Please can you explain me what is the mean of "HTML output is not layered,while PDF and other output is". Is it possible to display report from JS in HTML format? If so, then how? Thank you.

Hello ther, Can anyboy tell me what i have to do to display report in html format from the jasper server. Well i have used iReport's templates to design my reports. For knowledge,i also want to know the reason for reports that not properly displayed in html format Please i need a help to solve this problem. Thank you

Hi silenco, I am uploading .jrxml file that is designed using iReport tool. My report work fine when i run it in iReport. But when i upload the same .jrxml file in jasper server and run it using text input control,it show me "The report is empty." Can you explain what is reason for such as i am unable to get it. What i have to do to run report using input control? What query i have to set run report? Following is query that i used to run report: SELECT first_name,last_name,email_addr FROM contacts WHERE first_name!='' AND last_name!='' AND last_name=$P{LAST_NAME} Thank you.

Hello ther, First of thanks for the reply. From the link that given in reply,i found the examples were in php and jsp. Well i need the help for jasperserver web services in ruby on rails so that i can solve my problem "Unable to open document:Unhandled mime type:application/xml" Please anybody can help me to solve this problem. Or can anybody can tell me what is reason for such problems.

Hello MariusAgricola, Really Thank you very much for this great work. I am looking in google for long how to integrate jasper in ruby. From your work i able to get idea for how to integrate japser in ruby. Here i need your help. I have tried to integrate japser in ruby using your code. But i got the error. Following is more information: -- In ruby application i list the reports that resides on jaspserserver repository. -- I have installed JasperIntelligence1.0.1. -- Error Details: REXML:: ParseException in ReportController#index Missing end tag for 'HR' (got "body") Line: Position: Last 80 unconsumed characters: </html> Full trace: /usr/lib/ruby/1.8/rexml/parsers/baseparser.rb:315:in `pull' /usr/lib/ruby/1.8/rexml/parsers/streamparser.rb:16:in `parse' /usr/lib/ruby/1.8/rexml/document.rb:185:in `parse_stream' /usr/lib/ruby/gems/1.8/gems/soap4r-1.5.8/lib/xsd/xmlparser/rexmlparser.rb:27:in `do_parse' /usr/lib/ruby/gems/1.8/gems/soap4r-1.5.8/lib/soap/parser.rb:102:in `parse' /usr/lib/ruby/gems/1.8/gems/soap4r-1.5.8/lib/soap/processor.rb:39:in `unmarshal' /usr/lib/ruby/gems/1.8/gems/soap4r-1.5.8/lib/soap/rpc/proxy.rb:285:in `unmarshal' /usr/lib/ruby/gems/1.8/gems/soap4r-1.5.8/lib/soap/rpc/proxy.rb:184:in `route' /usr/lib/ruby/gems/1.8/gems/soap4r-1.5.8/lib/soap/rpc/proxy.rb:143:in `call' /usr/lib/ruby/gems/1.8/gems/soap4r-1.5.8/lib/soap/rpc/driver.rb:181:in `call' (eval):6:in `list' app/models/reports.rb:21:in `get_list' app/controllers/report_controller.rb:22:in `index' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in `send' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in `perform_action_without_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/filters.rb:632:in `call_filter' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/filters.rb:619:in `perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue' /usr/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/rescue.rb:83:in `perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:430:in `send' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:430:in `process_without_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/filters.rb:624:in `process_without_session_management_support' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/session_management.rb:114:in `process' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:330:in `process' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/dispatcher.rb:41:in `dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/webrick_server.rb:113:in `handle_dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/webrick_server.rb:79:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/lib/ruby/1.8/webrick/server.rb:92:in `each' /usr/lib/ruby/1.8/webrick/server.rb:92:in `start' /usr/lib/ruby/1.8/webrick/server.rb:23:in `start' /usr/lib/ruby/1.8/webrick/server.rb:82:in `start' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/webrick_server.rb:63:in `dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/commands/servers/webrick.rb:59 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:495:in `require' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:342:in `new_constants_in' /usr/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/active_support/dependencies.rb:495:in `require' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/commands/server.rb:39 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' script/server:3 Please can you tell me what is reason for this kind of error. Am i missing anything in installing Jasperintelligence? What you have installed to use jasper in ruby? (I mean i wanna to know that which jasperintelligence version u have used?) What i have to do to solve this problem? Please help me in solving my this problem. Thank you

Post edited by: thevoice, at: 2007/11/23 10:53