Our user has done the migration from JRS version 7.9 to 8.1.1. The export from JRS 7.9 is completed successfully. When they import it into the new JRS 8.1.1 environment, they get the below error:

[java] Processing started
[java] 2023-03-28T19:48:53,649 ERROR ImporterImpl:201 - Import failed as resources cannot be decoded
[java] Import failed as resources cannot be decoded

How do I resolve this error?

Solution:

This error generally occurs because the  'deprecatedImportExportEncSecret' keyword was not added to the import and export commands.

Please use the below steps for the migrations:

1. At the time of export, please run the below command in the buildomatic of JRS 7.9.1:

    js-export.bat --everything --output-zip export111.zip --keyalias deprecatedImportExportEncSecret --> where export111.zip is the name of the zip file that will be generated after the export operation.

2. At the time of import, please run the below command in the buildomatic of JRS 8.1.1:

   js-import.bat --input-zip export111.zip --keyalias deprecatedImportExportEncSecret    ---> This same file would be used at the time of import into JRS 8.1.1.

Ref Case: #02174474

•    No access: 0
•    Administer: 1
•    Read-only: 2
•    Read-write: 6
•    Read-delete: 18
•    Read-write-delete: 30
•    Execute-only: 32 

Answer: The following method returns the list of all calendar names that were added to the scheduler.

Method: GET  URL: http://<host>:<port>/jasperserver[-pro]/rest_v2/jobs/calendars/?<argument>

The arguments required for this API is as below:

Argument: calendar Type,  Type/Value: optional string, Description: A type of calendar to return: annual, cron, daily, holiday, monthly, or weekly. You may specify only one calendarType parameter. When calendarType isn't specified, all calendars names are returned. If calendarType has an invalid value, an empty collection is returned.

The Return values for this request is as below:
a) For Success: 200 OK – Body contains a list of calendar names.
b) For Failure: 401 Unauthorized

The list of calendar names in the result has the following format in XML:

<calendarNameList>
  <calendarName>name1</calendarName>
  <calendarName>name2</calendarName>
</calendarNameList>

Suppose you want to make some changes to this report.

Using the following technique it will be possible to modify only the .jrxml file and the changes will be propagated:
- To the report that runs independently depending on the .jrxml file. 
- To the Book that contains the same report, or else to any master report which embeds the report as sub-report.

To upload a report jrxml file in JasperReport Server, access the repository view and:

1: Right click on any directory where you want to save the file.

2:- Click on "Add resource" then "File" and then "JRXML", select the .  jrxml file and give any name.

After doing that, you can create a new report i.e. in the same directorywhere you uploaded the jrxml file.

To do that, from Repository view:

1: Right click on the directory where you want to create the new report.

2: Click on "Add resource" then "JasperReport"

3: As it is shown in the following screenshot, select the JRXML file from the repository by using its assigned repository's path.

4: Set the needed Data Source for the report to run, then click on submit.

The first part is done, you have a jrxml file and a Report Unit depending on it.

You can now define a report Book that embeds the same jrxml as report. (Or else a master reports that embeds it as sub-report).

In both cases, when creating the book, you can reference directly the jrxml file that is on the server and that you uploaded first.

To do that, when creating the Book on Jasper Studio, you can include the content from the jrmxl file by setting its repository's path in the Component Expression, i.e. "/public/report".

The same thing can be done when including the jrxml as a subreport.

Save the Book and publish it on the JasperReports Server.

Finally, you will have defined a Jasper Report and a Book (or a master report) that embeds the same jrxml file. Each time a modification is performed on this file, it will be visible both on the Jasper Report and in the Book itself being the same file referenced by the 2 containers.

At scale, you can have multiple embedding containers (Jasper Reports, report Book, master reports), that embeds a jrxml and each modification performed to that single file will be propagated to them.

Java Code

Using JasperReports Library you have access to java code that will allow you to generate reports and connect to data sources.  All the data connectivity, report generation, and distribution is controlled directly in the java code. Although this gives you microscopic control of your end result, it is also the most labor intensive, requiring months (if not years) to develop the reporting features you need in your application. If you have time and the java developer resources available, this can be an option.

User Interface / iFrames

JasperReports Server is a complete reporting portal providing a white label capable user interface to give your users access to an enterprise grade reporting solution. The server  can be integrated with your application’s security, so you can give access to the server as a separate  reporting portal. Portions of this UI can be embedded inside your application using IFrames. This allows you to take advantage of the advanced interactive report viewer, ad hoc report designer, dashboard designer, and other features provided by JasperReports Server.  Thus you take advantage of decades of development provided by Jaspersoft. A possible drawback is that using IFrames you are limited in what control you have over the interface.

Web Services

JasperReports Server has a comprehensive suite of web services available via REST. By implementing these REST calls in your application, you can let JasperReports Server handle the heavy lifting when it comes to connecting to data and generating reports.  You also have access to other aspects of the server, such as dashboards, scheduling, and administrative functions.  Thos administrative services allow you to simplify things when it comes to operational tasks around the environment.

Javascript

If you want to take full advantage of the power of JasperReports Server, while maintaining control over the end user experience, Jaspersoft’s “Visualize.js” javascript API gives you that control in an easy to implement solution. You are not limited to embedding reports and dashboards. Visualize.js gives you the capability to control interactions with those reports and dashboards, both in passing data into the reports to control their results, to capturing actions and events associated with the reports and managing how the application responds. And this can be accomplished within a day or so, if not in hours! 

Comparison of your options

JasperReports Library

• Embed reports using java code

• Design reports using Jaspersoft Studio

• Needs a  java developer to embed.

• All delivery code is done by you, using the JasperReports Library classes.

• You have complete control of what the application does with regards to report delivery..

• For more information check out the javadoc:  https://jasperreports.sourceforge.net/api/index.html
  and samples :
  https://jasperreports.sourceforge.net/sample.reference.html 

JasperReports Server UI / iFrame embedding

• JasperReports Server  is a full feature reporting portal

• Reports created using Jaspersoft Studio, the Ad Hoc Designer, and the Dashboard Designer.

• White labeled to reflect your styles.

• Can be delivered as a stand alone reporting portal, or embedded using iFrames.

• Information on JasperReports Server:
  https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-ultimate-guide/vv900/js-ultimate-guide-_-api-_-repository-http-api/ 

Web services

• Embed using REST API calls. The web services can be provided either by JasperReports Server (JRS) or JasperReports IO (JR-IO).

• JR IO reports are designed using Jaspersoft Studio, while JRS adds access to visualizations created by the Ad Hoc Designer, and the Dashboard Designer.. 

• Access via REST calls can be accomplished from a wide variety of platforms; not limited to java

• You control the presentation layer.

• REST API documentation for JRS:
  https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-rest-api-reference/vv900/jasperreports-server-rest-api-reference-_-overview/
  And for JR-IO
  https://demo.jaspersoft.com/jrio-docs/#rest-api-reference 

Visualize.js

• Embed using javascript

• Visualizations can be provided either by JasperReports Server or JasperReports IO (JR_IO).

• JR IO reports are designed using Jaspersoft Studio, while JRS adds access to visualizations created by the Ad Hoc Designer, and the Dashboard Designer.. 

• You have detailed control over the interaction between the visualizations and your application using javascript

• Information on visualize.js for JRS:
  https://tibcosoftware.github.io/js-visualize/#introduction
  And for JR-IO:
  https://demo.jaspersoft.com/jrio-docs/#live-javascript-client-samples  

The great news is you can combine usage of all these options as needed, providing a robust enterprise reporting solution.

Is it possible to translate the input control validation message and report empty message to Swedish, Please see the attached screenshot.

Recommendation: 

