barry-cw

Convert your timestamp to num millisecs since epoch (01.jan.1970) then set the default value as new java.util.Timestamp(<nummillisecs>) To get the millisecs use: http://www.epochconverter.com/

Sounds to me like you data problems are down to SQL QUERY. Word to the wise - This is NOT an end-user non-technical product...it never has been never will be. There will always be a requirement to understand data sources and potentially SQL - this depends on how your supplier set up the jasperserver (if thats what you are using)....which I assume you are - because someone who is not technical cant be using the library... Is this complicated? Welcome to my work - its why software development is a skilled job...

Er. That doesnt fix the problem it sweeps it under the carpet. However, exporting PDFs and expecting those fonts to embed will not work.... I think this is actually a classloader issue as I get this same problem with a font extension that WORKS under Jaspersoft Studio in myeclipse.

Hi, Jasperreports print service export uses the cross platform dialog box . Unfortuately this appears to be causing SheetCollate, MediaTray and Sides attributes to be completely ignored by the job & printer. I need to resolve this. Any ideas? Cheers, Barry

Hi folks, Ill warn you now...this is wasting my life getting this working....FLAKEY doesnt even start to describe the situation....its really annoying that something this widely used and supposedly mature is soo hard to get running. I shant even start to list the number of faults Ive encountered in JasperSoft Studio....however onto the important stuff I need to work... I have an executable jar that contains my driver class, my reports reports, my image resources and so on. I have another jar containing a font extension. myjar.jar lib/fonts.jar lib also contains all required jars (as copied there using maven) The problems are horrific... 1. JasperReports wont load my reports - not found. So I use .getClass().getClassLoader.getResourceAsStream() which finds my report file and I pass this into JRLoader...solved but inelegent and already showing JasperReports seems to potentially suffer classpath issues... Status: Work-around in Place 2. Font extension Works PERFECTLY using jaspersoftstudio in myeclipse. PDFs gets fonts as required - this has validated the working effect of the font extension and the fact it works. When I load a report in a standalone class (in a jar) with the my font extension listed in the classpath as lib/blah-fonts.jar the loading fails complaining it cannot find the fonts/fonts.xml file specified in the jasperreports_extension.properties file cannot be found. Its there. The font extension WORKS in JasperSoft Studio.... To get part this error I have removed it from the lib dir (i know this will kill PDF export but I needed to move on). Status: UNresolved 3. Now running the report I appear to have an error on the servlet API java.lang.ClassNotFoundException: javax.servlet.ServletOutputStream. I am not running in a web environment and have no idea why the servlet API would be required on a standalone java application - if required this dependency really should be in maven.... Status:Work around - add servlet api 2.4 dependency to maven. (yuk). If anyone can shed light on these woes it would be much appreciated. Cheers Barry

Do you have any elements which overflow with other data below with is fixed? I found an issue wher I had overflow elements and then data fixed at teh bottom of the page - when this overflowed it seemed to cause the detail band to overflow causing a blank page.

But where would one place the break? In what panel? I need a page header and footer on the 'even pages' where the entire contents of the even page (a full sheet of A4) is static text, then the detail continuing on onto the next odd page. And the issue of having a full sheet of A4 might run into problems with band + margins exceeding page sizes? or will it work ok due to the break?

Use a print when expression on the band or item as required $V{PAGE_NUMBER} ==1

What do you need a rectangle around? The page? - use background. some contents? Use a frame set the pen width to 0.5 or 1.0. How does this relate to your question of extra space at end of detail band...?

Hi, I want to have a report where the odd page contains the report data, but the even pages to contain nothing more than static text because the report is printing duplex. How may this be achieved? Thanks!

Hi, is there anyway to use type 1 fonts and embed them in PDFs? The font extension mechanism appears to only deal with TTF fonts? Cheers, Barry

The question wasnt about TrueType Fonts - but TYPE 1 fonts. The font extension mechanism appears to support only TTF fonts...

The problem has been caused by the GUI inserting the relative path from the root of the project into the parent report. I changed the filename to just the report .jasper name (no path) and now all works.....[edit}.... no it doesnt. I have to compile the reports using maven and then it picks up the subreport OK (but wont compile a new one). maven clean and the sub report stops being picked up - it refuses to compile sub-reports on the fly when preview is used.

