Giulio Toffoli

Hi David, please refer to this post to solve the issue: https://community.jaspersoft.com/forums/topic/68153-connection-to-the-jaspersoft-studio-community-edition/?do=findComment&comment=162042 javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target This error happens if the community.jaspersoft.com certificate cannot be recognised by Java. This is pretty uncommon, since the CA of the certificate is provided by Amazon RSA. To resolve this problem, the certificate can be added to the Java cacerts file. The instructions may change a little bit depending by the system but in general are these: 1. download the certificate with the browser. The video below shows how to do it in Chrome: 2. import the certificate by using this command: <JAVA_HOME>/bin/keytool -importcert -alias jaspersoft.com -keystore <JAVA_HOME>/lib/security/cacerts -file _.jaspersoft.com.cer On Mac you may need to use sudo to run this command as admin: sudo keytool -importcert -alias jaspersoft.com -keystore <JAVA_HOME>/lib/security/cacerts -file community.jaspersoft.com.cer community.jaspersoft.com.cer is the certificate downloaded with the browser at point 1. The cert store default password is "changeit". Hope this helps Giulio

Check this post if it can help you: https://community.jaspersoft.com/forums/topic/68153-connection-to-the-jaspersoft-studio-community-edition/?do=findComment&comment=162042

Hi Goorweather, you can download Jaspersoft Studio CE here: https://community.jaspersoft.com/download-jaspersoft/community-edition/ After the installation, you can refer to this video tutorial to create your first report: What to do with the report you create? The report itself is represented by a jrxml file (and eventually other resources such as images, subreports, etc...). The answer to this question depends by your use case, you may already have an application that requires you to provide a jrxml, or you may want to write your own application by using JasperReports Library. If you simply plan to run the reports without using other software and without writing your own one, then JasperReports Server is what you need. It is a web application in which you can load your reports and run them (with the ability to create input controls to get parameters that your reports may require to run, and setup all the connections to get the data for your reports). Of course JasperReports server does much more than that. JasperReports Server can be downloaded here: https://community.jaspersoft.com/download-jaspersoft/commercial-edition/ As you just discovered, it is a commercial product, but you can download a 30 days free trial. Hope this helps. Giulio

Hi all, This little guide should help people having issues with the login dialog in Jaspersoft Studio. javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target This error happens if the community.jaspersoft.com certificate cannot be recognised by Java. This is pretty uncommon, since the CA of the certificate is provided by Amazon RSA. To resolve this problem, the certificate can be added to the Java cacerts file. To do it: 1. download the certificate with the browser. The video below shows how to do it in Chrome: 2. import the certificate by using this command: <JAVA_HOME>/bin/keytool -importcert -alias jaspersoft.com -keystore <JAVA_HOME>/lib/security/cacerts -file _.jaspersoft.com.cer On Mac you may need to use sudo to run this command as admin: sudo keytool -importcert -alias jaspersoft.com -keystore <JAVA_HOME>/lib/security/cacerts -file community.jaspersoft.com.cer community.jaspersoft.com.cer is the certificate downloaded with the browser at point 1. org.apache.http.conn.HttpHostConnectException: Connect to community.jaspersoft.com:443 [community.jaspersoft.com/54.192.95.8, community.jaspersoft.com/54.192.95.70, community.jaspersoft.com/54.192.95.116, community.jaspersoft.com/54.192.95.61] failed: Connection timed out: connect This issue is related to a network being blocked by either a proxy or a firewall, you should check the problem with your system administrator. To verify the issue, try to ping the community website from a command prompt or terminal. The result should be something like: ping community.jaspersoft.com PING i328763.invisionservice.com (54.192.95.116): 56 data bytes 64 bytes from 54.192.95.116: icmp_seq=0 ttl=244 time=36.161 ms 64 bytes from 54.192.95.116: icmp_seq=1 ttl=244 time=31.265 ms java.net.UnknownHostException: unknown host (community.jaspersoft.com) This issue is related to a network with a private DNS which filters hosts resolution. Can be easily verified by running the command in a command prompt or terminal: nslookup community.jaspersoft.com and verify that the domain can be resolved or not. The issue can be solved by either set (at least temporarily) the DNS of the machine to 8.8.8.8 (Google DNS), or by modifying the file hosts (on mac /etc/hosts, on windows c:\Windows\System32\Drivers\etc\hosts) by adding the following line: 54.192.95.70 community.jaspersoft.com How to configure Jaspersoft Studio to use a proxy To specify proxy settings in Jaspersoft Studio, you need to modify the file "Jaspersoft Studio.ini" by setting the following java system properties: http.proxyHost http.proxyPort http.nonProxyHosts It can by done by adding lines at the end of the INI file with a text editor: ... -Dhttp.proxyHost=example.proxy.host -Dhttp.proxyHost=123 -Dhttp.proxyHost=some_host_to_exclude Hope this helps, Giulio get_certificate.mov