The two messages - 'This field is mandatory so you must enter data' and 'You must apply input values before the report can be displayed' are defined in the  jasperserver_messages.properties file - so it should be modifiable easily by language with locales as mentioned above or by just changing that particular file.

If after this, you see accented letters: 

The accented characters should be unicode escaped in the properties file. Otherwise,
ä =  ä
and
å = Ã¥

So, I believe that is what is happening. If you refer to the guide:
https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-administration-guide/v8/creating-locale/It is stated as follows:
The resource bundles described in this document consist of locale-specific Java properties files. Java properties files use the ISO-8859-1 (Latin-1) encoding that is the same as ASCII for all English non-accented characters. For international characters that are not in ISO-8859-1, use Unicode escape sequences (for example u00e9 is é).

Therefore in all the translation properties files, you can look up the unicode escape equivalent and use that instead of the accented characters. You can easily look at other property files such as es, and fr to see how they are done. You can google to find the Unicode sequence for the accented characters and use that instead. 

While using lambda expressions while creating parameter expressions in JasperServer Studio we get the following error: 

"The target type of this expression must be a functional interface"

Recommendation:

Given the way report expressions are compiled, you need to explicitly cast the expression to the expected functional type. As in: 

<parameter name="Parameter1" class="java.util.function.Function">
<defaultValueExpression><![CDATA[(java.util.function.Function<String, String>) ((test) -> {return test + test;})]]></defaultValueExpression>
</parameter>

Is it possible to enable Font Ligature in JasperServer? 

Recommendation:

1. Font ligatures are disabled by default in PDF. 
2. Ligatures can work when Apache FOP is present on the classpath and the net.sf.jasperreports.export.pdf.classic.fop.glyph.substitution.enabled property is set to true.
3. So it could work on the server if that property is set to true globally or in the report. 
4. But it wouldn't work in Studio because FOP is not present there. 
 

The span names and properties can be modified for better visibility on Jaeger. You can create an annotation by adding @WithSpan to the method. This creates a span for a method for which it is annotated with. These annotated method names appear under the Operations field in Jaeger UI.
The following figure shows the @WithSpan annotation for one of the methods involved in the process of Scheduling.

Adding Annotations

Use cases for Adding Annotation

You can add annotations in the method of the code to investigate the performance issues of JasperReports Server application during execution of the report. The performance of an application can be slow due to various reasons, for example, if a report is taking longer than usual to execute, in such cases adding annotations helps to break down the request time by detecting slow queries and capturing the exact places (spans) and the time spent in each major code area. 

For more information about various scenarios where adding annotations helped to improve the performance of JasperReports Server application, see  https://community.jaspersoft.com/knowledgebase/how-to/how-to-investigate-the-performance-issues-of-scheduler-and-input-controls-in-the-jasperreports-server-r4635/

Adding @WithSpan and Creating Custom Spans

 Adding @WithSpan

1. Add the OpenTelemetry library in the following pom.xml of the corresponding java module in which the class resides.

<dependency>
   <groupId>io.opentelemetry</groupId>
   <artifactId>opentelemetry-extension-annotations</artifactId>
</dependency>

2. Import import io.opentelemetry.extension.annotations.WithSpan;

3. After importing add @WithSpan to the required method.

Creating Custom Spans

1. Add the following dependency in the pom.xml for creating a span using the Span class:

<dependency>
  <groupId>io.opentelemetry</groupId>
  <artifactId>opentelemetry-api</artifactId>
  <version>1.16.0</version>
</dependency>

2. Import import io.opentelemetry.api.trace.Span;

Methods for Adding Annotations

The following are the main methods for adding annotations in the code. You need to set the following span names and properties for instrumenting the code:

• span = Span.current()
• span.updateName()
• span.setAttribute() 

For more information, refer to OpenTelemetry javadoc https://javadoc.io/doc/io.opentelemetry/opentelemetry-api-trace/latest/io/opentelemetry/api/trace/Span.html.

“This functionality is no longer applicable to our latest version.

servicereport.jrxml

This page provides a list of supported Advanced Chart Formatting commands.

Jaspersoft HTML5 Javascript Charts are defined with default formatting. While the Ad Hoc Designer provides some basic formatting control via properties that are selected from the Chart Formatting Dialog, in some cases you may require more control over a chart's appearance. Starting with Jaspersoft Version 6.2, the Advanced Properties Tab is designed to let you enter formatting commands:

💡Tip: placing two slashes at the beginning of a property causes it to be commented out. Use this "trick" to disable a property without having to delete it.

Notes:

• 3D Charting options are not currently supported.
• Property names and values are case sensitive. Incorrect casing will cause a property to be ignored.
• If the Properties names or 'Values' are input incorrectly, the chart will not change.