Hi, I have a report which contains a subreport in a maven project. Both reports are in the directory src/main/jasperreports. Both reports run correctly when previewed individually. After inserting the subreport into the main report using JSS (not editing XML), and locating the report in the workspace through the dialogs. Running the preview on the main report it compiles, asks me for the parameters as usual and then errors saying it cannot find 'src'main/jasperreports/subreport.jasper'. No great suprise - it didnt seem to compile it for some reason.... As this involves very little interference from myself I had expected this to work - but at the moment I cannot get it to preview it. I even followed the jasperssort sub report tutorial and the same actions in the tutorial (same as above) results in the same error. Any ideas? Cheers, Barry

I now also understand that subreports should be used for even small data sets like client names + addresses type stuff and invoice lines. Cheers

Hi, Im trying to produce several reports that have report metadata and then the main contents of the report list the items. For instance, take an invoice, The company data comes from one query, the customer information from another, the main invoice data from another. The main report (detail) section would be fulfilled through annother query. In the case of the first 3 queries they are all filling in one-shot metdata data where each query returns a single row. The main report ( providing invoice lines say) produces many rows and matches the main report query quite well. Ive trawled through both the jasperstudio docs and jasperreport ultimate guide but Im still not sure how to achieve this setup? This situation isnt unique to invoices - almost all the reports I am working on require this sort of data setup. Yes I could query the data myself and then pass beans in as parameters which then are used, but this means I have to write a specific method in a class or classes in order to drive each report - whereas placing the entire SQL requests into the report itself would therefore result in generic driving code. Any ideas? Cheers, Barry

It is stated on 108 of the Jaspersoft Ultimate Guide PDF that the page footer always retains the declared fixed height. Add it as a standard field perhaps into another band and then print only on page one using a PrintWhenExpression (see pg 119 of the ultimate guide). Include an expression that effective means it only prints on page one, something like: $V{PAGE_NUMBER} == 1 If you need it on the bottom there are options to align the element to the bottom of the band IIRC.

I too would like to see the basic pixel dpi changable to produce millimeter accurate reports rather than 'pixel' accurate. Is there a patch or option for this?

Hi, The IDT exporter uses soft CRs at the end of all lines in a static text box - rather than hard CRs. When the text box is 'justified' the AWT viewer produces the right result, export to PDF produces the same result - but due to the soft CRs in the PDF output the justification causes short lines to justify across the page. Using Hard CRs produces the required output as expected. Is there a way to alter the output of the static text field (and probably text fields) to support hard CRs in the ODT exporter? Cheers, Barry

In Jaspersoft Studio under Eclipse I have created a simple template in title band placed a static text field, placed some text in there and set it to a font, 14px size and BOLD. The design displays correctly. The Preview displays correctly, the PDF output from the preview does NOT use the bold font. Ive tried this with both Verdana and Arial so far. Any ideas?

With regards to image resolution I have net.sf.jasperreports.image.dpi set to 600 dpi in Eclipse but the preview in JasperStudion ignores this it appears.

This appears to relate purely to the prescence of the text element as indicated in the exception. An SVG without text works.

Hi, Im looking at Jasperreports for production of business documentation and the resolution of graphics is paritcularly important. To this end I have two questions: I have a simple logo in the title band on a page. Rendering to HTML, DOCX, ODT and PDF I get the following results: PDF - perfect scaling vector graphics - fantastic. HTML - rendered to image 72dpi, not a problem unless you print the html report, where the resolution then is not great. DOCX - rendered to image ODT - rendered to image For me the PDF rendered correctly. So: - ODT supports SVG (unsure if docx does). How can I ensure the ODT gets am embedded SVG instead of a rendered graphic? - How can I control HTML's rendering? There are two options I need to do here. 1. control whether the image is placed in as an SVG and 2. if rasterized controlling its resolution (to 600dpi)? On a similar note, if the image was a rasterized format such as PNG how can I control the output resolution to 600dpi in ALL the above cases? Cheers Barry