Hi Dušák, are you able to connect to the community with a regular browser from the same machine?

Hi Barbara, are you able to access the community website with a browser,? Are you behind a proxy? What OS are you using? This information would help use to understand the problem. Thank you Giulio

Hi Mlynarek, could you provide some info about your system? OS? Are you using a proxy? The error is about your java installation not being able to validate the community.jasperosft.com. Giulio

Hi Dila, thank you for your message. You can use the latest version of Jaspersoft Studio to create jrxml compatible with any version of JasperReports. To be sure that the produced jrxml will work with your specific JasperReports version, set the Jaspersoft Studio compatibility from the Preferences: About the zip version of Jaspersoft Studio CE 6.21.1, this is definitively something we can provide in the set of available downloads. Hope this helps Giulio

When you switch to the source tab, you are looking at what the file would look like if saved, not the content of the actual loaded file. The source shown in the tab is generated on the fly based on the current model in the designer. You can easily check this by adding a comment to your jrxml with a text editor and load the jrxml in the designer, you will see that in the tab source your comment is gone. The comment show in the source tab will be save only if you save the file. There is currently no reliable way to check with which version of JRL a jrxml or as jasper file has been created. If you need this information, you can still store it in a report property and read it with JasperReports itself.

Hi Oscar, could you provide some more info about your system/OS? Are you using the JVM shipped with Jaspersoft Studio? Thanks.

I know this is an old post, but still worth replying. In the table section of the properties, you can find two options: - Fit columns to table element: this will fill the table with your columns - Resize the columns taking the space from the next one: this prevents to change the table element size while resizing columns Hope this helps Giulio table.mp4

Hi Max92 You get an empty report because you did not provide any data to your report. JasperReports requires data to fill the report. When no data is provided, you can decide what to do. The default behaviour is to produce an empty report, which is what you get. At report level you have an option to set this behaviour: You can use All Sections No Detail to print at least the title. The "detail band" section is repeated for each record of your data, but when no data is provided, this band will be skipped. To provide data, you need to create first a Data Adapter, JasperReports Web Studio supports a variety of data source types. From the repository, click on New and select New Data Adapter. I suggest you to start with a simple CSV file, for example. Once you have created the Data Adapter, you can use it in your report. To do it, go to the Dataset panel in the report designer and select your data adapter. The report will now use the data adapter to fetch the data, what you still need to do is defining a query (for CSV will be empty), and defining the fields you are going to use in the report: click on the Show Query Editor switch to show the Query Editor. For CSV simply click on Read Fields button, and your fields will be added to the list of fields available for the report. To get started, I suggest you to watch this Dr. Jasper video: Hope this helps Giulio

Another possible error could be the way you are referencing the subreport: C://xampp//htdocs//gerador_relatorio//gerenciamentoCargas//relatorio_sub.jrxml You should point to the jasper file, not to the jrxml file (which is the source that needs to be compiled into a jasper file).

