[Subreporte y forzar nueva hoja.]

Good that you worked out the page breaks.

The key point in the stackoverflow post is creating a new Data Source object in the dataSourceExpression.

You need to do something like: 

dataSourceExpression><![CDATA[new JRBeanCollectionDataSource (fillList))]]></dataSourceExpression>

[Converting to JRIO and DataAdapter path]

Have a look at the video: Get step-by-step instructions on how to set up your first JasperReports IO project in JSS

on https://community.jaspersoft.com/wiki/jasperreports-io-step-2

You need to do a few things to make a Studio project = a JasperReports IO project.

It is easier manage if, as Guilio says in the video, you have a subfolder in the project to be your repository root.

Once you have a JasperReports IO project, the data adapter files in the "repository" (project)  will be accdo the ....ess relative to the repository root you set above. You wil not need to do the "../../data-adapters/DataAdapter.xml"

 

Sherman

[Help Needed with a Jaspersoft job running in SMA OpCon]

Hi Kevin,

I don't know how you received access to JasperReports Server commercial editions. Did your organization buy Jaspersoft:

• directly from TIBCO Jaspersoft => Jaspersoft Support could help with this issuie
• through software you provided by another vendor => contact the vendor

From what I understand looking at the issue, you have set up a job with SAM OpCon that makes a REST call to the JasperReports Server.

The 404 means that the job is not able to connect to the JasperReports Server. It can't find that endpoint.

I can't see the actual URL you are using. That is the first thing to check.

The JasperReports Server REST API to run a report is defined here: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v750/reports-service

http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/path/to/report.<format>?<arguments>

 

Sherman

[Jasperserver: Can't create JSON Datasource]

This is the relevant page in the 7.2 documentation: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v720/file-data-sources

To get a data source type to appear in the Data Source maintenance screen, you have to comment out elements in the list with the "customDataSourcesToHide" bean ie.

..<!-- value> jsonDataSource</value -->..[/code]

Did you restart the server after changing the file?

[if rest API can be built on top of jasper ?]

What metadata do you need to add?

Do you want the metadata to appear in reports?

 

[iReport 5.6, Fishbowl Inventory and Math Problems]

Looks like luked is on it!

[Dynamic data at runtime]

A JasperReport is based on a fixed set of fields returned by a query. If the query can return variable columns, say:

• make the column names abstract in the query - field1, field2
• define the fields in the report to be the maximum number expected
• if the query does not provide a particular column, the corresponding field in the report will be null
• include logic in the report to manage field with content or null

Sherman

[Compiling subreports at runime]

The JR library does not have a "compile as needed" feature.

The JasperReports Server and JasperReports IO does. The first time after a report or subreport is published to JasperReports Server, the report is compiled and the bytecode is stored in the repository.

 

Sherman

[Can't create MariaDB Data Adapter]

Looks like you did not select the MariaDB driver in the Studio Data Adapter dialog.

[How to solve java.sql.SQLRecoverableException: No more data to read from socket???]

https://www.google.com/search?q=oracle+java.sql.SQLRecoverableException%3A+No+more+data+to+read+from+socket

[Docker install 7.5 failing at create-ks interactive prompt]

# not doing app server management during command line work
  cat >> ${BUILDOMATIC_HOME}/default_master.properties
<<-_EOL_
appServerType=skipAppServerCheck
_EOL_
 

[Excel with macros]

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

See "Importing Macros Into The Generated XLSX Document"

[How to use Attributes for dynamic data source ?]

Here is how you can use Attributes in Data Source definitions: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v750/attributes-data-source-definitions

When you do something like "{attribute('host','Server')}" a value for the "host" attribute needs to be in the Server Attributes (Manage > Server Settings > Server Attributes) need to be set.

"{attribute('someKey','User')}" implies a "someKey" needs to be in the User Atributes of the currently logged in user.

"{attribute('someKey')}" implies that the Server will search for a "someKey" attribute in the following order: User (logged in user),  Organization hierarchy of logged in user, Server.

Sherman

[Error in JasperServer apache-tomcat logs]

When JasperReports Server authenticates via some form of single sign on, a user object is created or maintained in the repository.

This exception comes from trying to save the user -> roles relationship.

We have seen some race conditions where multiple users logging in at once cause contention.

There should have been some cause mentioned in the stack trace about what the DataIntegrityViolation was.

[Error upgrading community server from 7.2 to 7.5]

You should move the .jrsks and .jrsksp files to a directory that tomcat can access.

I updated the https://community.jaspersoft.com/wiki/encryption-jasperreports-server-75 page with instructions on how to do this.

 

[Error upgrading community server from 7.2 to 7.5]

That exception comes from the web app not being able to access the keystore files.

What directory did the keystore files end up in?

Did the user running the web app process have access to those files?

The encryption change in 7.5 has a major impact on deployment and operations. We are working to give folks the easiest path to adjust to this change. See https://community.jaspersoft.com/wiki/encryption-jasperreports-server-75 

[New group, new page BUG!?!?]

Would need to see the JRXML to see what is going on.

[Error in JasperServer apache-tomcat logs]

Some corruption in the repository?

Can you show more of  the stack trace? There should be a string of "Caused by" with a final cause.

 

[Generating reports from a web application]

You have options.

1. Keep doing it as you are today with the servlet.

• What APIs have been deprecated? Not on the JasperReports side.

2. JasperReports Server

• Has a REST API to run and export reports
• Community version is AGPL licensed: not appropriate for embedding in your commercial application
• Commercial Reporting Edition is the same as Community Server with some small extensions https://www.jaspersoft.com/editions

3. JasperReports IO

• JasperReports library with a REST API and a JavaScript client to do interactive reports
• Runs as a web app in a Jetty instance with a file system based repositoty
• Commercial https://www.jaspersoft.com/products/jasperreports-io
• Low cost annual subscription

 

Sherman

[include OpenStreetMap map]

Have a look at the Custom Visualization component.

https://community.jaspersoft.com/wiki/adding-custom-visualization-components-tibco-jaspersoft-studio-62

https://community.jaspersoft.com/wiki/leaflet-map-javascript-library-map-example

You can set OpenStreetMaps as an option in Leaflet.

 

Sherman

[Jasper Installation Error version 7.5]

Can you share the installation log? It is in the installation directory.

 

Sherman

[How to downgrade a server?]

You have the backups, so restore them. There is no downgrade process available.

What went wrong with the upgrade?

 

Sherman

 

[Dynamic user authentication for json datasource over rest. Works fine on Jaspersoft Studio, but fails on JasperReports Server with an unauthorized error.]

When you deployed the report to the JasperReports Server, what data source did you use for the Report Unit?

A JasperReports Server data source is not a data adapter.

You could try setting the report to use a data adapter on the server, as per https://community.jaspersoft.com/wiki/how-deploy-and-use-data-adapter-jasperreports-server-v56

[Jasper Report in C# windows Forms]

1. Looks like you could embed the JasperReports report viewer as a Java component in Windows Forms.

https://www.javonet.com/java-devs/samples/how-to-build-java-application-with-winforms-interface/

2. Use WinForms WebBrowser component to embed JasperReports Server user interfaces.

3. Use JasperReports Server REST APIs to generate content that can be downloaded by your WinForm app.

 

 

[what version of jasperreports-x.jar file supoorts Apache Tomcat 8.0.27.0 or jetty-distribution-9.4.14.v20181114.]

JasperReports runs with:

JasperReports before version 6.6.0, back some years	Java 7
JasperReports version 6.6.0 to version 6.7.1	Java 8
JasperReports version 6.8.0 to version 6.10 (as of Oct 2019)	Java 8 - Java 11