Suppose you have an HTML5 multiaxis chart with both primary and secondary axes on the left side.  You want to put the primary axis on the left side and the secondary axis on the right side.

Solution:

<hc:chartSetting name="default">
    <hc:chartProperty name="yaxis.opposite" value="true"/>
</hc:chartSetting>

Requirement

Jaspersoft® Studio report includes dynamic parameter values and looks like this:

http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/reports/iReports/Test/Portfolio_Information_Details.xlsx?ignorePagination=true&P_PORT_POSITION="+$P{P_PORT_POSITION}+"&P_UNIT_ID="+$P{P_UNIT_ID}+"&P_REGIONS_ONLY="+$P{P_REGIONS_ONLY}+"&P_UNIT_ROLLUP="+$P{P_UNIT_ROLLUP}

The issue is that the parameter "P_PORT_POSITION" is a collection type and can pass multiple values to the exporting report.

When multiple values are passed, it looks like this: "&P_PORT_POSITION=[001,054]":

http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/reports/iReports/Test/Portfolio_Information_Details.xlsx?ignorePagination=true&P_PORT_POSITION=[001,%20054]&P_UNIT_ID=90001010&P_REGIONS_ONLY=false&P_UNIT_ROLLUP=true

You can see "&P_PORT_POSITION=[001,%20054]" is passed, which isn't a valid value so the export report runs for all P_PORT_POSITION values instead of just 001 and 054.

According to Jaspersoft® Server REST API guide , there is an example, which mentions "input controls that are multi-select may appear more than once" (but, those are hardcoded values.):

GET http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/reports/samples/Cascading_multi_select_report.html?Country_multi_select=USA&Cascading_state_multi_select=WA&Cascading_state_multi_select=CA

Anyway, it doesn't show how to do it dynamically.

Is there a way to split these collection values for passing them correctly, such as "&P_PORT_POSITION=001&P_PORT_POSITION=054"?

Solution

As workaround, you can do something like:

http://<host>:<port>/jasperserver[-pro]/rest_v2/...&P_PORT_POSITION=" + String.join("&P_PORT_POSITION=", $P{P_PORT_POSITION}) + ...

If you need to consider the case of P_PORT_POSITION is empty, you will have to do this more complex:

http://<host>:<port>/jasperserver[-pro]/rest_v2/..." + (($P{P_PORT_POSITION} == null || $P{P_PORT_POSITION}.isEmpty()) ? "" : ("&P_PORT_POSITION=" + String.join("&P_PORT_POSITION=", $P{P_PORT_POSITION}))) + ...

VO - 20190329, case #01690565

Show current organization name beside the username in the banner to the right next to <userID>, Logout, Help.

Solution

In

<js-install folder>\apache-tomcat\webapps\jasperserver-pro\WEB-INF\decorators\decorator.jsp change the <li id="userID" role="menuitem"> 

as follows:                 

<li id="userID" role="menuitem">
   <span id="casted">
      <c:if test="<%= com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.isUserSwitched() %>">
         <c:set var="principalUserFullName"
                value="<%= ((com.jaspersoft.jasperserver.api.metadata.user.domain.User)
                           com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getSourceAuthentication().getPrincipal()).getFullName() %>"/>
         ${principalUserFullName}
         <spring:message code="jsp.main.as"/>
      </c:if>
   </span>
   <span id="casted1">
      <c:if test="<%= com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.isUserSwitched() %>">
         <c:set var="principalUserFullName1"
                value="<%= ((com.jaspersoft.jasperserver.api.metadata.user.domain.User)
                           com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getSourceAuthentication().getPrincipal()).getTenantId() %>"/>
         ${principalUserFullName1} 
         <spring:message code="jsp.main.as"/>
                                    </c:if>
   </span>
   <authz:authentication property="principal.fullName"/>
      | 
   <authz:authentication property="principal.TenantId"/>
</li>

IMPORTANT! Please note that the solution is considered experimental, and is not officially tested or supported. Use it at your own risk.

Ref. Case #01740297 

Customer created an Ad Hoc Report with dual-axis chart.

He would like to assign the second Ad Hoc Measure to the first Y-axis, instead of the second, by default, one.

Resolution

In TIBCO JasperReports® Server v.7.1.0 and newer version, you can set chart properties with array indices in JRXML.

