[Excluding elements from XLS format]

Look up information on the "exclude.key" property.

Code:

<property name="net.sf.jasperreports.export.xls.exclude.key.{keyvalue}" />

[How can I remove pagination from Excel/CSV export]

Can you offer any more details on this solution?  A number of JR versions have been released since this post.  Is there a workaround for this subreport problem?

Post Edited by cdeal at 08/12/2009 17:27

[show a parameter when the report contains no data]

I couldn't believe that it didn't work as I expected, so I went back over the code (not that I hadn't been trying off and on for the past couple of days now...). The dev who originally wrote the report had a PrintWhenExpression on the field that was turning it off.

 

So, this one is COMPLETELY operator error.

 

Sorry about that.

 

Chuck

[show a parameter when the report contains no data]

Many of our reports show the report criteria that was used to generate/customize the report. However, most of the time, this information is an ID instead of useful text. We normally show a field from the resultset in the header to represent the parameters used by the report, but when the report contains no data, those fields aren't available either; therefore, they show up blank in the output. We thought that we could correct this problem be sending in the parameter text along with the parameter id (two separate parms) but the report will not show the parmeters when there is no data either. The only way that I have found, is to wrap the parameter with a variable that has it's initial value set to the param value. This seems like a lot of extra effort.

 

We are using JR 2.0.2 and I believe that it happened with JR 1.2.4. We already use "All Sections No Detail".

 

Why doesn't the report display fields that contain PARAMETER values when there is no data when it WILL display a VARIABLE in the same case? Is there some setting? Does it make sense to do this? Is my work around the only way to accomplish this?

 

Chuck

[show a parameter when the report contains no data]

Many of our reports show the report criteria that was used to generate/customize the report. However, most of the time, this information is an ID instead of useful text. We normally show a field from the resultset in the header to represent the parameters used by the report, but when the report contains no data, those fields aren't available either; therefore, they show up blank in the output. We thought that we could correct this problem be sending in the parameter text along with the parameter id (two separate parms) but the report will not show the parmeters when there is no data either. The only way that I have found, is to wrap the parameter with a variable that has it's initial value set to the param value. This seems like a lot of extra effort.

 

We are using JR 2.0.2 and I believe that it happened with JR 1.2.4. We already use "All Sections No Detail".

 

Why doesn't the report display fields that contain PARAMETER values when there is no data when it WILL display a VARIABLE in the same case? Is there some setting? Does it make sense to do this? Is my work around the only way to accomplish this?

 

Chuck