lknueve

tried the following, but just returns errors.....using version 4.5.1...... <propertyExpression name="net.sf.jasperreports.export.xls.sheet.names.all"> <![CDATA[$V{sheetNames}]]> </propertyExpression> Post Edited by lknueve at 08/15/2012 00:07

Is it possible to have the proeprty net.sf.jasperreports.export.xls.sheet.names.all set to a variable? For example: <property name="net.sf.jasperreports.export.xls.sheet.names.all" value=$V{names} />

Hi Sasha - you need to set the sub-report property "Position Type" to "Float" HTH

Ok - stupid question, I'm trying to build a string that has one fields values, the field is for the hour end and formatted like "1900" for hour ending at 7pm. I'm grouping by this field and it is the only group in the report. I'm trying to concatenate the other hours with a "/" in the middle of the hours. I have a variable set as follows: variable expression: $V{names} + "/" + $F{hours} initial expression : "" I have a text field in the group footer that is for displaying this variable...however no matter what I set the text field's evaluation time property to (Now, Report, Group, etc), I get the exact same hours in the variable (showing as 1900/1900/1900/1900)? I know the field has different values as there is another text field in the group header that shows the full datetime of the hour end. Does anyone have any ideas? Thanks in advance!

Hello. I have a report that I'm using a red box with white text for all the parameters to display. However, when exporting to Excel the red is gone, but the font is still white so you don't see it. Is there a property I can use for either PDF or Excel export where I can have the font be the color I need? Like for PDF export, have the font be white, but for Excel have the font be black? Any help is appreciated thanks!

First are you able to see the table when the chart is not there? for example if you hide the first detail band, what do you get? also, if you can post the jrxml file that might help determine the problem.

I would check out the following links: http://jasperforge.org/projects/jasperreports/tracker/view.php?id=5514 http://community.jaspersoft.com/questions/527785/excel-sheets-dynamic-renaming http://ryandev.com/how-to-use-a-dynamic-sheet-name-in-an-excel-formula/

Only thing I ever came up with when having this issue is to have the cell in the report be as big as needed to show all the text. I think the way the export to Excel is handled is like it's taking a snapshot of the output and then putting the data into the cells. So if the data is not shown when viewing the output then it won't be available for the export. At least that's what it appears....

I have been trying to figure out how to get the chart themes to work and having no success. I have done just about everything I can think of but getting nowhere. I've even tried using the sample in the download, taken the EyeCandySixties.java file, copied it and renamed it, compiled the code, added the jar to the iReport classpath and still don't see it in the Themes drop down? Does anyone have any suggestions? In particular I'm trying to use the Spring-based implementation from the following site: http://jasperreports.sourceforge.net/sample.reference/chartthemes/index.html What I need to do is have the theme create an OVERLAID chart using the same axis, so I can't even use the multi-axis chart that iReport has. I'm new to Java, so am having real difficulty trying to follow everything, determine what's needed and what's not. If anyone has a step by step example, I would LOVE it. Even if it's not the Spring-based implementation - at this point, I'll take anything. LOL Thanks in advance! Leisa

Can someone please tell me if I want to create a brand new chart theme using the Spring-based implementation what files I need and what they are for? Trying to backtrack through the sample given and being a Java newbie is extremely confusing and I've been trying to figure this out for over a month! I've been trying to follow the steps here but haven't had any success getting the new theme to show in the theme drop down when in iReport designer. (And I have put the new jar file in the classpath.) All I want to know is what is the minimum files needed and what they need to have in them. I can take it from there (hopefully) Like I know I need to have the jasperreports.properties file in the jar -> and I'm assuming you want it to default to the new theme (leaving the following line uncommented: net.sf.jasperreports.chart.theme=<new theme name>) Thanks in advance!

Ok, it looks like from what you're showing that you're seeing 2 fields in the result set - not arrays? If that is so, then the what you need to do is right-clicck your Text Field, then in the window that pops up, at the botton in the left pane, make sure "Fields" is highlighted and then in the middle pane double click your field you are trying to show. See the attached screen print for an example.

not entirely sure what you're wanting here, but I'm thinking you mean that when you have one report be a subreport, and it is blank, when you go to print it, a blank page appears? if this is correct, there is a property on the subreport called "Remove Line When Blank" -> try checking that also, another thing to try is to have the subreport in its own band and hide the band when it's blank HTH

When you say you're returning an array, do you mean the output looks like the following: a[0], a[1], a[2], b[0], b[1] or the following : a, b a, b a, b

might help if you had either a picture to show what you're seeing or the jrxml file itself