So if the related Ad Hoc View only has measures on the columns axis, you can directly set the yAxis properties of a series like this:

<jrhc:chartSetting name="_jrs_adhoc">......</jrhc:chartSetting><jrhc:chartSetting name="default"><jrhc:chartProperty name="series[1].yAxis"><jrhc:propertyExpression><![CDATA[0]]></jrhc:propertyExpression></jrhc:chartProperty></jrhc:chartSetting>[/code]

This puts the second measure/series (series[1]) on the first axis (0).

The solution will not work with version of  TIBCO JasperReports® Server less than 7.1.0 as property name "series[1].yAxis" will not be recoginzed

AS-20190403, case #01713498

Someone might want timestamp-based values from their database use a specific timezone, like the server timezone for example, but they might have report-rendering timestamps (for example a "ran on" value in a title or summary) that they'd like to show in the user's timezone.

Resolution

You can specify a timezone adjustment at an element level via this property:

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.pattern.timezone

If you're using JRS and wanted to specify the user's timezone defined for them during login you'd set the element to REPORT_TIME_ZONE.  Select the field in your report design in Jaspersoft Studio, then in the Properties panel select Advanced > Misc > Properties. Add new property with name: net.sf.jasperreports.pattern.timezone and value: REPORT_TIME_ZONE

Example:

<element kind="ellipse" positionType="Float" mode="Opaque" width="25" height="25">
  <pen lineWidth="1.0"/>
  <property name="net.sf.jasperreports.export.pdf.field.type" value="Check"/>
  <property name="net.sf.jasperreports.export.pdf.field.check.type" value="Square"/>
  <property name="net.sf.jasperreports.export.pdf.field.border.style" value="Beveled"/>
  <property name="net.sf.jasperreports.export.pdf.field.read.only" value="true"/>
  <property name="net.sf.jasperreports.export.pdf.field.checked" value="true"/>
</element>

Text Input Fields
Textboxes are text input fields. They can be either single line or multi line textboxes. To specify which kind of textbox is considered, we can set the following flag property per report element: net.sf.jasperreports.export.pdf.field.text.multiline. The initial text content of the input field is provided by the net.sf.jasperreports.export.pdf.field.value custom property and in case that one is missing, then the actual text content of the JasperReports text element is used instead.

Example:

<element kind="textField" positionType="Float" mode="Opaque"
  x="250" width="200" height="45" forecolor="#FFFF00" backcolor="#0000FF" hTextAlign="Right" fontName="DejaVu Serif" fontSize="24.0">
  <expression><![CDATA["This\nis a multi\nline text inside a multi line text field."]] ></expression>
  <property name="net.sf.jasperreports.export.pdf.field.type" value="Text"/>
  <property name="net.sf.jasperreports.export.pdf.field.text.multiline" value="true"/>
  <property name="net.sf.jasperreports.print.keep.full.text" value="true"/>
</element>

List and Combobox Input Fields
List and combobox input fields can be populated by setting the following property: net.sf.jasperreports.export.pdf.field.choices. Its value contains list items separated by a special character or set of characters provided by the net.sf.jasperreports.export.pdf.field.choice.separators property. If not set, the default separator is '|'.

Example:

<element kind="textField" positionType="Float" mode="Opaque" width="200" height="95" forecolor="#00FFFF" backcolor="#00FF00"
hTextAlign="Center" fontName="DejaVu Serif" bold="true" fontSize="24.0">
  <expression><![CDATA["This text does not matter in PDF export."]] ></expression>
  <property name="net.sf.jasperreports.export.pdf.field.type" value="List"/>
  <property name="net.sf.jasperreports.export.pdf.field.choice.separators" value=","/>
  <property name="net.sf.jasperreports.export.pdf.field.choices" value="Un,Deux,Trois,Quatre,Cinq"/>
  <property name="net.sf.jasperreports.export.pdf.field.value" value="Quatre"/>
  <box>
    <pen lineWidth="2.0" lineStyle="Dashed" lineColor="#FF0000"/>
  </box>
</element>

In case we need the textbox in the combobox field to be editable, we can set the net.sf.jasperreports.export.pdf.field.combo.edit property per combobox element, while the a preselected value can be set using the net.sf.jasperreports.export.pdf.field.value property:

