alaa56mm

Dears.. i saw the JasperServer demo for Ad-Hoc reporting... but in that case u should do the topics using JasperStudio(IReport), so the end user should write the select query ,,, but this is not the ad-hoc report needed, because i saw that i should(as end user) select the business views(like tables) and do the select and join and add where conditions as i like,(ALLL OF THIS WEB-BASED)...so i can NOT do it in JasperServer , Right?? Post edited by: alaa56mm, at: 2008/02/09 10:37

Dears.... I have questions: 1)-How can i have the summery of the webinar between jasperforeg and oracle-e business suite? 2)-Can i find in this new version new ad-hoc feature that i can select any table i want from specified schema (Database) , and add table-joins, calculations..functions....etc? without need to Jasper Studion or IReport? Regards

oh ..thanks dear for your information.

Thank You.. but i did read the documentation about JasperServer , i saw that you should upload the jrxml to the topic, so i should use ireport to do the sql query and select the fields,right? because i thought that in JasperServer ,i can do something like select which table(s) you should have, which field you should have ...etc, all of this at Web-UI, without need to IReport.. help me plz? regards Post edited by: alaa56mm, at: 2007/12/04 13:04

Dear Jasper forge Team.. i want to use the jasper server pro, but before buying it..i want to answers to my questions please: 1)- Can Jasper Server pro use oracle Database instead of mySQL? 2)- Can the ad hoc reports generate custom reports that i need, for example:i need a report that can use data from many tables,use joins, use calculation...etc, all that in ad hoc reports on jasper server pro, can i do it? and please give me the technical support mail... Regards Post edited by: alaa56mm, at: 2007/12/02 17:02

Dears.. how add-hoc reports works? and how can i pick the tables i want to use in add-hoc reports... Regards

Dears. we hacve a security in our system, so that we do NOT use the security in the JasperServer, can we import /existing Security System into JaspeServer Security usig WebService? Regards Post edited by: alaa56mm, at: 2007/09/02 08:22

how can i do that?

Dear.. should i use mySQL in JasperServer? we are not using mySQL in our Application? our database is Oracle 10g Database ? because i see that the repository like":quartz tables are mySQL Table? regards

Dears.. i have the JasperServer SourceCode, but how can i import it into an IDE? regards

Dear jshih.. how can i build without .m2/settings.xml,i can not delete it ?right?

Dears.. What is the diffidences between JasperServer commercial and JasperServer OpenSource versions? and what about add hoc reports? can i found it in open source version? Regards

ok, you can see this exception instead seeing it from attached file: Code:+ Error stacktraces are turned on. [iNFO] NOTE: Maven is executing in offline mode. Any artifacts not already in your loca l repository will be inaccessible. [iNFO] Scanning for projects... [iNFO] Reactor build order: [iNFO] Jasper Server [iNFO] Jasper Server API [iNFO] Jasper Server API - Common [iNFO] Jasper Server API - Metadata Interfaces [iNFO] Jasper Server API - Engine [iNFO] Jasper Server API Implementations - Common [iNFO] Jasper Server API Implementations - All [iNFO] Jasper Server API Implementations - Metadata [iNFO] Jasper Server API Implementations - Engine [iNFO] Jasper Server Hibernate Mappings [iNFO] JasperServer Export Import Tool [iNFO] JasperServer Jar for Webapp [iNFO] JasperServer Common Webapp [iNFO] JasperServer Web application [iNFO] Web Services iReport Plugin Client Code [iNFO] ------------------------------------------------------------------------- --- [iNFO] Building Jasper Server [iNFO] task-segment: [clean, install] [iNFO] ------------------------------------------------------------------------- --- [iNFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [iNFO] ------------------------------------------------------------------------ [iNFO] The plugin 'org.apache.maven.plugins:maven-clean-plugin' does not exist o r no valid version could be found [iNFO] ------------------------------------------------------------------------ [iNFO] Trace org.apache.maven.lifecycle.LifecycleExecutionException: The plugin 'org.apache.m aven.plugins:maven-clean-plugin' does not exist or no valid version could be fou nd at org.apache.maven.lifecycle.DefaultLifecycleExecutor.verifyPlugin(Defa ultLifecycleExecutor.java:1286) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.getMojoDescriptor (DefaultLifecycleExecutor.java:1522) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.bindLifecycleForP ackaging(DefaultLifecycleExecutor.java:1016) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.constructLifecycl eMappings(DefaultLifecycleExecutor.java:980) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(Defau ltLifecycleExecutor.java:458) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHan dleFailures(DefaultLifecycleExecutor.java:311) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegmen ts(DefaultLifecycleExecutor.java:278) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLi fecycleExecutor.java:143) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:334) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:125) at org.apache.maven.cli.MavenCli.main(MavenCli.java:280) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) at org.codehaus.classworlds.Launcher.main(Launcher.java:375) Caused by: org.apache.maven.plugin.version.PluginVersionNotFoundException: The p lugin 'org.apache.maven.plugins:maven-clean-plugin' does not exist or no valid v ersion could be found at org.apache.maven.plugin.version.DefaultPluginVersionManager.resolvePl uginVersion(DefaultPluginVersionManager.java:228) at org.apache.maven.plugin.version.DefaultPluginVersionManager.resolvePl uginVersion(DefaultPluginVersionManager.java:90) at org.apache.maven.plugin.DefaultPluginManager.verifyPlugin(DefaultPlug inManager.java:166) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.verifyPlugin(Defa ultLifecycleExecutor.java:1257) ... 18 more [iNFO] ------------------------------------------------------------------------ [iNFO] Total time: 1 second [iNFO] Finished at: Sun Aug 19 09:13:19 GMT+02:00 2007 [iNFO] Final Memory: 1M/3M [iNFO] ------------------------------------------------------------------------ Post edited by: alaa56mm, at: 2007/08/19 06:07 Post edited by: alaa56mm, at: 2007/08/19 06:10

