dgiulian

Hi everyone, I'm trying to create a report with a buble chart in it. I've managed to create the chart, and it's working, but in the tick labels (X and Y axes) I have a series of numbers. Those numbers correspond to an Initial and a final state. And I want to display that state name in the axis values (instead of the numbers). Is there any way I can achieve what I want? Thank you!

I made the view using the "CREATE VIEW" statement. which is working fine, but I can't select it as a fact table because it doesn't belong to any schema. So My question is, how to select that view to use it as my "fact table".

Hi everyone, I'm trying to build an OLAP cube, but instead of using a table from the database, I want to use a view created using a couple of tables from the schema. I'm using the schema workbench, and when I try to select the view to be the main table in the OLAP cube, but it is not listed, and if I type it I get an error. So, Is there any way to use a view as a table in an OLAP schema? Thanks.

Hi everyone, I'm trying to build an OLAP Cube using the Schema workbench, with the following xml <Schema name="New Schema1"> <Cube name="Familiar" caption="Familiar" cache="true" enabled="true"> <Table name="adm_familiar" schema="PUB"> </Table> <Dimension type="StandardDimension" foreignKey="empleado" name="empleado"> <Hierarchy name="New Hierarchy 0" hasAll="true" allMemberName="all emple" allMemberCaption="Todos los empleados" allLevelName="all emple" primaryKey="codigo" primaryKeyTable="adm_empleado"> <Table name="adm_empleado" schema="PUB"> </Table> <Level name="Empleado" table="adm_empleado" column="codigo" nameColumn="empnom" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" caption="Empleado"> </Level> </Hierarchy> </Dimension> </Cube> </Schema> The cube is very simple, but when I try to execute the following MDX Query : SELECT {[empleado].[all emple]} on rows from [Familiar] I get this error message: Mondrian Error:Hierarchy '[Measures]' is invalid (has no members) And I have no idea why is that, and what that error means. I would appreciate if anyone can give me a hint about how to solve this, or at least to know what I'm doing wrong. Thanks Post Edited by dgiulian at 11/16/2009 13:16

Hi everyone, I'm trying to integrate Jasperserver in an aplication that has a web interface, so that users can view reports called using the URL. But the problem is that users must login first in the aplication and then when they want to view a report they must login again in JasperServer, and thats really anoying for the users. So what I want to do is to use the user and password from the aplication to login in JasperServer without the user intervention, but I don't know if theres a way to send that data as a URL parameter. Can someone give me a hint about how to do this? Thanks.

Hi everyone, I'm trying to build a report that contains a chart with the aegean chart theme. I't works fine using iReport but when I try to compile it using my app using the jasperReports engine I get the message the following message: net.sf.jasperreports.engine.JRRuntimeException: Chart theme 'aegean' not found. So I include the following libraries from the iReport folder: jasperreports-chart-themes-3.5.2 castor-1.2But when execute it I get a very long message. 07/09/2009 10:29:56 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFO: Loading XML bean definitions from URL [jar:file:/D:/JasperSoft/iReport-nb-3.5.2/ireport/modules/ext/jasperreports-chart-themes-3.5.2.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartThemesBeans.xml] 07/09/2009 10:29:56 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFO: Loading XML bean definitions from URL [jar:file:/D:/JasperSoft/iReport-nb-3.5.2/ireport/modules/ext/jasperreports-chart-themes-3.5.2.jar!/net/sf/jasperreports/chartthemes/spring/beans/defaultChartPropertiesBean.xml] 07/09/2009 10:29:56 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions .... And it goes on for several lines. The application works fine, meaning that I can see the compiled report exported to PDF, but these "errors" are quite annoying. How can I integrate the Charts themes without getting this info messages?

mdahlman, Thanks for your reply, but I can Run Tomcat and MySql as a windows services, but the problem is that I use a JDBC driver for a Progress Database, that is in a jar file placed in common/lib within apache tomcat instalation directory. And when I start tomcat it doesn't load that .jar file. So I need to run Jasperserver, or more specific the Catalina class loader.

Hi everyone, I'm trying to setup jasperserver to run at startup, so i've placed the allctrl.bat file to be executed when windows start, but I don't want to have the Tomcat window (displaying all those weird messages) on my desktop. I've looked inside those .bat files and I think the windows open when it runs the catalina.jar file. Is there any way to start jasperserver with out that window? Thanks

