Jump to content
Changes to the Jaspersoft community edition download ×

Scott Andersen

Jaspersoft Staff
  • Posts

  • Joined

  • Last visited

Scott Andersen's Achievements

  1. Highlight all the columns in the group header and right click / "Group Columns". This will create a grouped header section. You can then put the "Group Header" text element on the grouped section, and remove the cells for the individual columns.
  2. All commercial editions (Reporting, Professional, Enterprise) share the same code base, which is found at pro/jrs-ui-pro folder.
  3. I would use the java.util.Date.getTime() method to get the epoch, and compare the epoch field using that parameter. Create a second parameter (name it OpenDateFromEpoch) that performs that translation, and use the second parameter in the query. Something like : and cr.open_date >= $P{OpenDateFromEpoch}'
  4. java.util.Date class has a "getTime()" function that returns the epoch.
  5. This works fine for me. 1. Create parameter. 2. Add the QR Code to the report 3.Set the "Code Expression" 4. Preview the report. 5. Use camera / other means to read the QR code. QR Code reflects the value from the parameter. To further assist on this, you need to provide jrxml
  6. A few clarifications: - where is the date picker you are looking at? - The default selected date is usually the current date, or the default date set in the parameter properties in Studio. - Are you wanting to make the first day of the week be set to Sunday rather than Monday?
  7. You can set the following property on the document to set the password: net.sf.jasperreports.export.pdf.user.password (documentation: https://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.pdf.user.password
  8. There are a subset of Excel properties supported by Jaspersoft's Excel exporter. This does not include the properties associated with data validation. A list of those properties is found here: https://jasperreports.sourceforge.net/config.reference.html You may be able to create a custom exporter that will implement these properties. You would need to write java code to implement this custom java class. Unbderstand this is a complex extension of Jaspersoft. The links below may be helpful. The Excel properties around data validation are discussed here: https://docs.devexpress.com/OfficeFileAPI/DevExpress.Spreadsheet.DataValidation JasperReports JAVA API is here: https://jasperreports.sourceforge.net/api/index.html
  9. Subreports by default point to the compiled version (*.jasper). Compiling / building the subreport should bring your changes into the master. You can also point the Subreport Expression to the "*.jrxml" file, which should trigger the build of the subreport along with the master report.
  10. The ad hoc report designer is a great tool to create a report. However, selected filter values are not displayed on the resulting report. This can be resolved by either putting the ad hoc view on a dashboard (which gives you access to the selected parameters); however, this approach limits the formatting of those values. A better approach is to use an ad hoc template to display the input values in a formatted way. Here are the steps to reference the filter values in a template. Create an ad hoc report that has a filter on it. Create a template that displays the selected values from the input control. Instructions on creating an ad hoc template can be found in the Jaspersoft Studio User Guide, section 12.4. https://community.jaspersoft.com/documentation/jaspersoft-studio-user-guide-820/v820/publishing-report-template To reference the parameters from the ad hoc view you need to access the “REPORT_PARAMETERS_MAP” parameter. This java.util.Map object contains all the parameters selected within the ad hoc view. The key within the parameter map will be the identifier in the domain of the field being filtered, appended with a sequential value. The first time a field is used as a filter it will be “_1”, the second “_2” and so forth. To get the identifier, you can either look at the domain: or drop the ad hoc view onto a dashboard and mouse over the filter to get the field identifier. In the image below, it is “product_family_1”. In the “Text” field expression on the template, reference the “REPORT_PARAMETERS_MAP” value as follows: CONCATENATE($P{REPORT_PARAMETERS_MAP}.get( "product_family_1" ).toString())This template can be used when creating a report from the ad hoc view. The example template is attached below.
  11. Try using different Layouts in your design. (Vertical Layout, Grid Layout, Spreadsheet Layout). For details on each check out https://community.jaspersoft.com/wiki/tibco-jaspersoft-studio-layouts
  12. What html is in the variable? The html in the variable needs to be properly formatted.
  13. Is there any additional issue here? Typically you export to a specific format to print the report.
  • Create New...