I have a really simple SVG 'logo' created using Inkscape, exported as plain SVG. This consists of a single ellipse, filled by a colour gradient and some text to its right. In JasperStudio in eclipse I place the image into the title band and then preview the report when the following exception occurs: java.lang.ClassCastException: org.apache.batik.bridge.BridgeContext cannot be cast to org.apache.batik.bridge.svg12.SVG12BridgeContextat org.apache.batik.bridge.svg12.SVG12TextElementBridge.addTextEventListeners(SVG12TextElementBridge.java:67)at org.apache.batik.bridge.SVGTextElementBridge.initializeDynamicSupport(SVGTextElementBridge.java:399)at org.apache.batik.bridge.SVGTextElementBridge.buildGraphicsNode(SVGTextElementBridge.java:308)at org.apache.batik.bridge.GVTBuilder.buildGraphicsNode(GVTBuilder.java:224)at org.apache.batik.bridge.GVTBuilder.buildComposite(GVTBuilder.java:171)at org.apache.batik.bridge.GVTBuilder.buildGraphicsNode(GVTBuilder.java:219)at org.apache.batik.bridge.GVTBuilder.buildComposite(GVTBuilder.java:171)at org.apache.batik.bridge.GVTBuilder.build(GVTBuilder.java:82)at net.sf.jasperreports.renderers.BatikRenderer.ensureSvg(BatikRenderer.java:224)at net.sf.jasperreports.renderers.BatikRenderer.ensureSvg(BatikRenderer.java:239)at net.sf.jasperreports.renderers.BatikRenderer.getDimension(BatikRenderer.java:157)at net.sf.jasperreports.engine.export.draw.ImageDrawer.draw(ImageDrawer.java:130)at net.sf.jasperreports.engine.export.draw.PrintDrawVisitor.visit(PrintDrawVisitor.java:134)at net.sf.jasperreports.engine.export.draw.PrintDrawVisitor.visit(PrintDrawVisitor.java:57)at net.sf.jasperreports.engine.fill.JRTemplatePrintImage.accept(JRTemplatePrintImage.java:442)at net.sf.jasperreports.engine.export.draw.FrameDrawer.draw(FrameDrawer.java:251)at net.sf.jasperreports.engine.export.draw.FrameDrawer.draw(FrameDrawer.java:199)at net.sf.jasperreports.engine.export.JRGraphics2DExporter.exportPage(JRGraphics2DExporter.java:273)at net.sf.jasperreports.engine.export.JRGraphics2DExporter.exportReportToGraphics2D(JRGraphics2DExporter.java:246)at net.sf.jasperreports.engine.export.JRGraphics2DExporter.exportReport(JRGraphics2DExporter.java:184)at com.jaspersoft.studio.editor.preview.view.report.swt.ViewerCanvas.renderPage(ViewerCanvas.java:371)at com.jaspersoft.studio.editor.preview.view.report.swt.ViewerCanvas.refresh(ViewerCanvas.java:344)at com.jaspersoft.studio.editor.preview.view.report.swt.ViewerCanvas$2.viewerStateChanged(ViewerCanvas.java:122)at com.jaspersoft.studio.editor.preview.view.report.swt.ReportViewer.fireViewerModelChanged(ReportViewer.java:340)at com.jaspersoft.studio.editor.preview.view.report.swt.ReportViewer.setDocument(ReportViewer.java:88)at com.jaspersoft.studio.editor.preview.view.report.swt.SWTViewer.setJRPRint(SWTViewer.java:113)at com.jaspersoft.studio.editor.preview.PreviewJRPrint.switchRightView(PreviewJRPrint.java:234)at com.jaspersoft.studio.editor.preview.PreviewContainer.switchRightView(PreviewContainer.java:238)at com.jaspersoft.studio.editor.preview.PreviewJRPrint$3.switchView(PreviewJRPrint.java:202)at com.jaspersoft.studio.editor.preview.PreviewJRPrint$1.run(PreviewJRPrint.java:161)at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:180)at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:150)at org.eclipse.swt.widgets.Display.syncExec(Display.java:4491)at com.jaspersoft.studio.editor.preview.PreviewJRPrint.setJasperPrint(PreviewJRPrint.java:156)at com.jaspersoft.studio.editor.preview.view.control.ReportControler$6.run(ReportControler.java:538)at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3717)at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3366)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:138)at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:610)at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)at org.eclipse.equinox.launcher.Main.run(Main.java:1450)at org.eclipse.equinox.launcher.Main.main(Main.java:1426) The use of SVG to obtain a suitable image render quality in both HTML, PDF and ODT outputs is important. Any ideas? Cheers Barry