Hi everyone, I'm trying to run tomcat and mysql as a windows services, (to run jasperserver 3.5.0). Both of them start without problems, and I can login in jasperserver, but when I try to run a report (Using a JDBC datasource that I added) I get the following message: com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection...big stack explaining where de error came from... Caused By: (I think this is important)java.sql.SQLException: No suitable driver found for jdbc:jdbcprogress:T:localhost:3236:hrsAparently jasperserver cannot find the jar file for the Progress JDBC Driver(located in "jasperServer_dir"\apache-tomcat\common\lib). But the odd thing is that when I start Jasperserver using the startup shortcut I have no problem, and I can run the report correctly. I have my JAVA_HOME set to "jaspersever_dir"/java. Can anyone give me a hint to solve this issue? Thanks. Post Edited by dgiulian at 09/23/2009 14:40

Hi everyone, I'm trying to build a report that contains a chart with the aegean chart theme. I't works fine using iReport but when I try to compile it using my app using the jasperReports engine I get the message the following message: net.sf.jasperreports.engine.JRRuntimeException: Chart theme 'aegean' not found. So I include the following libraries from the iReport folder: jasperreports-chart-themes-3.5.2 castor-1.2But when execute it I get a very long message. 07/09/2009 10:29:56 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFO: Loading XML bean definitions from URL [jar:file:/D:/JasperSoft/iReport-nb-3.5.2/ireport/modules/ext/jasperreports-chart-themes-3.5.2.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartThemesBeans.xml] 07/09/2009 10:29:56 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions INFO: Loading XML bean definitions from URL [jar:file:/D:/JasperSoft/iReport-nb-3.5.2/ireport/modules/ext/jasperreports-chart-themes-3.5.2.jar!/net/sf/jasperreports/chartthemes/spring/beans/defaultChartPropertiesBean.xml] 07/09/2009 10:29:56 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions .... And it goes on for several lines. The application works fine, meaning that I can see the compiled report exported to PDF, but these "errors" are quite annoying. How can I integrate the Charts themes without getting this info messages?

I'm having the same problem, and I manage to format the date using the following code. new SimpleDateFormat("yyyy-MM-dd").format($P{pdate}) The only problem is that it doesn't work whithin the SQL query :( How can I make it work in the SQL query?

Hello, I need to do a Pie chart using labels and values contained in a collection that is passed as a parameter, but I dont know how to do it. In the chart data, within the details tab, i've put $P{labels} in the label expresion field and $P{values} in the value expresion field ( labels and values are the names of the collections) but when i try to preview the report I get the following error message: Error filling print... Error evaluating expression: Source text: $P{values}

Thanks, That worked!!

I'll auto-reply. What I did was: Stop Tomcat Server Delete jasperreports-3.5.0.jar located in apache-tomcat\common\lib\ Copy jasperreports-3.5.2.jar to apache-tomcat\common\lib\ Start Tomcat Server. Post Edited by dgiulian at 08/12/2009 15:11

I'm trying to use a couple of jrxml files (that I've created using iReport 3.5.2) in Jasper Server 3.5.0 and when I try to upload it, I get the message: The selected Jrxml could not be parsed. I think the problem is because Jasper Server uses Jasper Reports 3.5.0 and the jrxml syntax is different. So I need to upgrade Jasper Reports library in Jasper Server, but I don't know what files I need to change. If someone can give me a hint I'll be more than Grateful. Thanks!

Hi everyone, I'm designing a report using iReport and I want to complete the "gap" between the end of the detail band and the start of the footer page with a vertical line. How can I do this?. I'll attach a image showing what I want to do. The red lines are what I want to add to my report. If you need more information please tell me. Thanks Post Edited by dgiulian at 08/03/2009 11:35

Hi everyone, I'm using iReport to create a report that I'm going to use later in a JAVA aplication, and I need to add a text field that gets its value from a field in the Database and complete it to a certain length usign *. For example if the value of the field is abcd and the length of the textfield must be 10 characters, then I must fill the textfield with 6 '*' abcd******. I know I can do it in JAVA using a WHILE statement, but I don't know how to do it in iReport. Please can someone give me a hint. Thanks

Thanks for your reply, but I've found a way to do it using iReport. I'll explain it so if anyone has the same problem can solve it. Select the text field and right click, In the context menu select padding and borders and assign a non zero value to the line width. Thanks again for your reply.

Thanks for your reply I tried that code, and it worked but now the box cover the text, so I can't see the values of the textfield, How can I make it transparent? Another thing, is there any way I can do it using iReport? Again, Thanks

Hello every one, I want to add a border to a textfield, but I don't want to use a rectangle arround it, is there any way I can do it? I found an attribute pen="Thin" but I can't make it work. Please, can anyone help me? Thanks

Hi everyone, I was wondering if there is some way to draw a rectangle, or any figure across multiple bands, because I want to frame a couple of group headers within a rectangle, but I don't know how to do it. Tanks