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