<element kind="textField" ... forecolor="#0000FF" backcolor="#FFFF00" hTextAlign="Center" fontName="DejaVu Serif" bold="true" fontSize="24.0">
  <expression><![CDATA["This text does not matter in PDF export."]] ></expression>
  <property name="net.sf.jasperreports.export.pdf.field.type" value="Combo"/>
  <property name="net.sf.jasperreports.export.pdf.field.choices" value="One|Two|Three|Four|Five"/>
  <property name="net.sf.jasperreports.export.pdf.field.combo.edit" value="true"/>
</element>

Checkbox Input Field
In order to properly set a checkbox we need to know how it's decorated and whether it's checked or no. We can set the checkbox appearance by using the net.sf.jasperreports.export.pdf.field.check.type property with the following possible values:

Check - specifies a checkbox type decoration
Circle - specifies a circle tipe decoration
Cross - specifies a cross type decoration
Diamond - specifies a diamond type decoration
Square - specifies a square type decoration
Star - specifies a star type decoration

To indicate if the checkbox is checked when the PDF document is open, we can use the net.sf.jasperreports.export.pdf.field.checked property, as in the following example:

<element kind="ellipse"  positionType="Float" mode="Opaque" width="25" height="25">
  <pen lineWidth="1.0"/>
  <property name="net.sf.jasperreports.export.pdf.field.type" value="Check"/>
  <property name="net.sf.jasperreports.export.pdf.field.check.type" value="Square"/>
  <property name="net.sf.jasperreports.export.pdf.field.border.style" value="Beveled"/>
  <property name="net.sf.jasperreports.export.pdf.field.read.only" value="true"/>
  <property name="net.sf.jasperreports.export.pdf.field.checked" value="true"/>
</element>

Radio Groups
Radio groups are radio option input fields grouped together so that only a single option can be selected at a time. To group together several radio options we can use the net.sf.jasperreports.export.pdf.field.name property. By assigning the same name for multiple JasperReports elements, they will be automatically grouped as radio options. To decorate these radio elements we can use the same net.sf.jasperreports.export.pdf.field.check.type property with the same possible values as for checkboxes. Also, to indicate which option is selected when opening the document, we can use the net.sf.jasperreports.export.pdf.field.checked property.

Example:

<element kind="textField" positionType="Float" mode="Opaque" x="250" width="25" height="25">
  <expression><![CDATA["This text does not matter in PDF export."]] ></expression>
  <property name="net.sf.jasperreports.export.pdf.field.name" value="MyRadioGroup"/>
  <property name="net.sf.jasperreports.export.pdf.field.type" value="Radio"/>
  <property name="net.sf.jasperreports.export.pdf.field.check.type" value="Check"/>
  <box>
    <pen lineWidth="1.0"/>
  </box>
</element>
...
<element kind="textField" positionType="Float" mode="Opaque" x="250" width="25" height="25">
  <expression><![CDATA["This text does not matter in PDF export."]] ></expression>
  <property name="net.sf.jasperreports.export.pdf.field.name" value="MyRadioGroup"/>
  <property name="net.sf.jasperreports.export.pdf.field.type" value="Radio"/>
  <property name="net.sf.jasperreports.export.pdf.field.check.type" value="Circle"/>
  <property name="net.sf.jasperreports.export.pdf.field.checked" value="true"/>
  <box>
    <pen lineWidth="1.0"/>
  </box>
</element>
...
<element kind="textField" positionType="Float" mode="Opaque" x="250" width="25" height="25">
  <expression><![CDATA["This text does not matter in PDF export."]] ></expression>
  <property name="net.sf.jasperreports.export.pdf.field.name" value="MyRadioGroup"/>
  <property name="net.sf.jasperreports.export.pdf.field.type" value="Radio"/>
  <property name="net.sf.jasperreports.export.pdf.field.check.type" value="Cross"/>
  <box>
    <pen lineWidth="1.0"/>
  </box>
</element>
...

FormsReport (1).jrxml

When user creates a a TreeMap in Jaspersoft Studio, there might be a need to display several categories of data on chart:

