[Handling DateTime parameter in JasperStudio to JasperServer]

Hello,

please try to use java.sql.Timestamp type for the parameter that is associated with the input control. java.util.Date strips the time part when the value comes from a JasperServer input control

[Running total or cummulative sum in Jasper reports]

For ad hoc, unfortunately, there is no way to create a running total right now. You can create group totals, row totals, column totals or total totals but not running totals. This is something planned to be added in future.

[Performance Audit Report]

The audit report is only available if your license includes audit module. Do you see Audit or AUD in the list of features if you click on the About JasperReports Server link in the lower left corner of the screen? If yes, you need to enable audit information harvesting:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v71/configuring-auditing-and-monitoring#kanchor195

Then this report will be useable.

[Why is my details band not repeating?]

If you want to use IN operator without a problem then use $X{IN, column, parameter} operator:

http://jasperreports.sourceforge.net/sample.reference/query/index.html

You would need to change the $P{id_list} to java.util.Collection in that case though.

 

[How can I use bold attribute in a part of a textField?]

Yeah the font here might be the problem. Make sure you're using an actually available font like DjvuSans or DjvuSerif that has bold and italic versions as well. You currently use SansSerif which is a wildcard font and it's rendering in runtime can be unreliable.

[Does JasperReports.io Professional include license for StudioPro?]

Currently JasperIO and Jaspersoft Studio are using the same license file and they are interchangeable. You can apply your JRIO license file to JSS and you'll unlock the usage of highcharts.

[JaspersoftStudioPro Evaluation, cannot run JasperReports.io Report]

Hello,

are you using the same license file in both JRIO and JSS? Are you running the report against the separate instance of JRIO or internal JSS version of JRIO? Are you able to run some random reports outside of JRIO type project? JSS has an internal JRIO module that helps you test the reports that are to be deployed later to JRIO instance. That one should pick up the license from the studio. But if you are deploying a separate instance of JRIO then the license needs to be applied there separately.

You say you deployed JRIO on port 8079 but the error is thrown from port 8081 so it seems it's using two different instances.

[PdfGlyphRenderer exception]

I have never seen this error before, could you post more exception text? Have you tried to add -Djava.awt.headless=true to your JAVA_OPTS?

[Does Jasper Server supports database failover using TNS]

You can use Oracle RAC for failover with JasperServer:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-installation-guide/v71/working-jdbc-drivers-0

[Unable to execute report on jasper server which is working on ireport 5.0.0 locally]

As I mentioned in different post you mdae:

It would be nice to know the error. One of the possibilities here is that your SQL query is not passing the validator. Try to turn off the SQL validator. Depending on the server version the property to disable validator can be in different places, for JRS 7.1 the location is:

{JRS WAR}/WEB-INF/classes/esapi/security-config.properties

Set this to false: security.validation.sql.on=true and then restart the application server.

If the report runs afterwards, your query then does not conform to the ValidSQL regex defined in validation.properties file in the same folder:

Validator.ValidSQL=(?is)^\s*(select|call)\b((?!\binto\b)[^;])*;?\s*$

You may want to modify this regex or keep the SQL validation disabled.

 

Please do not post the same question twice in such a short time span.

[Unable to execute report on jasper server]

It would be nice to know the error. One of the possibilities here is that your SQL query is not passing the validator. Try to turn off the SQL validator. Depending on the server version the property to disable validator can be in different places, for JRS 7.1 the location is:

{JRS WAR}/WEB-INF/classes/esapi/security-config.properties

Set this to false: security.validation.sql.on=true and then restart the application server.

If the report runs afterwards, your query then does not conform to the ValidSQL regex defined in validation.properties file in the same folder:

Validator.ValidSQL=(?is)^\s*(select|call)\b((?!\binto\b)[^;])*;?\s*$

You may want to modify this regex or keep the SQL validation disabled.

[Text Field Bold style is not working on PDF download]

SansSerif is a logical font and will be replaced with some other font that is available to the JVM and is marked as go-to Sans Serif type font. This is a "logical" font. Try using an actual font in your case like Times New Roman or Djvu Sans. You also need to package the font as a font extension (JSS Preferences -> Jaspersoft Studio -> Fonts -> Add font and export it as a JAR) and add it to your classpath. In your font extension you specify the normal, bold, italic and bolditalic variants of the font. Most likely your application does not have any bold fonts and cannot add them to the PDF.

