javydreamercsw

Is there a documented approach to using JPA and iReports? I'm planning on use such approach in my project.

I've seen JPA datasources and related stuff but I'm missing an example of running a report provided a JPA EntityManager. Anyone has a link?

Version 3.0 still has its issues, which the beta testers are going thru, but there's always a data base script for it. If you 're using the installer it'll reset the database so you'll need to backup that one first, then recover from back up. If you're using the war file is easier to update IMO. Just replace the war in the web server and run the update db script before re-starting.

Found a rather critical error. See the next issued for details: http://jasperforge.org/sf/go/artf3188?nav=1 P.S. I'm assigning the bugs to you Marina, hope it's the right thing to do. Post edited by: javydreamercsw, at: 2008/04/23 05:23

Share your happiness. Sadly I've already filed a bug in the creation user window. Valid emails which nowadays might have more than one '.' are interpreted as invalid. Maybe the validation has the amount of '.' into account. Did the database changed at all?

I did a while ago, just forgot about posting here. http://jasperforge.org/sf/go/artf3156

Change info in: <tomcat>webappsjasperserverMETA-INFcontext.xml

Verify that the jasperadmin user is properly created, has grant access to the database and the password is correct.

Somewhere at the start of the command prompt (the one that says tomcat) its displayed the port being used. Use an URL like this one: http://localhost:<port i.e. 8080>/jasperserver. The command prompt you pasted info from should open another command prompt. If not the port (8080) must be being used by other application.

Any update on this? I'm impatiently waiting to get my hands on the new version.

Thanks for the ireport.jar pointer. It fixed all problems. I missed that one when upgrading jasper server to 2.0.5.

Does the Hierarchy name you mention have any format? I named them as the Dimension (i.e. Time) but now I guess the following error from the workbench: 10:33:58,606 ERROR [QueryPanel] Exception: null java.lang.NullPointerException at mondrian.rolap.HierarchyUsage.init(HierarchyUsage.java:364) at mondrian.rolap.HierarchyUsage.<init>(HierarchyUsage.java:199) at mondrian.rolap.RolapCube.createUsage(RolapCube.java:1242) at mondrian.rolap.RolapCube.createUsages(RolapCube.java:1194) at mondrian.rolap.RolapCube.<init>(RolapCube.java:153) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.QueryPanel.connectButtonActionPerformed(QueryPanel.java: 276) at mondrian.gui.QueryPanel.access$000(QueryPanel.java:51) at mondrian.gui.QueryPanel$2.actionPerformed(QueryPanel.java:150) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour ce) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) This happens when opening a new MDX query. Attempting to connect from the windows creates the same error.

I'm preparing to test your suggestion. Besides that does the schema looks ok?

Following thread: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=38598 Jasperserver is now running reports created/compiled with iReport 2.0.5. After the change I've noticed a different behavior with non mandatory fields in the report parameters. In the previous version when you didn't provide a value of a non-mandatory field (i.e. select the empty space in a drop down control) the report was ran against the report's default parameters, which I set to '%' using like statements. It worked perfectly. After the lib switch when you don't provide a value the same report returns an empty result/report message. My concussion: the jasperreports engine interprets the sent value (dunno what the control sends, a null or "" perhaps) and uses that as parameter causing a statement like mine (i.e. using like $P{parameter}) translate into something like "... like ''" which obviously gets an empty result. Is this a bug?

I'm basically learning in the process so please bear with me... I've been learning on my own about data warehouses and so on. Already have my draft of the structure and is partly being populated with Talend. I have the fact table and 3 dimensions already there so I wanted to go ahead and start testing with the workbench. I'm trying the following query: select {[Measures].[amount]} on columns,{[Product].[description]} on rows from [Quality] on this schema: <Cube name="Quality" caption="" cache="true" enabled="true"> <Table name="production_fact" schema="" alias=""> </Table> <Dimension type="StandardDimension" usagePrefix="" foreignKey="lot_id" name="Lot"> <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="lot_id" primaryKeyTable="lot" caption=""> <Table name="lot" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="TimeDimension" usagePrefix="" foreignKey="Time_key" name="Time"> <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="Time_key" primaryKeyTable="time" caption=""> <Table name="time" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" usagePrefix="" foreignKey="product_key" name="Product"> <Hierarchy name="New Hierarchy 0" hasAll="true" allMemberName="" allMemberCaption="" allLevelName="" primaryKey="product_key" primaryKeyTable="product" defaultMember="" memberReaderClass=""> <Table name="product" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="complaint_key" name="Complaint"> <Hierarchy name="New Hierarchy 0" hasAll="true"> <Table name="complaint" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="defect_key" name="Defect" caption=""> <Hierarchy name="New Hierarchy 0" hasAll="true"> <Table name="defect" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="exception_key" name="Exception" caption=""> <Hierarchy name="New Hierarchy 0" hasAll="true"> <Table name="exception" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="loc_key" name="Location" caption=""> <Hierarchy name="New Hierarchy 0" hasAll="true"> <Table name="localization" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Measure name="amount" column="amount" datatype="Numeric" formatString="" aggregator="sum" formatter="" caption="" visible="true"> </Measure> </Cube> And this is the error: Mondrian Error:Failed to parse query 'select {[Measures].[amount]} on columns,{[Product].[description]} on rows from [Quality]' Mondrian Error:Error while parsing MDX statement 'select {[Measures].[amount]} on columns,{[Product].[description]} on rows from [Quality]' Mondrian Error:MDX cube 'Quality' not found Any idea? Thanks in advance! P.S. I'm in the process of reading the Mondrian documentation tat ships with the workbench and IMO both the schema and the query are correct. But since these are my first steps I guess I'm wrong.

The correct tool is Jasper Analysis workbench. Look under jasperserver downloads (I think in version 1.2.1)

How do you refer to the subreports? using repo: in the subreport properties?

It worked for me. I removed the iReport.jar there with the one from 2.0.5 and added the following jar as well: jasperreports-flash-2.0.5.jar, just in case. I just deployed a report compiled in 2.0.5 (Compatibility latest) and was able to run it from both iReport (running from server using the plug in) and from jasperserver webpage. Didn't do anything besides the stuff described in this post.

It turns to be a versioning issue. JasperServer has 2.0.2 and it needs 2.0.5. Just updated the jars in the server and looks good so far. I'll keep testing and let you know. Thanks!

Just recompiled and deployed from scratch the report while maintaining compatibility with 2.0.4 and still getting the same result.

Tried to run a report upgraded from iReport 2.0.4 to 2.0.5 and get the following error when attempting to run it: org.xml.sax.SAXParseException: Element type "pen" must be declared I assume this is related to the warning that pops out when opening old reports in version 2.0.5. Any workaround for this besides changing compatibility setting in iReport?

In the same line, can you provide a query to enable the skip if empty check mark when scheduling reports? Thanks in advance!

Correction! The jsp name switch worked perfectly! Had to remake the war file with the change for it to work (and obviously redeploy). Seems that it was overwritten by the server after a restart. Thanks to all. kkelleher fix worked!

Sadly it didn't work. The server is looking for http://<server>:8080/jasperserver/login.html Restarted the server just in case but no luck.

Download JasperServer from the download section. It includes the manuals and guides you'll need to get started. Give it a try and feel free to comeback with more specific questions.