jbchurn

Hi, I use iReport 3.7.0 and below seems to work for me. SELECT CODE, NAME FROM CLIENTS WHERE CODE = $P{clientCode} AND $P!{countryCodes} So, you will pass "country IN (1,2,3)" without quotes to parameter countryCodes. HTH.

Hi, I'm new to JasperAnalysis. May I know if is there a community edition of JasperAnalysis that we can download for use? So far I only found JasperAnalysis workbench in JasperForge. Thanks.

Looks like it's really hard to find someone to provide advice on creating jasperserver database script in Oracle.

Hi, I have following tables. collection_20081101 collection_20081102 collection_20081103 collection_20081104 collection_20081105 How to specify the table name that is only known at runtime in report's SQL during design time? The table name will be get from the runtime parameter. Please advise. Regards, Jap.

Hi Mary, I do aware of that, but I'm on the JasperServer Community Edition. So, I don't have the script. Thank you.

Hi Kitakura, When I click on the attachment, the file I download is empty. Between, can you teach me how you generate the script in Oracle? Would like to learn from you for my future use. Thank you.

Hi, Thanks for your advice and I will consider it. Between, since you use Oracle as JasperServer core database before, can you advise me how to generate the sql script for Oracle database? I try to following some thread to build from source, but I still yet to find the script. Your advice is very much appreciated. See my thread on this topic. http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=46448 Thanks.

Hi, Is there any JasperServer developer that can advise me where will the Oracle database script for JasperServer be generated after building the source? Really hope to get some advice so that I can proceed, appreciate that. Thanks.

Between, it seems like the maven repository at http://repo1.maven.org/maven2/ojdbc/ojdbc/14/ does not contain the Oracle JDBC driver file.

Hi, How to configure this forum to send email notification to me when someone has replied my thread? Thanks.

Hi, I learn from maven.apache.org/ref/2.0.4/maven-settings/settings.html that I need to add proxies configuration as below in the provided settings.xml. Can anyone advise me where will the Oracle database script for JasperServer be generated after building the source? Thanks. Code: <proxies> <proxy> <active>true</active> <protocol>http</protocol> <username>myusername</username> <password>mypassword</password> <port>9000</port> <host>1.2.3.4</host> </proxy> </proxies>

Hi, My PC is behind a proxy server, where can I specify the connection settings? I think it can't connect to Internet to download. Please advise. Thank you.

Hi, I think I have some missing files, that's why am getting some errors as below when try to build it. According to Section 4.1 "Use Pre-populated Maven Repository 3rd Party Jars (Optional)" in JasperServer Source Build Guide.pdf, there's this file jasperserver-<ver>-maven-repository.zip Can anyone share with me where can I download this file? Thanks. Code:[iNFO] ------------------------------------------------------------------------[ERROR] BUILD ERROR[iNFO] ------------------------------------------------------------------------[iNFO] Error building POM (may not be this project's POM).Project ID: org.apache.maven.plugins:maven-clean-pluginReason: POM 'org.apache.maven.plugins:maven-clean-plugin' not found in repository: Unable to download the artifact from any repository org.apache.maven.plugins:maven-clean-plugin:pom:2.2from the specified remote repositories: codehaus-plugins (http://dist.codehaus.org/), Repo1 Maven (http://repo1.maven.org/maven2/), codehaus-plugins2 (http://repository.codehaus.org/), JasperForge Maven Repository (http://www.jasperforge.org/maven2), Maven Snapshots (http://snapshots.maven.codehaus.org/maven2), central (http://repo1.maven.org/maven2), js-repo-svn (file:/C:/Tools/JasperSoft/JasperServer/jasperserver-3.0-src/jasperserver-repo) for project org.apache.maven.plugins:maven-clean-plugin

I found the following thread that contains information on building DDL for different database from source code. http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=44640

Hi Gabriel, Have you try look into the its install guide? Not sure what edition you have, but for the JasperServer Community Edition 3.0, you can refer to Appendix C: Java 1.6 JVM Settings in the JasperServer-Install-Guide.pdf HTH.