yananderson
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by yananderson
-
-
Hi,
If you'd like jasper reports to export a table or crosstab report and display the broders that you've setup in Ireports or the adhoc report designer then you need to change a setting in the jasperserver files.
the file you need to change is :
jasperserver451WEB-INFapplicationContext.xml
Find the line:
<property name="ignoreCellBorder" value="true"/>
Change this to:
<property name="ignoreCellBorder" value="false"/>
Give tomcat a restart and your reports should now export with the borders.
If you only want to apply this change to a single report then try adding this report in iReports:
-
Hi All,
Just throwing this out there as I've been searching for the answer to this and found it hard to pin down. Here is the syntax you can use in the default value expression of a date filter:
Start of the current month:
new Date(System.currentTimeMillis() + 24*3600*1000*(new java.lang.Integer((new java.util.GregorianCalendar().getActualMaximum((java.util.GregorianCalendar.DAY_OF_MONTH))) - (new java.util.GregorianCalendar().get(java.util.GregorianCalendar.DATE)))).longValue())
End of the current month:
new Date(System.currentTimeMillis() - (24*3600*1000* (new Date().getDate() - 1)))
The parameter type must be java.util.Date to support this.
-
So I've had the challange to create a top 10 biggest resutls chart using a domain driven dataset. After a fair bit of searching I've managed to scrape together enough knowledge to do this but thought I'd put my findings here in one place so others can re-create this.
Step 1 - Create full dataset chart in jasper reports adhoc editor.
Step 2 - import chart into ireports frmo jasperserver repository
Step 3 - modify chart to show max 10 records. Right click report, choose chart data. under the dataset tab choose the filter expression memo field and add the following code: new Boolean($V{REPORT_COUNT}.intValue()<=10)
Step 4 - add a sort field to the report to sort by your charts measure. The sum of your measure will actually be stored as a field so this can be used to sort the chart reliably. Do this by clicking the icon to enter details on the report query and choosting sort options from the bottom of the popup. Then add field and choose the field that is used by your reports measure and set ti as Descending.
This should be all that is necessary to create a top 10 results chart. I've attached the JRXML and an example output to assist in anyone who wants to follow this.
Post Edited by yananderson at 08/02/2012 11:34
Extra column is added while exporting excel report from Jasperserver.
in Products
Posted
I know this is to do with the page margin. You can hotfix the issue by adding this properties expression to a report:
I'm currently trying to work out how to apply this system wide but no luck so far.