Property	Value	Description
chart.alignTicks	true or false	When using multiple axis, the ticks of two or more opposite axes will automatically be aligned by adding ticks to the axis or axes with the least ticks. This can be prevented by setting alignTicks to false. If the grid lines look messy, it's a good idea to hide them for the secondary axis by setting gridLineWidth to 0. Defaults to true. For example, value set to: false causes a chart to draw as follows:
chart.backgroundColor	"color"	Sets the back ground color of the entire chart. The color value may be a color name (such as 'Black') or a hexadecimal code enclosed in double quotes. For example, value set to: "Grey" causes a chart to draw as follows: Notes: Color Names and Hex Codes should not contain spaces. Hex codes should begin with #. If an unknown color name or code is defined, a black back ground is displayed. For a list of color hex codes, see: https://simple.wikipedia.org/wiki/Web_color
chart.borderColor	"color"	The color of the outer chart border. Defaults to #4572A7. For example, value set to: "Green" causes a chart to draw as follows: Notes: You must include chart.borderWidth in order to work
chart.borderRadius	Value	The corner radius of the outer chart border. Defaults to 0. For example, value set to: 5 causes a chart to draw as follows: Notes: You must include and ;chart.borderWidth in order to work You can add chart.borderColor to change border color
chart.borderWidth	Value	The pixel width of the outer chart border. Defaults to 0. For example, value set to: 2 causes a chart to draw as follows: Notes: You can add chart.borderColor to change border color
chart.plotBackgroundColor	"color"	Sets the back ground color of the chart plot area. The color value may be a color name (such as 'Black') or a hexadecimal code enclosed in double quotes. For example, value set to: "Black" causes a chart to draw as follows: Notes: Color Names and Hex Codes should not contain spaces. Hex codes should begin with #. If an unknown color name or code is defined, a black back ground is displayed. For a list of color hex codes, see: https://simple.wikipedia.org/wiki/Web_color
chart.height	Value	An explicit height for the chart. By default the height is calculated from the offset height of the containing element, or 400 pixels if the containing element's height is 0. For example, value set to: 200 causes a chart to draw as follows:
chart.ignoreHiddenSeries	true or false	If true, the axes will scale to the remaining visible series once one series is hidden. If false, hiding and showing a series will not affect the axes or the other series. For stacks, once one series within the stack is hidden, the rest of the stack will close in around it even if the axis is not affected. For example, value set to: true causes a chart to draw as follows:
chart.inverted	true or false	Whether to invert the axes so that the x axis is vertical and y axis is horizontal. For example, value set to: true causes a Spline chart to draw as follows:
chart.margin	Array	The margin between the outer edge of the chart and the plot area. The numbers in the array designate top, right, bottom and left respectively. Use the options marginTop, marginRight, marginBottom and marginLeft for shorthand setting of one option. Since version 2.1, the margin is 0 by default. The actual space is dynamically calculated from the offset of axis labels, axis title, title, subtitle and legend in addition to the spacingTop, spacingRight, spacingBottom and spacingLeft options. Defaults to [null]. For example, value set to: [100, 80, 60, 80] causes a chart to draw as follows:
chart.marginBottom	Value	The margin between the bottom outer edge of the chart and the plot area. Use this to set a fixed pixel value for the margin as opposed to the default dynamic margin. See also. For example, value set to: 100 causes a chart to draw as follows:
chart.marginLeft	Value	The margin between the left outer edge of the chart and the plot area. Use this to set a fixed pixel value for the margin as opposed to the default dynamic margin. See also spacingLeft. For example, value set to: 150 causes a chart to draw as follows:
chart.marginRight	Value	The margin between the right outer edge of the chart and the plot area. Use this to set a fixed pixel value for the margin as opposed to the default dynamic margin. See also spacingRight. For example, value set to: 270 causes a chart to draw as follows:
chart.marginTop	Value	The margin between the top outer edge of the chart and the plot area. Use this to set a fixed pixel value for the margin as opposed to the default dynamic margin. See also spacingTop. For example, value set to: 30 causes a chart to draw as follows:
chart.options3d.enabled	true or false	Supported as of Version 6.2.1. Causes a chart to be drawn in 3d. Notes: Works only on Pie, Column, and Bar Chart types Addtional formatting commands are required to set the axis angle and chart depth: chart.options3d.alpha plotOptions.pie.depth For example, a 3d pie chart: chart.options3d.enabled with a value of true chart.options3d.alpha with a value of 45 plotOptions.pie.depth with a value of 45 causes the following chart to be drawn: For example, a 3d column chart: chart.options3d.enabled with a value of true chart.options3d.alpha with a value of 20 causes the following chart to be drawn:
chart.panKey	String	Allows setting a key to switch between zooming and panning. For example, value set to: "shift"
chart.panning	true or false	Allow panning in a chart. Best used with panKey to combine zooming and panning. Defaults to false. For example, value set to: true
chart.plotBackgroundImage	String	The URL for an image to use as the plot background. To set an image as the background for the entire chart, set a CSS background image to the container element. Note that for the image to be applied to exported charts, its URL needs to be accessible by the server. For example, value set to: "insert URL" causes a chart to draw as follows:
chart.plotBorderColor	"color"	The color of the inner chart or plot area border. Defaults to #C0C0C0. For example, value set to: "blue" causes a chart to draw as follows:
chart.plotBorderWidth	Value	The pixel width of the plot area border. Defaults to 0, For example, value set to: 2 causes a chart to draw as follows:
chart.polar	true or false	When true, cartesian charts like line, spline, area and column are transformed into the polar coordinate system. Requires highcharts-more.js . Defaults to false . For example, value set to: true causes a chart to draw as follows:
chart.reflow	true or false	Whether to reflow the chart to fit the width of the container div on resizing the window. Defaults to true . For example, value set to: false causes a chart to draw as follows:
chart.resetZoomButton.position.x chart.resetZoomButton.position.y	Value	Affects the position of the "Reset zoom" button. This is an object that can hold the properties align, verticalAlign, x and y. For example, value set to: -100 10 causes a chart to draw as follows:
chart.resetZoomButton.theme	Object	A collection of attributes for the button. The object takes SVG attributes like fill, stroke, stroke-width or r, the border radius. The theme also supports style, a collection of CSS properties for the text. Equivalent attributes for the hover state are given in theme.states.hover. For example, define the property as follows: chart.resetZoomButton.theme.fill Set value to: "red" causes a chart to draw as follows:
chart.selectionMarkerFill	"color"	The background color of the marker square when selecting (zooming in on) an area of the chart. Defaults to rgba(69,114,167,0.25). For example, value set to: "blue" causes a chart to draw as follows:
chart.showAxes	true or false	Whether to show the axes initially. This only applies to empty charts where series are added dynamically, as axes are automatically added to cartesian series. Defaults to false. For example, value set to: false causes a chart to draw as follows:
chart.spacing	Array	The distance between the outer edge of the chart and the content, like title, legend, axis title or labels. The numbers in the array designate top, right, bottom and left respectively. Use the options spacingTop, spacingRight, spacingBottom and spacingLeft options for shorthand setting of one option. Defaults to [10, 10, 15, 10]. For example, value set to: [20, 20, 25, 20] causes a chart to draw as follows:
chart.style	CSSObject	Additional CSS styles to apply inline to the container div. Note that since the default font styles are applied in the renderer, it is ignorant of the individual chart options and must be set globally. Defaults to: style: { fontFamily: '"Lucida Grande", "Lucida Sans Unicode", Verdana, Arial, Helvetica, sans-serif', // default font fontSize: '12px' } Defaults to {"fontFamily":""Lucida Grande", "Lucida Sans Unicode", Verdana, Arial, Helvetica, sans-serif","fontSize":"12px"} For example, value set to: 'serif' causes a chart to draw as follows:
chart.type	"waterfall" or "gauge" or "solidgauge" in Version 6.2.1	The default series type for the chart. Use this to create a "waterfall" chart or a "gauge". For example, value set to: "waterfall" causes a chart to draw as follows: Notes: Drawing Gauges requires addtional formatting commands to create the desired appearance. For example, a SolidGauge, uses the following properties: chart.type with a value of "solidgauge" pane.startAngle with a value of -90 pane.endAngle with a value of 90 pane.background.innerRadius with a value of "60%" yAxis.min with a value of 0 yAxis.minorTickInterval with a value of null yAxis.lineWidth with a value of 0 yAxis.tickWidth with a value of 0 plotOptions.solidgauge.dataLabels.borderWidth with a value of 0 pane.background.shape with a value of "arc" yAxis.max with a value of 100000 plotOptions.solidgauge.dataLabels.y with a value of -40 colors with a value of ["skyblue"] yAxis.labels.y with a value of 12 yAxis.tickPixelInterval with a value of 10000 causes a chart to draw as follows:
chart.width	Value	An explicit width for the chart. By default the width is calculated from the offset width of the containing element. For example, value set to: 350 causes a chart to draw as follows:
chart.zoomType	"Value"	Decides in what dimensions the user can zoom by dragging the mouse. Can be one of x, y or xy. For example, value set to: "xy"
colors	["Color1", "Color2", "ColorN"']	A comma seperated list of color values for chart series data. The color value may be a color name (such as 'Blue', 'LightSeaGreen', 'Purple') or hexadecimal codes enclosed in double quotes. For example, value set to: ["red", "DarkTurquoise", "blue", "green", "magenta", "purple", "black", "yellow", "brown", "grey", "gold", "orange", "#7cb5ec"] If there are more series in the chart than specfied in the color list, then default colors are used for the remainig chart series: Notes: Color Names and Hex Codes should not contain spaces. Hex codes should begin with #. If an unknown color name or code is defined, a black series value is returned. Certain Chart Types do not work with the Colors property, for example: Gauges, Heat Maps, and Tree Maps For a list of color hex codes, see: https://simple.wikipedia.org/wiki/Web_color
legend.align	"left" or "right" or "center"	Sets the left-to-right alignment of a chart legend. For example, value set to: "left" causes the following chart to appear:
legend.backgroundColor	"color"	The background color of the legend. For example, value set to: "blue" causes a chart to draw as follows:
legend.borderColor	color	The color of the drawn border around the legend. Defaults to #909090. For example, value set to: "red" causes a chart to draw as follows:
legend.borderRadius	Value	The border corner radius of the legend. Defaults to 0. For example, value set to: 10 causes a chart to draw as follows:
legend.borderWidth	Value	The width of the drawn border around the legend. Defaults to 0. For example, value set to: 0 causes a chart to draw as follows:
legend.enabled	true or false	Enable or disable the legend. Defaults to true. For example, value set to: false causes a chart to draw as follows:
legend.floating	true or false	When the legend is floating, the plot area ignores it and is allowed to be placed below it. Defaults to false. For example, value set to: true causes a chart to draw as follows:
legend.itemDistance	Value	In a legend with horizontal layout, the itemDistance defines the pixel distance between each item. Defaults to 20. For example, value set to: 50 causes a chart to draw as follows:
legend.itemHiddenStyle.color	CSSObject	CSS styles for each legend item when the corresponding series or point is hidden. Only a subset of CSS is supported, notably those options related to text. Properties are inherited from style unless overridden here. Defaults to: itemHiddenStyle: { color: '#CCC' For example, value set to: "green" causes a chart to draw as follows:
legend.itemHoverStyle.color	CSSObject	CSS styles for each legend item in hover mode. Only a subset of CSS is supported, notably those options related to text. Properties are inherited from style unless overridden here. Defaults to: itemHoverStyle: {color: '#000'} For example, value set to: "SandyBrown" causes a chart to draw as follows:
legend.itemMarginBottom	Value	The pixel bottom margin for each legend item. Defaults to 0. For example, value set to: 4 causes a chart to draw as follows:
legend.itemMarginTop	Value	The pixel top margin for each legend item. Defaults to 0. For example, value set to: 5 causes a chart to draw as follows:
legend.itemStyle.color	CSSObject	CSS styles for each legend item. Only a subset of CSS is supported, notably those options related to text. Defaults to { "color": "#333333", "cursor": "pointer", "fontSize": "12px", "fontWeight": "bold" } For example, value set to: "gray" causes a chart to draw as follows:
legend.itemStyle.fontSize	CSSObject	CSS styles for each legend item. Only a subset of CSS is supported, notably those options related to text. Defaults to { "color": "#333333", "cursor": "pointer", "fontSize": "12px", "fontWeight": "bold" } For example, value set to: "16px" causes a chart to draw as follows:
legend.itemStyle.fontWeight	CSSObject	CSS styles for each legend item. Only a subset of CSS is supported, notably those options related to text. Defaults to { "color": "#333333", "cursor": "pointer", "fontSize": "12px", "fontWeight": "bold" } For example, value set to: "bold" causes a chart to draw as follows:
legend.itemWidth	Value	The width for each legend item. This is useful in a horizontal layout with many items when you want the items to align vertically. For example, value set to: 180 causes a chart to draw as follows:
legend.layout	String	The layout of the legend items. Can be one of "horizontal" or "vertical". Defaults to horizontal. For example, value set to: "vertical" causes a chart to draw as follows:
legend.navigation.activeColor	"color"	The color for the active up or down arrow in the legend page navigation. Defaults to #3E576F. "#9FF084" causes a chart to draw as follows:
legend.navigation.animation	true or false	How to animate the pages when navigating up or down. A value of true applies the default navigation given in the chart.animation option. Additional options can be given as an object containing values for easing and duration. . Defaults to true. For example, value set to: false causes a chart to draw as follows:
legend.navigation.arrowSize	Value	The pixel size of the up and down arrows in the legend paging navigation. Defaults to 12. For example, value set to: 16
legend.navigation.inactiveColor	"color"	The color of the inactive up or down arrow in the legend page navigation. Defaults to #CCC. For example, value set to: "red"
legend.navigation.style.fontWeight	CssObject	Text styles for the legend page navigation. For example, value set to: "bold" causes a chart to draw as follows:
legend.padding	Value	The inner padding of the legend box. Defaults to 8. For example, value set to: 4 causes a chart to draw as follows:
legend.reversed	true or false	Whether to reverse the order of the legend items compared to the order of the series or points as defined in the configuration object. Defaults to false. For example, value set to: true causes a chart to draw as follows:
legend.rtl	true or false	Whether to show the symbol on the right side of the text rather than the left side. This is common in Arabic and Hebraic. Defaults to false. For example, value set to: true causes a chart to draw as follows:
legend.shadow	true or false | Object	Whether to apply a drop shadow to the legend. A backgroundColor also needs to be applied for this to take effect. Since 2.3 the shadow can be an object configuration containing color, offsetX, offsetY, opacity and width. Defaults to false. For example, value set to: true causes a chart to draw as follows:
legend.symbolHeight	Value	The pixel height of the symbol for series types that use a rectangle in the legend. Defaults to the font size of legend items. For example, value set to: 4 causes a chart to draw as follows:
legend.symbolPadding	Value	The pixel padding between the legend item symbol and the legend item text. Defaults to 5. For example, value set to: 12 causes a chart to draw as follows:
legend.symbolRadius	Value	The border radius of the symbol for series types that use a rectangle in the legend. Defaults to 0. For example, value set to: 10 causes a chart to draw as follows:
legend.symbolWidth	Value	The pixel width of the legend item symbol. Defaults to 16. For example, value set to: 30 causes a chart to draw as follows:
legend.title.style.fontSize	CSSObject	Generic CSS styles for the legend title. Defaults to {"fontWeight":"bold"}. For example, value set to: 20
legend.useHTML	true or false	Whether to use HTML to render the legend item texts. Prior to 4.1.7, when using HTML, legend.navigation was disabled. For example, value set to: true
legend.verticalAlign	"top" or "bottom" or "center"	Sets the top-to-bottom alignment of a chart legend. For example, value set to: "top" causes the following chart to appear:
legend.width	Value	The width of the legend box. For example, value set to: 75 causes a chart to draw as follows:
legend.backgroundColor	"color"	Sets the background color of the chart legend. For example, value set to: "silver" causes the following chart to appear: Notes: Color Names and Hex Codes should not contain spaces. Hex codes should begin with #. If an unknown color name or code is defined, a black background is displayed. For a list of color hex codes, see: https://simple.wikipedia.org/wiki/Web_color
legend.title.text	String	Displays a legend tile. For example, value set to: Key: causes the following chart to appear:
legend.x	Value	The x offset of the legend relative to its horizontal alignment align within chart.spacingLeft and chart.spacingRight. Negative x moves it to the left, positive x moves it to the right. Defaults to 0. For example, value set to: -105 causes a chart to draw as follows:
legend.y	Value	The vertical offset of the legend relative to it's vertical alignment verticalAlignwithin chart.spacingTop and chart.spacingBottom. Negative y moves it up, positive y moves it down. Defaults to 0. For example, value set to: 20 causes a chart to draw as follows:
pane.background.backgroundColor	"color"	For example, value set to: "red"
pane.background.shape	String	For example, value set to: "arc"
pane.background.innerWidth	Value	For example, value set to: 30
pane.background.outerWidth	Value	For example, value set to: 20
pane.background.borderWidth	Value	For example, value set to: 10
pane.background.borderColor	"color"	For example, value set to: "blue"
pane.endAngle	Value	The end angle of the polar X axis or gauge value axis, given in degrees where 0 is north. Defaults to startAngle + 360. For example, value set to: 85 causes a chart to draw as follows:
pane.size	Value | String	The size of the pane, either as a number defining pixels, or a percentage defining a percentage of the plot are. Defaults to 85%. For example, value set to: "70%" causes a chart to draw as follows:
pane.startAngle	Value	The start angle of the polar X axis or gauge axis, given in degrees where 0 is north. Defaults to 0. For example, value set to: -85 causes a chart to draw as follows:
plotOptions.gauge.dataLabels.style.fontSize	CSSObject	Styles for the label. Defaults to {"color": "contrast", "fontSize": "11px", "fontWeight": "bold", "textShadow": "0 0 6px contrast, 0 0 3px contrast" } For example, value set to: "15px"
plotOptions.gauge.dataLabels.y	Value	The y position offset of the label relative to the center of the gauge. Defaults to 15. For example, value set to: 15
plotOptions.gauge.dataLabels.enabled	Boolean	Enable or disable the data labels. Defaults to false. For example, value set to: FALSE causes a chart to draw as follows:
plotOptions.gauge.dial.radius	String	The radius or length of the dial, in percentages relative to the radius of the gauge itself. Defaults to 80%. For example, value set to: "100%" causes a chart to draw as follows:
plotOptions.gauge.dial.borderWidth	Value	The width of the gauge dial border in pixels. Defaults to 0. For example, value set to: 0 causes a chart to draw as follows:
plotOptions.gauge.dial.borderColor	"color"	The border color or stroke of the gauge's dial. By default, the borderWidth is 0, so this must be set in addition to a custom border color. Defaults to silver. For example, value set to: "black" causes a chart to draw as follows:
plotOptions.gauge.dial.baseWidth	Value	The pixel width of the base of the gauge dial. The base is the part closest to the pivot, defined by baseLength. Defaults to 3. For example, value set to: 4 causes a chart to draw as follows:
plotOptions.gauge.dial.topWidth	Value	The width of the top of the dial, closest to the perimeter. The pivot narrows in from the base to the top. Defaults to 1. For example, value set to: 1 causes a chart to draw as follows:
plotOptions.gauge.dial.baseLength	String	The length of the dial's base part, relative to the total radius or length of the dial. Defaults to 70%. For example, value set to: "90%" causes a chart to draw as follows:
plotOptions.gauge.dial.rearLength	String	The length of the dial's rear end, the part that extends out on the other side of the pivot. Relative to the dial's length. Defaults to 10%. For example, value set to: "5%" causes a chart to draw as follows:
plotOptions.pie.innerSize	"Value"	Sets the size of a hole in Pie Charts. Value can either be a pixel number or % of Pie enclosed in double quotes. For example, a value of: "50%" causes the following chart to appear:
plotOptions.series.dataLabels.enabled	true or false	Displays data values on a chart. For example, value set to: true causes a chart to draw as follows:
plotOptions.series.dataLabels.format	{format string}	Applies a formatting to data labels. For example: {point.y:.2f} causes data values to display with 2 decimals {point.y:,.0f} causes data vlaues to display with thousands seperator and zero decimals and causes the chart tp draw as follows: Another example for percent bar chart: {point.percentage:.1f} % causes a chart to draw as follows: Notes: Requires the plotOptions.series.dataLabels.enabled format property to be set
plotOptions.series.dataLabels.rotation	Value	Rotates data labels from 0 to 360 degrees. For example, value set to: 270 causes a chart to draw as follows: Notes: Requires the plotOptions.series.dataLabels.enabled format property to be set
plotOptions.series.dataLabels.x   plotOptions.series.dataLabels.y	Value	Defines datalabel offwet position from either X or Y axis. For example, to change the label position on the Y-Axis, use plotOptions.series.dataLabels.y with a value of: -20 causes a chart to draw as follows:
plotOptions.series.pointWidth	Value	For example, value set to: 17 causes a chart to draw as follows:
series.shadow	true or false	Whether to apply a drop shadow to the graph line. Since 2.3 the shadow can be an object configuration containing color, offsetX, offsetY, opacity and width. Defaults to false. For example, value set to: false causes a chart to draw as follows:
series.borderWidth	Value	For example, value set to: 0 causes a chart to draw as follows:
series.dataLabels.enabled	true or false	Displays data values on a chart. For example, value set to: true as of Version 6.3 causes a Pie chart to draw as follows:
series.dataLabels.format	{format string}	Applies a formatting to data labels. For example: {point.name} causes the series name to be displayed {point.percentage:.0f} causes the data vlaue to be dispplayed as a percent of the total As of Version 6.3, Pie chart label formatting is supported, for example: {point.name}: {point.percentage:.1f}% causes a Pie chart to draw as follows:
series.groupPadding	Value	For example, value set to: -4 causes a chart to draw as follows:
series.pointPadding	Value	For example, value set to: -.5 causes a chart to draw as follows:
subtitle.text title.text	String	Displays a Chart Title or Subtitle text string. For example, a title and subtitle values of: Fresh Food Sales Performance State Tree Map by Demographic causes the following to appear in a chart:
title.text	"Value"	The title of the chart. To disable the title, set the text to null. Defaults to Chart title. For example, value set to: "Title" causes a chart to draw as follows:
tooltip.followPointer	true or false	Whether the tooltip should follow the mouse as it moves across columns, pie slices and other point types with an extent. By default it behaves this way for scatter, bubble and pie series by override in the plotOptions for those series types. For touch moves to behave the same way, followTouchMove must be true also. Defaults to false. For example, value set to: true causes a chart to draw as follows:
tooltip.footerFormat	"Value"	A string to append to the tooltip format. Defaults to false. For example, value set to: </table> causes a chart to draw as follows:
tooltip.headerFormat	"Value"	The HTML of the tooltip header line. Variables are enclosed by curly brackets. Available variables are point.key, series.name, series.color and other members from the point and series objects. The point.key variable contains the category name, x value or datetime string depending on the type of axis. For datetime axes, the point.key date format can be set using tooltip.xDateFormat.Defaults to <span style="font-size: 10px">{point.key}</span><br/>. For example, value set to: <table> causes a chart to draw as follows:
tooltip.pointFormat	"Value"	The HTML of the point's line in the tooltip. Variables are enclosed by curly brackets. Available variables are point.x, point.y, series.name and series.color and other properties on the same form. Furthermore, point.y can be extended by the tooltip.valuePrefix and tooltip.valueSuffix variables. This can also be overridden for each series, which makes it a good hook for displaying units.Defaults to <span style="color:{point.color}">u25CF</span> {series.name}: <b>{point.y}</b><br/> For example, value set to: "" causes a chart to draw as follows:
tooltip.useHTML	true or false	Use HTML to render the contents of the tooltip instead of SVG. Using HTML allows advanced formatting like tables and images in the tooltip. It is also recommended for rtl languages as it works around rtl bugs in early Firefox. Defaults to false. For example, value set to: true causes a chart to draw as follows:
xAxis.alternateGridColor	Value	When using an alternate grid color, a band is painted across the plot area between every other grid line. For example, value set to: "false" causes a chart to draw as follows:
xAxis.gridLineWidth	Value	The width of the grid lines extending the ticks across the plot area. Defaults to 0. For example, value set to: causes a chart to draw as follows:
xAxis.labels.enabled	true or false	Enable or disable the axis labels. Defaults to true. For example, value set to: false causes a chart to draw as follows:
xAxis.tickWidth	Value	The pixel width of the major tick marks. Defaults to 1. For example, value set to: 0 causes a chart to draw as follows:
xAxis.title.margin	Value	The pixel distance between the axis labels or line and the title. Defaults to 0 for horizontal axes, 10 for vertical. For example, value set to: 16 causes a chart to draw as follows:
xAxis.title.style.fontSize	"Value"	For example, value set to: "20px" causes a chart to draw as follows:
xAxis.title.style.letterSpacing	"Value"	For example, value set to: "3px" causes a chart to draw as follows:
xAxis.title.text	Value	The actual text of the axis title. It can contain basic HTML text markup like <b>, <i> and spans with style. For example, value set to: "title" causes a chart to draw as follows:
xAxis.type	Value	The type of axis. Can be one of "linear", "logarithmic", "datetime" or "category". In a datetime axis, the numbers are given in milliseconds, and tick marks are placed on appropriate values like full hours or days. In a category axis, the point names of the chart's series are used for categories, if not a categories array is defined. Defaults to linear. For example, value set to: causes a chart to draw as follows:
yAxis.alternateGridColor xAxis.alternateGridColor	"color"	Sets alternating bands of grid colors along either the x-axis or y-axis of the chart plot area. The color value may be a color name (such as 'Black') or a hexadecimal code enclosed in double quotes. For example, a y-axis value set to: "Pink" causes a chart to draw as follows: Notes: Color Names and Hex Codes should not contain spaces. Hex codes should begin with #. If an unknown color name or code is defined, a black series value is returned. For a list of color hex codes, see: https://simple.wikipedia.org/wiki/Web_color
yAxis.gridLineWidth xAxis.gridLineWidth	Value	Sets the width of chart axis gridlines in pixels. For example, a y-axis value set to: 0 causes the following chart to appear:
yAxis.labels.distance	Value	Angular gauges and solid gauges only. The label's pixel distance from the perimeter of the plot area. Defaults to 15. For example, value set to: 20 causes a chart to draw as follows:
yAxis.labels.rotation	Value	Rotation of the labels in degrees. Defaults to 0. For example, value set to: "auto" causes a chart to draw as follows:
yAxis.lables.style.fontSize	CSSObject	CSS styles for the label. Use whiteSpace: 'nowrap' to prevent wrapping of category labels. Use textOverflow: 'none' to prevent ellipsis (dots). Defaults to {"color":"#6D869F","fontWeight":"bold"} For example, value set to: "12px" causes a chart to draw as follows:
yAxis.min	Value	The minimum value of the axis. If null the min value is automatically calculated. If the startOnTick option is true, the min value might be rounded down. The automatically calculated minimum value is also affected by floor, minPadding, minRange as well as series.threshold and series.softThreshold. For example, value set to: 0 causes a chart to draw as follows:
yAxis.max	Value	The maximum value of the axis. If null, the max value is automatically calculated. If the endOnTick option is true, the max value might be rounded up. The actual maximum value is also influenced by chart.alignTicks. For example, value set to: 300000 causes a chart to draw as follows:
yAxis.minorTickPosition	String	The position of the minor tick marks relative to the axis line. Can be one of inside and outside. Defaults to outside. For example, value set to: "inside" causes a chart to draw as follows:
yAxis.tickPosition	String	The position of the major tick marks relative to the axis line. Can be one of inside and outside. Defaults to outside. For example, value set to: "outside" causes a chart to draw as follows:
yAxis.title.margin	Value	The pixel distance between the axis labels and the title. Positive values are outside the axis line, negative are inside. Defaults to 40. For example, value set to: 8 causes a chart to draw as follows:
yAxis.title.style.fontSize	"Value"	CSS styles for the title. When titles are rotated they are rendered using vector graphic techniques and not all styles are applicable. Defaults to { "color": "#707070", "fontWeight": "bold" } For example, value set to: "18px" causes a chart to draw as follows:
yAxis.title.text	Value	The actual text of the axis title. Horizontal texts can contain HTML, but rotated texts are painted using vector techniques and must be clean text. The Y axis title is disabled by setting the text option to null. Defaults to Values. For example, value set to: "Store Sales" causes a chart to draw as follows:
yAxis.type xAxis.type	"logarithmic" "datetime" "category" "logarithmic" or "datetime"	The type of axis. Can be one of "linear", "logarithmic", "datetime" or "category". In a datetime axis, the numbers are given in milliseconds, and tick marks are placed on appropriate values like full hours or days. In a category axis, the point names of the chart's series are used for categories, if not a categories array is defined. For example, the y-axis value set to: "logarithmic" causes a chart to draw with a logarithmic scale y-axis as follows:

Please follow the below steps:

• Publish the resource in TDV
• Set up a JDBC connection to access it.
• Put csjdbc8.jar file from <drive>TDV Server 8.2appsjdbclib into JETL classpath (if using higher than Java 8, use csjdbc.jar)
• Driver class is cs.jdbc.driver.CompositeDriver
• JDBC URL looks like this: jdbc:compositesw:dbapi@<host>:<port>?domain=<domain>&dataSource=<dataSource>
• Domain is the domain name where the resource is published
• DataSource is the name you gave to the published resource.
• Port is 9401 by default
• jdbc:compositesw:dbapi@localhost:9401?
• domain=composite&dataSource=SugarCRM_Foodmart_CS
• Create a JDBC Connection in ETL using this string configuration.

Is it possible to use Spotfire Maps with JasperSoft Studio? If yes, does the user need to purchase it?

Resolution: 

Spotfire maps may be included in a dashboard (using the "Web Page" dashlet component). This would require separate Spotfire licensing. Otherwise, there is no connection between Jaspersoft and Spotfire.

For more information related to the web page dashlet, you can refer to the User guide - https://docs.tibco.com/pub/js-jrs/8.0.3/doc/pdf/TIB_js-jrs_8.0.0_User-Guide.pdf (Chapter 2.4.1 Creating a web page dashlet; Page 47)

This article is about using JMeter to perform some basic performance and concurrency testing on JasperReports Server. In this article, we will tackle some different scenarios:

• Executing canned reports
• Creating Ad Hoc Reports
• Simulating Concurrency

See also these screencasts for reference:

The numbers that the JMeter application generates could be used for benchmarking performance for different environments, basic load testing, and measuring gains after tuning.

The numbers that JMeter produces are best used and interpreted when we can compare them to another set of results, with each set of results representing a different set of conditions (e.g., different memory settings, different network throughput, different number of concurrent users, etc.)

The numbers will also vary from customer to customer, mainly because a customer's requirements vary; report size, query complexity, network latency, software versions and configuration as well as concurrency requirements all vary from customer to customer. When writing this article, I used the foodmart sample database that ships with JasperReports Server, since it gives any customer can use it if they've installed it. For systems with larger databases, the process would be the same.

Downloading and Installing JMeter

JMeter is a desktop Java application, and you can download it from http://jakarta.apache.org/jmeter.  The instructions below deal with JMeter version 2.4. Ideally you would install JMeter on a development and testing machine, with that machine being able to access the instance of JasperReports Server you want to test.

Configuring JMeter

With the JMeter proxy in place, you can create a test plan by simply visiting the web site you wish you test. Clicking around the website will add entries to your test plan. This is what it looks like when you first kick it off:

Create the Thread Group

1. Start JMeter
2. Select "Test Plan" on the tree
3. Right click on the "Test Plan" and add a new thread group: Add -> Threads -> Thread Group
4. Select the Thread Group
   1. At this stage, you can also define the number of threads to run when executing the test plan, which will mimic the number of concurrent users. I suggest using 50 as the initial value.
5. Right click and choose "Add -> Config Element -> HTTP Request Defaults"
   1. Server Name or IP: Fill it in with the environment you're going to test.
      1. This can be tricky if you're testing it on your own environment (localhost); I got a local test plan working by using a Ubuntu virtual environment running on my PC. JMeter doesn't seem to like recording steps that go through localhost.
   2. Port Number: the port number of the JRS instance you're testing; usually 8080 in default JRS installations
   3. There are boxes at the bottom that you can fill out to configure a proxy server, if necessary

Configure the JMeter Proxy

We're now going to create the Proxy Server using JMeter.

1. On the JMeter application, select workbench, right-click on it, and choose "Add -> Non-test Elements -> HTTP Proxy Server". We will need to modify some of its values:
   1. Port: Change it from 8080 to some other port that's not in use
   2. Target Controller: Choose "Test Plan -> Thread Group".
   3. Click the "Add" button in "Patterns to Include". Since we want to get an idea of overall server performance, add ".*" (minus the double-quotes) to the entry. That pattern means that it will consider all file requests coming from the server. You can limit it by specifying, for instance, only HTML files, only GIF files, etc, by defining the URL pattern that matches the file you want.
   4. Click the "Start" button - this kicks off the proxy

Note: When defining the proxy server, take note that after you save your test plan, and then close down JMeter, it will often appear that you have lost your proxy server configuration; my recommendation is to do the steps outlined in this document all in one go; that way you will have recorded your test plan, which is the main point of using the proxy server and JMeter, all in one go.

Configure your browser to go through the proxy

In this step, we configure the browser to make its HTTP requests go through the proxy server we just set up on JMeter. Once we have configured the browser in this way, all the HTTP requests the browser makes will go through the JMeter proxy server, which will in turn record these steps as part of the test plan we want to create.

You can do this with Internet Explorer, Firefox or Chrome; they each have settings where we can define the proxy server.

The Firefox and Internet Explorer settings go through the same process; the Chrome settings are slightly different, but achieve the same goal.

As a developer, since you're just running the JMeter application in your own test environment, it's fine to just set the proxy server to "localhost", since you are running JMeter locally anyway.

Create the Test Plan Using the Browser

The goal of the test plan will be to go through JasperReports Server UI, login, execute a series of reports, and create a sample ad hoc report. We will then execute the test plan. We can imagine a test plan covering at least these cases:

Now that you have the proxy server set up and running, and you have configured your browser to pass all the HTTP requests via the JMeter proxy server, you can now record your test plan. The general procedure is this:

• Use your browser to login to JasperReports Server
• Perform the functionality that you wish to load test
• Quit your browser when done

When you switch back to the JMeter application, you will find that JMeter has recorded the HTTP requests you executed in your browser:

The list of items on the left-hand side show all the HTTP requests that your browser made when interacting with JasperReports Server.

Turning on the Reporting Function

Now that we have the test plan defined, we'll switch on the reporting function, so that once we execute the test plan, we'll be able to see how well the application performed.

1. On the JMeter application, select the "Thread Group"
2. Right-click on the "Thread Group", and choose "Add -> Listener -> Aggregate Report"
3. With the "Thread Group" still selected, choose the number of threads, which represent the number of concurrent users.

Run the Test Plan

Now you are ready to kick off the test plan. You do this by choosing "Run -> Start" from the JMeter top-level menu.

While the test plan is running, you will see that the aggregate report is being filled in at the same time, and a little green box on the top-right corner of the JMeter application appears, indicating that it is currently running.

Note that there is a "Save Table Data" button - this will allow you to save the data the test plan generated, which you can then use to compare with different test scenarios.

Analyze JMeter logs

Use the aggregate report to test different environments, and not just the thread count. The environment includes elements like:

• JVM settings
• Application Server Thread Count
• Database Driver versions used
• Network Latency - throughput between different elements in the software stack
• Version of JasperReports Server that is used

Any element that is a candidate for tuning can be added to that list. The idea is to be able to compare JMeter aggregate reports for environments that use the different settings, and thus determine what impact each of the elements we have tuned have had on the overall aggregate performance: did it improve performance or not?

Other Performance Tips:

Measure and Test

• Test DB Queries with DBTester
• Measure Ad Hoc Performance

Ad Hoc

• Set query limits on the "Ad Hoc Options" page
• Modify the Ad Hoc caching values if your data does not update constantly

Tomcat

• Compress HTTP responses at the Tomcat level
• Increase the maximum thread count at the Tomcat level
• Set up a cache filter for Tomcat or JBoss
• Disable automatic deployment on production servers using Tomcat

Database

• Index columns in the database to speed up domain-based reports
• Set the fetch size in the jasperreports.properties file to modify the number of rows to fetch

JasperReports Configuration Items

• Modify Virtualizer Settings for Very Large Reports
• Modify the jasperreports.properties file to disable multi-line data processing

Resources

This article was based in no small part on the document below, which outlines the step-by-step procedure we discussed in this article.

• http://jakarta.apache.org/jmeter/usermanual/jmeter_proxy_step_by_step.pdf

Making part of the report text bold without using separate text fields.

Resolution:

User can use styled markup to set report field text element, then us style property to wrap around the text to make it bold.

<textField>
    <reportElement key="" x="0" y="0" width="570" height="30"/>
    <textElement markup="styled"/>
    <textFieldExpression>
        <![CDATA["<style isBold='true'>"+" Who: " + "</style>" + "Who"]]>
    </textFieldExpression>
</textField>

Here is the sample report template to demonstrate the approach:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.0.final using JasperReports Library version 6.3.0  -->
<!-- 2017-03-27T23:34:50 -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"
              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
              xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"
              name="test_1462146'
              pageWidth="612"
              pageHeight="792"
              columnWidth="555"
              leftMargin="20"
              rightMargin="20"
              topMargin="20"
              bottomMargin="20"
              uuid="3472a31c-35f4-4d5d-96fd-2fb1ae932baf">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
    <queryString>
        <![CDATA[]]>
    </queryString>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="79" splitType="Stretch">
            <textField>
                <reportElement key="" x="0" y="0" width="570" height="30" uuid="5036bc88-f2e3-4070-8639-50498dea4325"/>
                <textElement markup="styled"/>
                <textFieldExpression>
                    <![CDATA["<style isBold='true'>"+" Who: " + "</style>" + "Who"]]>
                </textFieldExpression>
            </textField>
        </band>
    </title>
    <pageHeader>
        <band height="35" splitType="Stretch"/>
    </pageHeader>
    <columnHeader>
        <band height="61" splitType="Stretch"/>
    </columnHeader>
    <detail>
        <band height="125" splitType="Stretch"/>
    </detail>
    <columnFooter>
        <band height="45" splitType="Stretch"/>
    </columnFooter>
    <pageFooter>
        <band height="54" splitType="Stretch"/>
    </pageFooter>
    <summary>
        <band height="42" splitType="Stretch"/>
    </summary>
</jasperReport>

TTC-20170331-01462146

Problem Statement: 

Our requirement is to block the upload of JRXML files in the user interface. There existed this setting in the documentation for version 6.0.1: 

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v601/restricting-file-uploads 

…/WEB-INF/flows/fileResourceBeans.xml

file.upload.max.size to 0, also tried 1 byte. But we are still able to upload a JRXML file.

We also tried to set a restricted regular expression for a file name and custom message in fileNameRegexp & fileNameValidationMessageKey 

But still no reaction from Jasper. Can you confirm are that the settings are still in use in version 7.9.2, or have been deprecated?  Can you please advise a way to block the upload of JRXML?

Solution:

You might be able to disable it by excluding all file extensions in the resource.locate.js (see below in the documentation). 

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v790/restricting-file-uploads (File upload Extensions)

Specifically, you can edit the <jasperserver-pro-war>/scripts/resource.locate.js file and modify the ALLOWED_FILE_RESOURCE_EXTENSIONS.

Problem Statement: 

Is there a maximum number of tables or columns that can be set in a set of domains and items? For example, is it possible to specify a table with 1000 columns per table in a 100-table domain and use it ad hoc? Also, does it depend on the database used (MySQL or Oracle, etc)?

Resolution: 

There is no maximum number of tables-configuration hardcoded as such for domains. This would purely depend on the database and its configurations. However, the more amount of data you have the greater would be the load on your application. And hence, this may cause a performance crunch. The baseline is that you can have as much data as required as long as the database can handle it. 

Domains are JSON and XML-based, hence, when the XML file is being parsed it may cause a slowdown if the domain file is heavy. This requirement would be more system configuration-specific rather than Jasperserver-specific. 

A report that contains a checkbox and the checkbox is displayed using Unicode in the text field. While exporting the report as Excel, the checkbox is displaying as expected while trying to export the report as PDF the checkbox is not displaying. 

Resolution:

The reason that the checkbox does not get exported in PDF is that the font being used does not have a checkbox symbol. As a workaround for this, you can use for example, DejaVu Sans which includes a built-in font extension to display the checkbox character. 

However, if you want to use the same font then the below criteria must be met: 

1. The font has glyphs for U+2610 and U+2611
2. The font extension uses Identity-H and PDF encoding and PDF embedding is enabled 

Is it possible to create user/role with a negative ID? By editing the JIUserRole table? 

Resolution: 

Generally, we do not allow manually executing queries on JIUserRole. Hence, there are no recommendations from our end. You would have to perform tests on this, in a lower environment in order to understand any impacts that might be caused due to this. 

(https://community.jaspersoft.com/wiki/custom-font-font-extension)

Question:

During my work with JasperReports Library I have got the error:

net.sf.jasperreports.engine.util.JRFontNotFoundException: Font 'Calibri' is not available to the JVM. See the Javadoc for more details.

Answer:

I would suggest that you should check the sample, that shows how to work

with font extensions, that is supplied with the product .

This sample (shipped with the JasperReports project distribution package under the

/demo/samples/fonts) contains jrxml report, configuration

files and ttf fonts that should be embedded to the pdf document.

Below I quote the link to the information from which you can start

(JasperReports Ultimate Guide v3.7 - Page 294 / SIMPLE FONT EXTENSION TUTORIAL):

The link below from the internet would be also helpful regarding this topic:

http://mdahlman.wordpress.com/2010/05/28/jaspersoft-v3-7-font-extensions/

You can generate a font extension file automatically in iReport and JasperSoft Studio.

For iReport, the latest version that is available in the Support Portal:

iReport Ultimate Guide/8.2 Using TrueType Fonts/Page 126

- install the font in iReport (tools -> options -> fonts -> 'Install Font'')

- generate a font extension jar file (tools -> options -> fonts -> 'Export as extension')

- add the generated font extension jar file as a resource to the report

You can also generate this file with the similar steps in JasperSoft Studio.

Font extension file should be placed in the

lib folder to make it available to your application.

P.S.:

You can download both aforementioned documents

(JasperReports Ultimate Guide and iReport Ultimate Guide)

from our community web page:

http://community.jaspersoft.com/documentation

It’s possible to use images stored in a database for your reports. Images stored in a database as stored as BLOBs, or in the case of Postgres as a BYTEA. The image gets stored as one of these binary data types.

This article goes over an example that does this, and which you can download.

File system vs. database storage for images

The usual strategy for storing images is to store image files on a file system and then have references to their file location in the database. Storing a reference in the database hardly takes up any space and having the file system host the images doesn’t require any extra processing when being served up by web servers.

Also, applications that use images stored in databases need to generate the right query to pull the image and then may need to do some post-processing to use the image in an application, which adds to the response latency, as well as adding load to the database.

On the other hand, storing images in a database has its advantages. It’s easier to backup the images using the database’s own functions, provide transactional integrity (if necessary), and storing them in a database adds an extra layer of security – it’s a lot harder to get at them if they’re in a database than if they’re in a file system.

Most of the time, it will make more sense to have the images stored in the file system, but you should be aware of situations where it may be advantageous to store them in a database.

What to do in the report design

You’ll design your report query as you normally would, selecting the image field as part of the SQL statement.

Next, you’ll need to set the field class type to java.awt.Image. The screenshot below is from iReport, in Jaspersoft Studio, it’s a similar process.

Next, add an Image element from the palette to the band in the report design and then modify the the Image Expression class to java.awt.Image (thus matching the field type), and set the Image expression to the field holding your image.

As you can see in the image below, the expression class is set to java.awt.Image.

Example

The example attached to this page requires you to download the ZIP file and unzip it to C:TEMP (if you don’t, you’ll need to modify the image-loading commands) and have either MySQL or Postgres.

Choose the MySQL or Postgres scripts, which will create a sample table in the database and store the images in the database.

Once you complete the database steps, open up the JRXML file and execute it – you’ll need to make sure you’re pointing at the right database, and you should be good to go.

blobexample_reports.zip

<hc:chartProperty name="colors">
    <hc:propertyExpression><![CDATA[Arrays.asList("rgba(245,60,20,0.5)","rgba(50,255,90,0.5)","rgba(90,200,100,0.5)","rgba(220,100,220,0.5)","rgba(80,200,90,0.5)","rgba(255,70,100,0.5)")]]></hc:propertyExpression>
</hc:chartProperty>

-> https://www.highcharts.com/docs/chart-design-and-style/colors

Please find attached report jrxml which works with Sample DB in JSS and with foodmart in jrs.

charts_4.jrxml

Problem Statement:

The user has installed Jaspersoft Studio 8.2. When they opened the Jaspersoft Studio, they saw the error "Edge browser engine is not setup. HTML and JRIO Preview will not work fine".

Solution:

-- This issue generally occurs when the user hasn't installed the webview for Microsoft Edge.

-- Please download the webview from the below link:
https://developer.microsoft.com/en-us/microsoft-edge/webview2/

Here, the recommended option is 'Fixed Version'. Select the architecture as 'x64'.

-- After extracting the package in the local machine, we have added the two properties to Jaspersoft Studio Professional.ini file:

    -Dorg.eclipse.swt.browser.DefaultType=edge
    -Dorg.eclipse.swt.browser.EdgeDir=C:\dev\Jaspersoft\Microsoft.WebView2.FixedVersionRuntime.114.0.1823.51.x64  --> This is the path where we extracted the folder.

-- After saving these configurations, restart Jaspersoft Studio, and this error was removed from the Jaspersoft Studio screen.

(Reference: https://community.jaspersoft.com/documentation/jaspersoft-studio-user-guide-820/v820/using-edge-jaspersoft-studio-window-builds)

Ref Case: #02190934

• Set the logging level to DEBUG for SQL queries - that will allow you to see the underlying query that the domain-based report generates that is then passed on to the database.
• Then run that query directly on the database to check for performance. You can then tune the database by indexing the field in the query that would have the best impact on report execution

Regarding materialized views: they are just SQL statements--you have to put indexes on the tables that pertain to the materialized view queries to get better performance from them.

You should actually get better performance on the switch from derived to actual tables, if you are using derived tables, because derived tables are sub-queries/sub-selects and are intensive performance-wise--much more so than a direct table access with some security level filters applied.

It's all about how the SQL ends up being generated by the domain as well as how the optimizer optimizes that SQL--coupled with the table indexes involved in the joins.

Other Performance Tips:

Measure and Test

• Test DB Queries with DBTester
• Do Performance Testing with JMeter
• Measure Ad Hoc Performance

Ad Hoc

• Set query limits on the "Ad Hoc Options" page
• Modify the Ad Hoc caching values if your data does not update constantly

Tomcat

• Compress HTTP responses at the Tomcat level
• Increase the maximum thread count at the Tomcat level
• Set up a cache filter for Tomcat or JBoss
• Disable automatic deployment on production servers using Tomcat

Database

• Set the fetch size in the jasperreports.properties file to modify the number of rows to fetch

JasperReports Configuration Items

• Modify Virtualizer Settings for Very Large Reports
• Modify the jasperreports.properties file to disable multi-line data processing

Problem Statement:

How can the user add the custom logo to the login page and hide the options for 'Show locale and time zone' and 'Need help logging in?'

Solution:

To add the custom logo and Hide the options for the 'Show locale and time zone' and 'Need help logging in?', user need to create a new custom theme. 

Please follow the below steps to apply the custom theme:

    1. Navigate to View --> Repository.

    2. Create one folder under the Themes whose name is 'BT_Theme' in my case.

    3. Insert the overrides_custom.css file under this folder. To do this, please right-click on the folder, --> choose Add resource -->  File --> CSS. Add the file that is present in the case attachments.
    
    4. We have inserted one image under the path /themes/BT_Theme/images/.

    5. Once the user makes the changes, please make this custom theme as active theme. To do this, right-click on the folder and select 'Set as Active Theme'.

    6. Log out from the JRS. The user could see the new logo instead of the default logo. Also, those two options are now hidden.

Ref Case: #02212890

overrides_custom_8.css