I don't know if this will help at all, but if you're not incorporating the report into an app you could have 2 separate versions of the report. One for Excel, and one for all other exports. Unfortunately, I don't think there's any other way around it since it's a report property and you can't really modify that after the report has been generated. If you're incorporating the report into an app, see if there's a way to have the app determine what kind of export the user is going to need prior to running the report, then have the app modify the report xml as needed prior to running? HTH

Hello. I'm having a hard time getting iReport to see my new Chart Theme jar file. I'm new to Java, so not sure what I'm missing. Based on the article here (http://jasperreports.sourceforge.net/sample.reference/chartthemes/index.html) for implementing the Spring based theme, I'm thinking the absolute minimum you need to do is the following: 1. Have the following files: jasperreports.properties -> has following property: net.sf.jasperreports.chart.theme=<themeName> jasperreports_extensions.properties -> has following uncommented and rest commented: net.sf.jasperreports.extension.registry.factory.chart.theme=<class> which is used to implement the ExtensionsRegistryFactory net.sf.jasperreports.extension.chart.theme.spring.beans.resource=chartThemesBeans.xml chartThemesBundle.xml -> add following: <import resource=<themeNameFileBean.xml>/> <bean id="<themeName>" class="<packageName><themeName>"> (along with whatever properties you want to set) (following added to "themeBundle/property" bean) <map> <entry key="CandlestickAverages"> <ref bean="CandlestickAverages"/> </entry> </map> <themeName>.java -> needs to implement net.sf.jasperreports.charts.ChartTheme ChartThemeMapBundle.java -> needed to implement net.sf.jasperreports.charts.ChartThemeBundle 2. Compile all those files into a jar file 3. add the jar file to the iReport classpath I've done all of the above, but iReport is not seeing my new theme? I've tried looking at the sample download files, but there are so many I get confused as to what is actually needed and what is there to help customize a part of their themes. Can anyone tell me which files are absolutely needed? I can hopefully start from there and try to figure out how they are used? Thanks!

Hi Jeff. I believe you are correct. You need the Server to have linking parameters. As for links, I haven't tried those so not 100%, but doing a quick check, they weren't working even when setting field markup property to html.

In case anyone has same issue - I fixed this by changing the Variable Reset Type property to None

I have a report where the user can enter a value or leave it blank. The parameter is named "HighVoltage". Since I have to use this value in several areas of the report, and I need to know if they entered a value or not (Type Double), I have a formula in a variable (HiVoltParm) determining the value. I want to show "N/A" if there is no value or if the user entered a zero. Here's my formula: $P{HighVoltage}==null ? "N/A" : $P{HighVoltage} == new Double(0) ? "N/A" : $P{HighVoltage}.toString() I then have a Text Field (expression class String) to display the value as well with the following: "High: " + $V{HiVoltParm}.toString() The problem is that the report still shows "High: null" even when a value has been entered. The language of the report is Groovy - what am I missing????

Does anyone know if there is a limitation on the chart customizer where it can't do an overlaid chart?

Hello. I am completely new to coding in Java and have been given a task for creating a custom chart for iReport. I figured the best way to start was to learn as much as I could about JFreeChart and then see what/how I could copy from regular Java to the Chart Customizer. I have the custom chart working in Eclipse/Java using JFreeChart and have been trying to mimic the code in the Chart Customizer but am not getting the same results. The chart I've been asked to create is basically a Candlestick chart with a Timeseries chart overlaid. I have the customizer working up to the point where I add the second dataset (for the Timeseries chart) to the chart. However the Timeseries chart is not showing. I'm attaching my customizer code - and in the code, I have also commented out what I have copied from the working Eclipse/Java code so you can see what I am trying to mimic. The section where the customizer is not working is in the customize method at the end of the method. If anyone has any suggestions, I would appreciate it! Thanks in advance!

in case anyone else comes across this, here's how I handled this situation: 1. Create a variable of type dataset (whichever type of dataset your chart is using - in my case, DefaultHighLowDataset) 2. Set the variable to the chart's data as follows: <variable> = (DefaultHighLowDataset) chart.getXYPlot().getDataset(); Then you can use the data to conditionally set chart properties as needed.

Hello. I was wondering if it was possible to get data from the report (also parameter values) to the chart customizer? Like is there another parameter I could pass into the customize method? What I need to do basically (why I need parameter / data values) is to determine some of the settings of the chart. For example, a parameter determines if the data is grouped by hour, day, week or month, so I need to be able to set the range and the tick marks properly. I'm new to Java and still feel new to iReport, so any ideas would be great. Thanks!

in Ultimate book this is what they have for the 2: After Report Init -> This is called after all variables are initialized. After Page Init -> This is called when a new page is created and after all variables having reset type Page are initialized.

not sure if this will help, but I typically use the = instead of equals() function...like the following: $F{ADR_DONN}=="A & D Surcharge" ? Boolean.True:Boolean.False