[Jasper report text justified looks different (Studio vs Java)]

Make sure you're not using "logical fonts" like Serif, SansSerif or Monospace. They are wildcard fonts and are replaced at runtime with something else that is available to JVM. Studio's JVM might interpret the font differently than Java app due to different classpath or different JVM entirely. Make sure you're using the actual font and have that font packaged in a font extension.

[Jasperreports library - jars version update]

Don't download individual jars, download the full distribution and use the jars provided with it:

https://github.com/TIBCOSoftware/jasperreports

https://sourceforge.net/projects/jasperreports/

Is there any reason why you keep downloading the very old versions?

[Dynamic Category Expression in HTML5 Chart]

That unfortunately is not possible unless you dynamically build the JRXML itself

[Jasper server URL redirecting to external login page]

The log file might tell more information. Maybe you're bounced off because JRS thinks you're cross-site scripting and the CSRF guard gets into action. Maybe there is something else. The clusterization should not be the case here, you're accessing a single node through localhost.

[Formatting $ on left and amount on right.]

as previous poster said, your question is confusing because in the title you ask one thing and in the question text itself the opposite. Regardless, you can use both Pattern and Pattern expression for this. For example pattern ¤#### will put the currency symbol in front, ####¤ will put it in the end.

["Enhancements" in Jaspersoft Studio 7]

Hello,

I'd suggest to send feedback directly to the developers through Help -> Feedback menu or log a bug for this.

[When I am trying to create a adhoc view in Jasper server it is throwing an error named "An error occurred while performing the previous request".Please assist]

The problem can be anything, you need to go to jasperserver deployment and check the log files (default location tomcat/webapps/jasperserver/WEB-INF/logs folder) for exceptions

[Sorting issue when special charcter is there in the text value]

Sort Field uses default Java comparator to sort the fields. I don't think it's possible to implement a custom comparator for the Sort Field feature. This sounds like an enhancement reuqest territory

[Persist a custom font for PDF export in JSS Professional 7.2.1]

This could very well be a bug as well, if you keep experiencing font disappearance after adding it in the fonts section of configuration, then I'd suggest to file a bug report using Help->Send Feedback menu. I've tested this on Studio Professional 7.1.0 and it works fine for me so far.

[Persist a custom font for PDF export in JSS Professional 7.2.1]

You shouldn't need to export a font extension JAR and add it to the project. The JAR is required if you want to add the font to some other app classpath. Once you've added the font in Window->Preferences->Jaspersoft Studio->Fonts then it should become available in the font dropdown and you should be able to use the font at any time when developing in studio.

[Using a constant in $X{IN, <column_name>, <parameter_name>}]

All these $X{} functions are built as SQL functions and require a column, they cannot be used with a constant. The way it works is it will use the constant to search for the column of that name and then determine whether column values match items in the list, it won't recognize the column if you pass the constant. You can make a separate parameter and in it's default value expression determine whether constant is in the list and then with that knowledge modify your query through maybe a $P! syntax.

[How to export a simple (really unformatted) Excel file?]

Hello Arthy,

try to set the following properties for your report:

net.sf.jasperreports.export.xls.ignore.cell.border=true
net.sf.jasperreports.export.xls.detect.cell.type=true
net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true
net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true
net.sf.jasperreports.export.xls.white.page.background=true
net.sf.jasperreports.export.xls.ignore.graphics=true
net.sf.jasperreports.export.xls.collapse.row.span=true
 

Additionally you can also give your elements ID tokens and then exclude these elements from certain export formats using this property:

net.sf.jasperreports.export.{format}.exclude.key.{suffix}

Also make sure you're following the guidelines when designing the XLS oriented reports:

https://community.jaspersoft.com/wiki/making-html-xls-or-csv-friendly-reports

[is it possible to run on the same web server jasperreports 4.1.1 and jasperreports 6.5.1?]

Seems that there is no Helvetica font available to your JVM. I would suggest you to package the Courier font into a font extension JAR and add it to the application's classpath. If you don't have Courier font available to JVM then it'll try to use something else to embed into the PDF and that is Helvetica and it can't do it.

I would also suggest to not deploy JR Lib of different versions to same tomcat as it might cause weird classloading issues unless you are pretty sure that you can isolate the classloading. I'd suggest to host two tomcats and have one run the JRLib 4 app, the other run JRLib 6 app.