By default, TreeMap won`t show several categories, but will make a drill down from level one to level two, which can be accessed via clicking on chart series

Solution

It is possible to do this with Chart Properties in Jaspersoft Studio. For this you need to open Chart Properties > Go to Advanced Chart Properties > PlotOptions >Treemap > dataLablels > Enabled and set it to true (plotOptions.treemap.dataLabels.enabled). The result will be the following:

By default the result will be following:

If to click on Retailer 57 rectangle this will open next level of chart via drill down:

References

TreeMap JS Sample

ref case - 01786140 akovach

treemap_levels.jrxml

[toc on_off::hide=1]

Customer has a few reports that utilize the detail band to iterate through 60-100 records and display a high chart (a simple one bar "gauge" type chart). They have noticed that the performance of the highcharts rendering really slows down the report. The data comes back within a few seconds, but then the report has to "wait" until each high chart renders. Result report contains about 100 bar charts in a single page:

Issue:

It appears, charts (especially in every page) significantly increase report execution time. Also, render time depends a lot of its appearance ( how customized is it). Also, it is not always the best practice to place charts in detail band of the report. Unless that's what are your requirements.

Resolution:

Important note: This resolution can fully be applicable only to this usecase. For other types of charts or usecases, this article can be considered as a list of possible suggestions of how to improve charts rendering time.

First - Given that the charts are just a simple bar charts, one option would be to give up using Highcharts and write some code that creates SVGs or PNGs for the charts. Or you can even write the SVG directly in the image expression. I shall attach "image_sample" report, as an example. But it appears, it's not especially pretty.

Second - If you need to stick to Highcharts, there might be a few changes that would slightly improve the time it takes to render the charts. For instance you can set the com.jaspersoft.jasperreports.highcharts.interactive property to false (at chart element level) to disable the interactive chart type change action. And maybe, depending on the chart type, some chart properties can be tweaked to reduce the work done by Highcharts. 

Regarding this,  it seems that setting the com.jaspersoft.jasperreports.highcharts.interactive to false for the element, and setting the xAxis.labels.enabled and yAxis.labels.enabled chart properties to false resulted in a noticeable performance improvement (on Chrome at least). Also, attaching the "chart_sample" report that I tested.

Other changes in the way the charts are rendered would involve modifying the JR/S JavaScript code. A cleanup might also help to some degree, the chart seems to have several properties that are useless (e.g. plotOptions.pie.showInLegend).

chart_sample.jrxml

image_sample.jrxml

Normally, if you are using the following name and key in jasperreports.properties for displaying GeoAnalytics map, it should work. 

com.jaspersoft.jasperreports.tibco.maps.customer.name=myname

com.jaspersoft.jasperreports.tibco.maps.customer.key=jDZ76WBa8TE=

There is one situation when these values are ignored and an error is displayed in the browser debug panel [F12] Console tab,

        Uncaught Error:  Please set the geocoder customer and key.

The problem is not the equal sign in the key.  This problem can happen in the following situation.  You entered the name and key values in Jaspersoft Studio Tibco Maps properties.

The report works fine in Jaspersoft Studio, or as a report published from Jaspersoft Studio to a jasperserver installation.  

However, if you blank out these values in the jrxml, and expect jasperserver to read the name and key from jasperreports.properties.

For example,

<c:itemProperty name=""/>

<c:itemProperty name=""/>

jasperreports library will ignore the name and key defined in jasperreports.properties.  Hence, the error.

This is a bug being addressed as JRL-1400 to be fixed in a future release.

Workaround:

Remove these 2 lines from the jrxml entirely:

<c:itemProperty name=""/>

<c:itemProperty name=""/>

Steps to Disable Sub-Queries:

1. Locate the configuration file: jasperserver-pro/WEB-INF/js.config.properties.

2. Open the file in a text editor.

3. Add or update the following property:
skip.adhoc.datasource.check=true

4. Save the changes and restart the JasperServer application for the changes to take effect.

NOTE: If skip.adhoc.datasource.check is enabled, avoid using ad hoc reports as a data source, as they may not be properly filtered.

By implementing this change, users can enhance the performance of the Data Chooser when handling large repositories of ad hoc reports and views.

User created a report with HTML 5 chart with an background image as described in article:

https://community.jaspersoft.com/blog/tip-how-set-background-image-columnbar-chart-html-5-charts-jaspersoft-studio-reports

When previewing the report in Jaspersoft Studio, the background image is only shown in the HTML report output.

It is not visible in other export formats (PDF, DOCX ...).

How to make the image visible in the other formats?

Resolution

In order to get background image in PDF/DOCX export, Jaspersoft Studio requires PhantomJS library to de installed in the PC

and property

com.jaspersoft.jasperreports.highcharts.phantomjs.executable.path[/code]

should be added with path to PhantomJS binary in Windows > Preferences menu:

PhantomJS library is used to render HTML5 charts by JasperReports Library:

https://community.jaspersoft.com/wiki/phantomjs-libary-jasperreports-server

In case of using Jaspersoft Studio in MS Windows, back-slash characters in the path should be doubled.

Solution tested with Jaspersoft Studio v.7.3.0

AS-20190823, case #01794957

How to configure TIBCO JasperReports^® Server to allow access to Ad Hoc Cache for administrators (ROLE_ADMINISTRATOR)?

Resolution

By default, only superuser (ROLE_SUPERUSER) has access to Manage > Server Settings > Ad Hoc Cache menu.

In order to allow users with ROLE_ADMINISTRATOR role access the menu, the following steps should be performed:

• open WEB-INF/applicationContext-security-pro-web.xml configuration file
• locate bean class="com.jaspersoft.jasperserver.api.common.util.spring.GenericBeanUpdater"
• add ROLE_ADMINISTRATOR role to designerCacheFlow property:  designerCacheFlow=ROLE_SUPERUSER,ROLE_ADMINISTRATOR
• save the changes, restart the server

After these steps Ad Hoc Cache menu is accessible to users that belong to ROLE_ADMINISTRATOR ROLE using below URL:

http://localhost:8080/jasperserver-pro/flow.html?_flowId=designerCacheFlow

Solution tested with TIBCO JasperReports^® Server

AS-20191016, case #01735077

Characters are nomally displayed horizontally in a text field.  For example, ABCDEFG.  Is there a text property to make the text display vertically?

Workaround

There is no text property to make a string display vertically.  You can try the following workaround.

Insert carriage return line feed between characters:

A /r/n B /r/n C /r/n D /r/n E /r/n F /r/n G /r/n 

You will end up with:

A

B

C

D

E

F

G

When using a print when expression, a style is not working for each text field. This worked as intended before, but when a print when expression to hide the whole text field if a certain condition is met, it removes the style in the cell as well. 

Solution:

If you have a certain style in mind, one way to still have the style or color printed in a cell, you can put a frame into the text field and put the color used in the frame. The frame is always present, so if the print when expression is met and the text field is blank, the style and color will still be printed.

ref: 01813146

You are trying to delete organization folders that are no longer needed, but you are getting an error and unable to delete the folders even with superuser permissions.

Workaround:

There might be some unknown reasons for this issue.  At least in one instance, it works if you delete the subfolders under the organization first.

Especially after import with --all option, sometimes the repository screens are messed up.  That is, layout components are not aligned or style components are missing.  Generally, the discrepancy can be resolved by importing the /root/Themes folder from a standard install of the same version of jasperserver to restore the default files.  These files may have been inadvertantly deleted or altered for some reason.  Perhaps when adding customizations to the Themes folder.

If the above solution does not work, there is also another possible cause.  Check and see if you are running on a cluster with a loadbalancer.  If so, the cause is external.  Examine the HAR trace to see what files might be missing or if there are any errors.

Solution:

The problem may be related to serving static content such as CSS, Javascript, images etc. There usually are load balancing rules that determine how to deal with these types of files.  Since all these files are within the TIBCO JasperReports^® Server web applicatoin, the user needs to be logged in to get them.  Sticky session needs to work for these.  The theme.css file is actually dynamic content that has to come from the logged in JasperReports^® Server instance.  Work with your IT administrator to make sure that these files can come through the load balancer.

When using the REST API URL  http://localhost:8080/jasperserver-pro/rest_v2/resources  we are not getting all the resources present in the Jasperserver. How to get all the resources in the JSON response?

Resolution:

By default, the JSON response is limited to 100 records/resources. If you need to retrieve more resources, you must apply the limit filter and adjust it accordingly.

For example:

http://localhost:8080/jasperserver-pro/rest_v2/resources?limit=1000

Customer faced an issue when they are republishing report (no changes in the report's name or id) with schedule.

Sceanario:
1. We have a report X with schedule in folder A.
2. We did some changes on it and republished it to folder B.
3. Once the report is confirmed, we want to move it from folder B to folder A using the server only (copy and paste). Recently we pasted it, and it appears to be as a separate copy like "X 1.".

Expected result
Overwrite and keep excising schedule.

Actual Result:
The report is getting pasted as a separate copy.

Use case:
In step 2 they are pasting it in separate folder for testing and verification with a client.

Solution:
Currently JRS repository do not ask if you want to replace the existing resource or not, it just makes a new copy with _1 added to URI of resource.

It would be suggested to use studio report better to have the edit done by Web studio(JRWS) with the same changes done in report in folder B .
Otherwise publish to same folder A after changes.

When exporting a report to CSV, some text fields contain double quotes ( "" ) and some do not. For consistency, they would like the text field to either contain double quotes or do not contain double quotes.

Solution:

The problem is that the text field in question sometimes contains commas. By default, fields are separated by a comma in a CSV generation, and fields that contain commas will be enclosed into double quotes (double quotes is the default field enclosure character).

You can change this behavior in several ways, depending on your further needs:

 1. You could change the default field separator character, using the "net.sf.jasperreports.export.csv.field.delimiter" property in the report. For instance:

 <property name="net.sf.jasperreports.export.csv.field.delimiter" value="|"/>

 In this case, fields will be separated by a pipe character ( | ) in the CSV file, and texts will be no longer surrounded by double quotes. Here I chose the | character because some texts also contain semicolons (;), so we cannot choose semicolons as separators to fix the problem.

 or:

 2. You could set the net.sf.jasperreports.export.csv.force.field.enclosure property to true in their report. In this case, any text in any column, including Description, will be surrounded by quotes.

 or:

 3. You could use a 0-width space character (Unicode u200B) as field field enclosure:

 <propertyExpression name="net.sf.jasperreports.export.csv.field.enclosure">

 <![CDATA["u200B"]]>

 </propertyExpression>

 In this case, only texts that contain commas will be enclosed with a space character, but this space has width=0, so it won't be visible.

Finally, if you need a TXT file, better is to use the Text exporter, not CSV.

 Here is an example of using the Text exporter:

 http://jasperreports.sourceforge.net/sample.reference/text/index.html#textexport

ref Support Case Number: 01804948

In Jaspersoft Studio it is possible to make Studio offer its own SSL client-side certificate in a mutual authentication scenario in which both the server and the client provide their certificate for authentication to each other.

Resolution - basic steps

NOTE: Please note that using client-side certificates is only supported by the Jaspersoft Community (community.jaspersoft.com). TIBCO Jaspersoft Technical Support and Engineering do not support it.

First, create the certificate: 

Before you begin, ensure you have configured your application server to require client-side certificates. Then create a client certificate as a Java keystore file, for example, client_keystore.jks. Consult the documentation your application server the Java documentation for keytool or other tools used for certificate and/or java keystore creation. 

Second, configure Studio.  Studio can make use of a jks or pkcs12 store.  You define the location of your keyStore via either JVM arguments or via Studio's Key Store user-interface.

Via JVM Arguments:

1. From the command line on the client machine running Studio, import the store file, for example, client_keystore.jks, into your keystore on the client machine. (Create a new keystore if necessary).   Consult the documentation for Java's keytool.

WARNING: A client-side certificate contains a public key for the client. Make sure to follow your corporate security policies when creating, copying, and using client-side certificates.

2. Start Studio using JVM arguments by editing the Jaspersoft Studio Professional.ini file:

-Djavax.net.ssl.keyStore specifies the keystore file.

-Djavax.net.ssl.keyStorePassword specifies the passphrase of the keystore.

-Djavax.net.ssl.keyStoreType specifies the store type

Via Jaspersoft Studio's Key Store Interface:

In this case, you do not have to add JVM arguments when you start JSS.

1. In JSS, go to Preferences->Jaspersoft Studio->JasperReports Server->Key Store

2. Click Add and select the keystore you created.

When importing views or reports with the superuser account, reports or views with schedules do not import and an error appears on screen. The log file had the following erorr:

"Substitution error in resource /organizations/ORG1/Domains/lm/Folder1/Example.xml, field . Attribute 'User_Id' is not defined in the Entire hierarchy"

This only happens with the superuser account and if external authenication is present.

Solution:

This specific issue is caused by external authentication and profile attributes. By default, JasperReports Server specific users do not have profile attributes. Once those specific profile attributes were added to the superuser account, the Superuser account no longer had this issue.

ref: 01816416

By default, when parameters are published from Jaspersoft Studio to JasperReports Server, an Input Control is created and the resource ID and label have the same value, which is based upon the parameter element's name attribute. Through the JasperReports Server UI you can edit the label, or you can use Studio to specify the label prior to publish.

Resolution

Set the com.jaspersoft.studio.js.ic.label property on the parameter's element to specify a label.

For example:

<parameter name="City" class="java.lang.String">
   <property name="com.jaspersoft.studio.js.ic.label">
      <![CDATA["Customer City Name"]]>
   </property>
   <parameterDescription>
      <![CDATA["City parameter for controlling where clause"]]>
   </parameterDescription>
   <defaultValueExpression>
      <![CDATA["Raleigh"]]>
   </defaultValueExpression>
</parameter>

When your instance of JasperReports Server is configured to run over secured connections using SSL, Jaspersoft Studio will be unable to connect to it with a standard configuration. This can manifest in the inability to browse the server repository, publish reports, or utilize other server-dependent features within Jaspersoft Studio. The issue may stem from various factors, including outdated or mismatched security certificates, incorrect SSL configuration settings in Jaspersoft Studio, or issues with the Java trust store.

Resolution

To resolve SSL-related connection issues between Jaspersoft Studio and JasperReports Server, follow these steps:

1. Verify Server URL and Credentials: Ensure the URL used in Jaspersoft Studio to connect to JasperReports Server is accurate, including the correct protocol (https://) and port number. Double-check the username and password for the server connection to rule out authentication errors.

2. Configure SSL Properties: For advanced SSL configuration, access the "Advanced Settings" in the Server Profile wizard. Here, you can fine-tune SSL properties, such as the location of the trust store and other security-related settings. 

3. Check SSL Certificate: When establishing the connection, Jaspersoft Studio presents the server's SSL certificate. Examine the certificate details to confirm it is valid and issued for the server you are trying to connect to. If the certificate is self-signed or not issued by a trusted Certificate Authority, you may need to add it to the Java trust store.

4. Trust the Certificate: If the SSL certificate is valid, click the "Trust" button in Jaspersoft Studio to add it to the trusted certificates. This prevents the certificate prompt from appearing each time you connect to the server.

5. Consult Documentation and Support: If connection issues persist, refer to the Jaspersoft Studio User Guide and online resources  (lin) for detailed troubleshooting steps. For further assistance, contact Jaspersoft Technical Support for expert guidance.
   • Current Jaspersoft Studio User Guide available at: https://community.jaspersoft.com/documentation/
   • Or direct link to the corresponding chapter for version 9:

    

Remember, ensuring a secure connection between Jaspersoft Studio and JasperReports Server is crucial for protecting sensitive data and maintaining the integrity of your reporting environment.

Visualize.js is a JavaScript API framework used to embed JasperReport Server reports & visualizations inside web applications. It comes bundled with the commercial editions of JasperReports^® Server, specifically Jaspersoft AWS, Enterprise or Professional. Visualize.js currently does not support JasperReports Server Community Edition or the JasperReports^® Library. With Visualize.js, developers can embed interactive HTML5 visualizations, dashboards or multi-element reports using standard JavaScript. Developers can quickly and easily call backend JasperReports Server services using REST calls for common functions such as user authentication, data connectivity, repository services and more.

Quick Start

1. Download the commercial edition of JasperReports Server

2. Use the installation and configuration instructions

3. Watch the tutorials for step-by-step instruction

4. Once you have JasperReports Server installed, view and interact with samples using jsfiddles

5. View the JasperReports Server Visualize.js Guide in the documentation

• Date: December 18, 2012
• Products Covered: JasperReports Server, iReport, JasperReports
• Presenter: Teodor Danciu
• Abstract: For this show we have a very special guest, technical co-founder of Jaspersoft and JasperReports Architect, Teodor Danciu. In the first part of the show you'll learn how to make the most out of the JasperReports Library, particularly we'll look at access to previous record values (going back in time), pure data exporters, advanced Excel exports and data snapshots. This topic is recommended for users of Jaspersoft's tools that have a good grasp on the basic concepts, though you will surely learn something no matter what level of experience you have. Q & A to follow.

References: