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