vickirk

This is really having a huge impact on developing reports and should be a high priority issue. While for some things you can workaround using an expression to create a string but for say images passed in you have no option to edit the jrxml in a text editor everytime you save it.

Hi, I'm using the js-export script to extract scheduled reports into a directory where they are then integrated into an external web site by a script. The problem is the image file names for the charts in teh report don't have a png extension, is there any way I can change the way file names can be specified for charts when doing an HTML export. I tried setting the html element id export parameter on the off chance. I cant see a way to do it. The fallback option of renaming the files and modifiying the html is straight forward, I'd rather be able to do it in JR/JS though. Any ideas? Thanks,Vic

Sun's, or rather oracles, java 6 JDK should come bundled with rhino, guess it's not using a standard distribution.

This should be answered for you in http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=21513

Which jvm is being used and what version of java and on what OS. It looks like the rhino javascript library is not being found.

You need to add some input controls to the report in JS, these then map onto your report parameters.

What would be great was if I could map a real directory to some node it the repository tree.

Hi, I was wondering if it's possible to get Jasper Server to save reports generated from a shedule to a the local file system, where they can be accessed without going through JS. There are going to be 100s of large reports generated, emailing them is not an option (client has ruled that out as impractical), as is manually logging into JS and someone selecting and downloading each one. This is a last minute requirements change, otherwise I'd have done a simple quartz/jasperreports server to do them :-( If there is no way out of the box to do this, would it be straight forward to add support for this. I've had a quick poke through the source but can't see any relevant interfaces/factories. Regards, Vic

Just in case anyone searches and finds this I've identified the issue. After looking in the code iReport always sets PROPERTY_ONE_PAGE_PER_SHEET, thus rendering any mention of net.sf.jasperreports.export.xls.one.page.per.sheet in my report redundant, the setting is though picked up when executed programmatically. It would be nice if iReport only specified this property if the user elected to specify a value, of course this would mean it would have to be able to track whether the user set the value that happens to be the default or they had just not set it.

> I'm sending data to the report in a jtable from java code Sorry, stil confused. Do you have an application that you use to populate data in teh database, that data is then pulled out for a report via JDBC/SQL? > How can convert it in ireport? Change the type of the field to a string. use $F{Date}.toString() or use java.util.SimpleDateFormat. Alternatly change your databse query to return the formatted string. BTW, are you sure you have a field _called_ Date specifed in your query, the error you are report says it cannot evaulate the expression _$F{Date}_

The error message suggests you don't have a field called Date, what is the source of the data? Assuming it is JDBC what is your SQL query? > I'm sending a string data to the report date column from my java code. I'm a bit confused, could you expand a little. Regards, Vic

Not an ideal solution, but you could write a helper class in java that creates a image with the text rotated. You could do it as a scriptlet I guess, I prefer a standalone java utility as I could get more mileage from it.

What's your query?

I'll try rephrasing this, concentgrating on my immediate problem, hopefully making it easier for an answer. Can someone provide me steps to add to a jrxml source file so that te report (reliablbly) creates an excel file where sub reports are added as seperate worksheets. I have this going in iReport if I set the excel export options in Tools/Options, but not by adding properties to the report. The report is going to be deployed under a number of different web apps/environments and many installations of those, so I can't rely on config specified outside of the compiled jasper, the conifg would clash with other reports and would mean updating a lot of environments, also teh web apps are bespoke and have no support for providing per reort config. Kind Regards, Vic Post Edited by vickirk at 07/22/2010 07:32

Do your parameters have default values or are you sure they are being set?

Hi, I'm struggling to get to grips with specifying export parameters to create a xls document in the desired format. I have teh following in my jrxml. <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="device-detail" language="groovy" pageWidth="1000" pageHeight="842" columnWidth="1000" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true"> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="Boolean.TRUE"/> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="Boolean.TRUE"/> <property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="Boolean.TRUE"/> <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="Boolean.TRUE"/> However these are just being ignored, if I go into tools/option/Export Options in iReport and check the relevant boxes it works as expected. However I need the reports to be self conatined, I can't rely on the relevant config items been set, the report is going to be deployed to various environments. Am I missing something obvious (I've tried just 'true' instead of Boolean.TRUE? Post Edited by vickirk at 07/20/2010 21:38

Thanks for that, it is greatly appreciated.

Attached is something like that I'd like, the image represents 100%. I am a java developer and could quite easily write the code to generate the image, I'm just not sure how to integrate it. Thanks, Vic

Hi, I'm trying to create a status bar indicator using a chart. What I want is to create is a horizontal bar with a value from 0 to 100. I tried creating using a horizontal bar chart and turning off the labels/legend/ticks however the ticks remain and seem to ignore the setting. I also thought I'd try a thermometer type chart but would need to get rid of the "bulb" and the oreientation field is ignored. The bar needs to be the same height as a line of text. Is there another way of doing it or is there any documentation on how to expand the charts available. Thanks, Vic

Have you got this working now?

The servlet output stream is being closed once the data from the pdf is written to it, then the jsp is attempting to write some html to the stream! A servet (or an http server side mechanism) can only return one document per request, your servet is attempting to return a pdf and then some html, drop the html at th eend and it should work.

There may be an easier way, but this is how I do it. Create a variable called NUM_FORMAT with an initial value of new java.text.DecimalFormat("0.##") Then your expression becomes something like $F{venprice_label} + ": " + $V{NUM_FORMAT}.format($F{venprice}.doubleValue()) Alternately with java 1.5/1.6 the following may work (I've never tried it, ireport may not like it) String.format("%s: %.2f", $F{venprice_label}, $F{venprice}.doubleValue())

There are two easy ways: * Change your query to do this, assuming you don't have table with country codes to join on to you could use a database specific query, e.g. in oracle use a decode ala DECODE(field, 1, 'India', 2, 'USA', 3, ...) * Or a more portable way try using an expression like $F{f}.intValue() == 1 ? "India" : $F{f}.intValue() == 2 ? "USA" : $F{f}.intValue() == 3 ? "Japan" : "China" If the above is something you need to do often I'd create a utilty method in java and add it to the class path. Personally, if it was possible, I'd create a table for enumerated values and change the query to a join to pull in the country name, e.g. SELECT p.name, c country_name FROM person p, country c WHERE p.country_id = c.country_id Regards, Vic

Hi, Could anyone tell me how I can get ireport to use a custom JRDataProvider. i.e. one I wrote myself. I've had a look at variou settings/config and can't see one, the only option seems to be to write a netbeans plugin which seems a little bit of an overkill. Thanks, Vic

Sorry, shoul dhave mentioned what this does. It sets the max memory allowed to be used via java to be 512Mb (or 756Mb in the second example!)