I would try to remove the jasper file of the subreport and recompile it with the same compiler you used to compile the master report. Be aware that Jaspersoft Studio may not always compile the subreports for you, or simply it does not do it if it is not necessary (i.e. the jasper is up-to-date respect to the jrxml). Since phpjasper will be your running environment, I would use it also to (re)compile all your jrxml files. Giulio

Hi Deadsploid, there is not a way to dynamically specify which data source should be used to run a report in JasperReports Server. Not sure where you have found this jdbc_datasource parameter, but it may have been part of a more complex example showing how a JDBC datasource can be configured in such a way where attributes of the user profile that runs the report can be used to drive particular behaviours, i.e. by specifying which database the data source should connect to based on that user profile. In general the data source used to run the report (or better a Report Unit), is stored as part of the report unit itself. Hope this helps, Giulio

The CDATA is the syntax used in XML to escape entire portions of of XML, and it has nothing to do with the error you are getting. To understand exactly what's the problem with your expression, we would need to check the full stack trace (or test your report in Jaspersoft Studio, as suggested in the previous answer). I don't see any syntactical error (in other words your jrxml is ok), but it could be that the type of the parameter memberid defined in the subdataset is not of type java.util.List (which is how the parameter is defined in the main dataset). Giulio

Hi Vikkumarash, it sounds like you are trying to use a JasperReports (which is a java library) with C# (.NET). This will not work. An option to use JasperReports with a non-java project is to use JasperReports IO e its REST Api. https://community.jaspersoft.com/project/jasperreports-io Thank you Giulio

Hi Saiteja, once the report is generated, the result will be a document (i.e. a PDF file) with the same page size as the one you specified in the jrxml. When you print this document, if its size differs from the paper size used by your printer (A4 is slightly higher than Letter, which is wider), usually the system printer dialog will ask you if you want to fit the page. There is no possibility to "lose" data or change the layout just by printing a document on a different media size, since the report is generated always accordingly to the page size specified at design time. Thank you, Giulio

First of all, iReport will remain always available for download, it is just not getting updated, and it does not support the most recent JasperReports additions. You have two options: keep using iReport (without using the newest features of jasperreports) or move to Jaspersoft Studio, which works as standalone applications or as plugin for Eclipse.

Hi Pete, it is a bug in Jaspersoft Studio, now solved. You can wait for Jaspersoft Studio 6.2.1 or download a snapshot from source forge of a beta release. Thank you! Giulio

The error indicates that you the jrxml is not valid. This can happen if: 1. The server does not have the extension to load the custom component 2. The server does have the extension, but it is outdated (we refactored a little bit the CVC in 6.2.0, this could have introduced something that the old extension does not like) Giulio

Changed Assigned User from - to @User_306070 This is probably due to the fact that your server is not supporting the custom visualization component.You should check to have the jar jasperreports-customvisualization-6.0.1.jar (shipped inside Jaspersoft Studio).You also have to specify in the jasperreports.properties file in your WEB-INF/classes the following properties:com.jaspersoft.jasperreports.components.customvisualization.require.js=file://location/of/require.jsnet.sf.jasperreports.web.resource.pattern.customvisualization.scripts=com/jaspersoft/jasperreports/customvisualization/resources/require/.*You should adjust the location of require.js (available inside JasperReports Server).Hope this helps,Giulio

Hi, I would strongly discourage the use of a different encoding. UTF-8 supports all the French accents, as well as almost all the characters that can be encoded in a word, included Japanese, Korean and so on. There is not reason to use a different encoding. If data is loaded in a different format from a database, this also does not represent a problem, since the JVM uses internally UTF-8 to represent Strings.

Hi jvmolto, the syntax of your query seems ok, what's the problem with Jaspersoft Studio? If the syntax highlighting suggests an error, you can ignore it, the query should work normally anyway. Thanks Giulio

Hi Haidar, the Font extension you are using seems to work well, I was able to produce a report and export it to PDF without problems. May we see your jrxml? Thanks Giulio