Jump to content
Changes to the Jaspersoft community edition download ×

Giulio Toffoli

Jaspersoft Staff
  • Posts

  • Joined

  • Last visited

  • Days Won


Giulio Toffoli last won the day on January 29

Giulio Toffoli had the most liked content!

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Giulio Toffoli's Achievements

  1. 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/, community.jaspersoft.com/, community.jaspersoft.com/, community.jaspersoft.com/] 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 ( 56 data bytes 64 bytes from icmp_seq=0 ttl=244 time=36.161 ms 64 bytes from 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 (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: 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
  2. Hi Dušák, are you able to connect to the community with a regular browser from the same machine?
  3. 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
  4. 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
  5. 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
  6. 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.
  7. Hi Oscar, could you provide some more info about your system/OS? Are you using the JVM shipped with Jaspersoft Studio? Thanks.
  8. 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
  9. 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
  10. 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).
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  • Create New...