Mohan

Hi, I am new to jasperintelligence-1.1.0 and iReports-1.2.7. I have jasperintelligence-1.1.0 and iReports-1.2.7 on my system(Windows XP). I am able to login to jasperserver page and I am able to access the repository. I am able to create a basic report using the jrxml file created using iReport. I am able to work with the report wizard of iReport also. But still I am stuck up with a doubt of what is the actual procedure of creating a good report using these two(JI and iReport). So I need help from someone who has created formatted reports successfully. Can you just give me the step by step guidlines regarding the correct usage of JI-1.1.0 and iReport-1.2.7? I will be really thankful to you. Thanks, Mohan.

Hi Guillo, First I created a query in JI (Administrator->Repository->Add Query). Then I created one data source. Then I created one .jrxml file also. Finally I created one report unit with all the three. I was able to get the report, but not with all the fields I selected. So in this regard, I need your guidance. Step by step procedure to create a JI report. Then I installed iReport -1.2.7. I started the application, I am able to add the server. In the repository, I was getting all the report units I created with JI. But when I try to create a report unit in iReport, I am not able to do that. So I am basically trying to get the report on JI as well as iReport. One more doubt. Do we need to write the code for .jrxml? or is there any user interface between user and the .jrxml file? Please do let me know. Thanks for the help. Regards, Mohan giulio wrote: Hi Mohan what query are you tring to create? JI query? How do you try to execute the report? On the sever? In ireport? From the plugin asking for a remote execution? Thanks Giulio

Hello, I have installed iReport-1.2.7 with JasperIntelligence-1.1.0. I am able to start the iReport, and I am also able to create the report unit. But I am not able to create the query. And I anm not able to get any data in the report. Can anyone please tell me what are steps to create a report in iReport? Thanks, Mohan.

Hi, 1. I am creating one query with the following query: [select course_cd, course_nm, first_nm, last_nm from courses, instructors;] 2. I am also creating one data source which connects to the database having the above 2 tables (courses and instructors). 3. Then I created one .jrxml file which has the following contents: <?xml version="1.0"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Database_Report"> <field name="course_cd" class="java.lang.String" /> <field name="course_nm" class="java.lang.String" /> <field name="first_nm" class="java.lang.String" /> <field name="last_nm" class="java.lang.String" /> <detail> <band height="20"> <textField> <reportElement x="10" y="0" width="600" height="20" /> <textFieldExpression class="java.lang.String"> <![CDATA[$F{course_cd}]]> </textFieldExpression> </textField> <textField> <reportElement x="80" y="0" width="200" height="20" /> <textFieldExpression class="java.lang.String"> <![CDATA[$F{course_nm}]]> </textFieldExpression> </textField> <textField> <reportElement x="280" y="0" width="200" height="20" /> <textFieldExpression class="java.lang.String"> <![CDATA[$F{first_nm}]]> + " " + <![CDATA[$F{last_nm}]]> </textFieldExpression> </textField> </band> </detail> </jasperReport> 3. Finally I created one report unit with above query and the datasource and the jrxml file. I am able to get the report. But the problem is I am not getting all the fields. I am getting only the course_nm and the first_nm field. Can anyone suggest me with a solution? I will be really thankful. Mohan.

Hi, I had installed Jasper Intelligence-1.1.0. Can any one please let me know how do I work with Reports. What are the plugins I require for that? Thanks in advance. Mohan.

Hello LucianC, Now I am getting the login screen of JasperIntelligence. Thank you so much for your guidance. I modified the "ResourceParams...> code as you specified. It is working now. Thank you once again, Mohan. lucianc wrote: You'll need to adapt the web app context.xml file to use the Tomcat 5.0 syntax (JasperServer ships with a Tomcat 5.5 context.xml). You have to change the data source definitions to something like Code: <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/jasperserver"> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>30</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value>jasperadmin</value> </parameter> <parameter> <name>password</name> <value>jasperadmin</value> </parameter> <parameter> <name>driverClassName</name> <value>com.mysql.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:mysql://IP address of the machine:3306/jasperserver?autoReconnect=true</value> </parameter> </ResourceParams> HTH, Lucian

Hi RHancket, Thanks for the suggestion. It works. I downloaded Tomcat 5.5 and it worked. But I am not able to find 'flow.html'. Can you please let me know how do I configure JasperIntelligence to work with Jasper Reports? I have jasperreports-1.2.7 and jasperintelligence-ireport-plugin-1.1.0. Can you please tell me how do I configure this so that I can start work on reports. Thank you once again, Mohan. rhancke wrote: Hi Mohan. You need to follow some configurations: - Use Tomcat 5.5.x - Copy the mysql connector jar to <tomcat install>commonlib - Configure resource-ref in web.xml - Configure resource in context.xml []'s RHancke

I am using Tomcat 5.0. Do I need to have higher version? Regards, Mohan. lucianc wrote: What Tomcat version do you use? Regards, Lucian

Currently I am using Tomcat5.0. Do I need to have higher version to make JasperIntelligence work? Post edited by: mudradi.mohan, at: 2006/10/19 06:44

Hi, I have a problem in starting the jasperserver. When I run tomcat, I am getting the following erorr: Oct 18, 2006 6:17:44 PM org.apache.catalina.startup.ContextConfig applicationConfig INFO: Missing application web.xml, using defaults only StandardEngine[Catalina].StandardHost[localhost].Standa rdContext[/] Oct 18, 2006 6:17:44 PM org.apache.catalina.core.StandardHostDeployer install INFO: Processing Context configuration file URL file:D:sigmaTomcat 5.0confCatalinalocalhostjasperserver. xml 18:17:54,140 WARN JDBCExceptionReporter,main:71 - SQL Error: 0, SQLState: null 18:17:54,156 ERROR JDBCExceptionReporter,main:72 - Cannot create JDBC driver of class '' for connect URL 'null ' 18:17:54,171 WARN SettingsFactory,main:103 - Could not obtain connection metadata org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceC onnectionProvider.java:81) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBea n.java:885) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBe an.java:797) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(Abst ractAutowireCapableBeanFactory.java:860) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(Abstrac tAutowireCapableBeanFactory.java:829) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAut owireCapableBeanFactory.java:409) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:238) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:148) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(Defau ltListableBeanFactory.java:247) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.j ava:331) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRe freshableWebApplicationContext.java:155) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:240) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:178) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java :49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4343) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer.java:903) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) Can anyone please help me? Thanks in advance, Mohan.

Hi, I have downloaded the jasperintelligence1.1.0-bin.zip from sourcetorge site. I have copied the jasperserver.war file to <Tomcat-dir>/webapps/. I have created the sample databases also. I have made necessary changes in the configuration files also(catalina/localhost/jasper.xml). But I am not able to get the starting screen of jasperintelligence. Can anyone help me with a detailed instructions on how to do the installation, and getting the starting page of jasperintelligence? Thanks in advance, Mohan. Post edited by: mudradi.mohan, at: 2006/10/17 13:29