iam using maven-2.0.7 , is it a problem by using latest version?

Dear JasperForge Team.. i did post on this forum 3 days ago (about how to send reports via email),but the problem still. So , i did get the Source Code from SVN Repository, and want to re-build it, so that i want to use an IDE( like Eclipse) to import it, but i could not to import the source code.and when using Maven i got an exception(see the attached file to see it). 1)-the building using maven is painfully. 2)-how can i import the source code using an IDE.. Regards Post edited by: alaa56mm, at: 2007/08/19 05:52

Dear .. the applicationContext-report-scheduling.xml read the configuration from js.mail.properties , and what i should do in the applicationContext-report-scheduling.xml Regards

Dear ... I have a problem, when scheduling a job to execute a report , i have a problem in sending that report by email, i want to send that report to my gmail account,and i did the setting on : <jasper_intalation> <tomcat> webapps jasperserver WEB-INF js.mail.properties: as the following: Code:report.scheduler.mail.sender.host=smtp.gmail.com report.scheduler.mail.sender.username=alaa56mm report.scheduler.mail.sender.password=mypasswd report.scheduler.mail.sender.from=alaa56mm@gmail.com report.scheduler.mail.sender.protocol=smtp report.scheduler.mail.sender.port=465 and i got exception as follows: javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, p ort: 465; nested exception is: java.net.ConnectException: Connection timed out: connect at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1282) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:37 0) at javax.mail.Service.connect(Service.java:275) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailS enderImpl.java:382) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSen derImpl.java:335) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSen derImpl.java:331) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecut ionJob.sendMailNotification(ReportExecutionJob.java:595) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecut ionJob.sendToDestinations(ReportExecutionJob.java:357) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecut ionJob.executeAndSendReport(ReportExecutionJob.java:278) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecut ionJob.execute(ReportExecutionJob.java:148) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j ava:520) Caused by: java.net.ConnectException: Connection timed out: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:516) at java.net.Socket.connect(Socket.java:466) at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:232) at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:189) at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1250) ... 11 more Post edited by: alaa56mm, at: 2007/08/12 09:59 Post edited by: alaa56mm, at: 2007/08/12 11:38

hi all.. when i using JRFileVirtualizer , i should put the cached (or Serialized ) files on temp directory,is there any option delete the temp files?or i should delete it manually?? regards

thank yo man...B)

Dear all... when i have a .jasper file , and i don't have its source, how can i decompile this jasper file to its source.. Regards

Dear all... I'am using Jasper Reports with IReport..and iam using JRFileVirtualizer as: Code:JRFileVirtualizer fileVirtualizer = new JRFileVirtualizer(3,fullPathOfCachedDIR);... my question is: 1)-does this code make some thing like paging so that i can not retieve all data at once..?? 2)-how can i remove the temp file generated by JRFileVirtualizer.......... Regards Post edited by: alaa56mm, at: 2007/05/23 11:15

dear all.. i found this in sourceforge project: , so it enable you to call Oracle Stored Procedures from jasper report... any one use this earlier Post edited by: alaa56mm, at: 2007/05/17 13:13

Hello all... Iam using IReport for Jasper Report....and i am exporting my reports to pdf,excel and html.. BUT when exporting to html ,some erports retrieve more than 80,000 records,so the browser hanged.. the question is: How Can I Use something like paging in html reports ,so that will give me 25 records, then when click on next button ,it will give me the other 25 records,and so on... imean some thing like display tag : http://displaytag.sourceforge.net/11/ :whistle:

hello all.. we are moving from Oracel Report to Jasper reports in our company..and we will migrate about 100 Report from Oracel To Jasper... but the problem is that some of Oracel Reports Use Stored Procedures and others use (select statement) for each column.... 1)-if i can use select stament for each column without use of subreport??????:whistle: 2)-id i can use Stored Procedure to get data and filling the report

hi all.. i have a case in my report..Depends on some condition in the data retrieved i should to go to next page and continuo and so on .. for exaple when select statement Retrieve data grouped by bankCode,,when this bankCode changed , i should go to new page.. any help????????