mpetek
-
Posts
17 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by mpetek
-
You need to put the sqljdbc.jar (http://msdn.microsoft.com/en-us/library/ms378526.aspx) into the \platform9\lib (at least that's for 3.7.3) directory. Then use a connection string similar to this one: jdbc:sqlserver://192.168.1.123\SQLEXPRESS;databaseName=master;SelectMethod=cursor Don't forget to copy the jar onto the jasperserver as well ...
-
Try the $P!{parameter_name} syntax, this will pass the parameter value directly. regards
-
Hi all, for performance improvement, I'd like to use Oracle hints in the main report query. Unfortunately they don't seem to take effect. In an older post no one really answered that question directly jasperforge.org/plugins/espforum/view.php. So, the question is: Can I use Oracle hints with iReport/Jasperserver? We are using the oracle.jdbc.driver.OracleDriver (ojdbc14.jar). thanks
-
Use the correct pattern for the text field, e.g. yyyy/MM/dd
-
First you need to add input controls to the report and second you need to set the reports' property "Always prompt" for the input controls. regards
-
Why are you not using two category series in a single bar chart instead of the multi-axis chart? Am I missing something?
-
I have the same problem and using compatibility 3.0.0 doesn't help either. My problem is that the charts always add the code below into the jrxml file when using rotated labels which raises the this error message: 1 - org.xml.sax.SAXParseException: cvc-complex-type.3.2.2: Attribute 'labelRotation' is not allowed to appear in element 'categoryAxisFormat'. Any ideas? Code: Post Edited by mpetek at 05/18/2010 08:42
-
Is it possible to create this type of chart with iReport? Example: /uploads/projects/ireport/image/gantt_example.jpg The colored areas should be specified by begin and end datetime, the colors should be set from the datatable. With a gantt chart, I cannot place the different tasks into a single bar. Is there a way to "flatten" a gantt chart to a single bar or can this somehow be achieved with a stacked bar chart? thanks in advance, michael
-
Hi, I don't think it's possible for pdfs ... but an example for opening a new report by clicking on a bar of a simple bar chart, use this: Open chart data, edit the category series and on the item hyperlink tab use the ReportExecution in the hyperlink type list. The reference should be the report name and you can also add all the link parameters needed for the report to be opened. best regards, mpetek
-
I suffer from this as well, it seems overlapping items are not properly displayed in the HTML preview (but in PDF everything's fine). I guess the textfields are "in front" of the lines and or shapes and thats why you don't see them. greets
-
thanks the preview button is so convenient that I totally forgot about the "run report unit" ...
-
just a quick and easy question: Dragging an image from the repository onto a report leads to the following error in iReport-nb 3.5.2: Error filling print... Byte data not found at location : repo:/common/images/logo net.sf.jasperreports.engine.JRException: Byte data not found at location : repo:/common/images/logo at net.sf.jasperreports.engine.util.JRLoader.loadBytesFromLocation(JRLoader.java:488) While it is rendered on the jasperserver page in the browser without any problem. What am I missing? regards
-
oh! with ireport-nb 3.5.2 it is there again. thanks everyone ;)
-
Really sad this is missing, was really nice and convenient. Will this be available again?
-
Dear whoever reads this, apparently it is futile to ask anything regarding charts (except pie charts) in this forum. So can anyone tell where to get the information? best regards, michael
-
Hi all, I've been working with iReport some time now, here some questions I haven't found an answer yet: 1.) Multi-axis chart: How can I align 2 overlayed charts correctly? If for a bar chart the maximum value is 65% and an overlayed line chart the maximum is 15%, both are drawn at the same height! 2.) How to set the axis minimum/maximum value range of any chart? Like it should always show up to 100% ... 3.) Is there any book, document or forum (besides jfree.org) where I can find detailed information on chart reports? thanks in advance, michael
-
Hi there, I have the same problem and in need of a solution. Additionally, how can I set the same maximum value for charts in a multi-axis chart? thanx in advance, michael
