Jump to content


  • Posts

  • Joined

  • Last visited

cgaskins's Achievements


Apprentice (3/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges



  1. Multiple issues with Studio and Big Sur OS.... I have had other issues but not this one specifically. Studio not being functional on Big Sur is really impacting me work at this point.
  2. Yeah, there are other screen refresh issues as well.. Honestly, too many to list. Those of you that rely on Jasper Studio to do your daily work - do NOT upgrade to Big Sur.
  3. Thank you. That was exactly what I needed. If that little "gem" of information is in the installation instructions, I missed it.... Definitely important.
  4. Hello.... I am trying to get Jaspersoft Studio CE 6.16.0 running on my Linux system connecting to a PostgreSQL database. I keep getting the error: "org.postgresql.util.PSQLException: the connection attempt failed." I can connect via the psql command line client with the same configuration parameters but Jaspersoft Studio just won't work. The full error details are below. Any help or hints would be appreciated... net.sf.jasperreports.engine.JRException: org.postgresql.util.PSQLException: The connection attempt failed. at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:126) at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:120) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:155) at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:315) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:225) at org.postgresql.Driver.makeConnection(Driver.java:465) at org.postgresql.Driver.connect(Driver.java:264) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:164) at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:124) ... 4 more Caused by: java.io.EOFException at org.postgresql.core.PGStream.receiveChar(PGStream.java:443) at org.postgresql.core.v3.ConnectionFactoryImpl.enableGSSEncrypted(ConnectionFactoryImpl.java:436) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:144) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:213) ... 10 more
  5. Anyone else having issues with Jaspersoft Studio Community Edition version 6.15.0 and Mac OS 11.0.1 (Big Sur)? I upgraded my MacOS last night and now some of the most basic controls in Studio don't work. For example, the zoom sizing (either the buttons or the percentage drop down) have no effect. I wonder if it is a Java version issue. How do you specify the JRE version you wish to use to run Studio CE under?
  6. Thank you C-Box. I appreciate the clear concise information. I had thought about the subreport idea last night but haven't implemented it yet. My query is long and complex so I believe I will end up going the subreport route. Much appreciated! :-)
  7. So I am still stuck after to good suggestions - any additional guidance would be greatly appreciated.
  8. I tried the response from Yan22300 and it didn't work... Yan's suggestion: First of all, "remove line when blank" is useful when you design a table with different textfields or when you use the table component. Then, you probably have different components in your report so if you just want to not print a specific component (graph, crosstab, textfield...) when there is no data you always have a "print when expression" in the properties, waiting for a boolean. So just test a field of your query to print or not your bar chart. If you have components below your graph you need to set their 'position' to 'float'. So the issue is that the data I am putting in the chart is not in my Main Report Data Set. I have created sub-data set for the Chart to utilize. Therefore when I try to use one of the data fields from the subdataset in the "Print When Expression" for the chart itself (I clicked on the chart in then edited the property under "Appearance") the report fails with "field not found". So it appears that fields from a subquery are not directly available for the master report. If I missed something, please let me know.
  9. Ok, I tried "trvpseudo" suggestion and it didn't work.. His suggestion was: i see ure using jasperstudio. check on the properties. click on ur file and u should see "When No Data Type" in the properties. u can set it to "null" or "blank page" or any that match ur needs. hope that helps :D So I opend my report and on the right side under "Outline" I selected my Report Name. Then on the right side of the window under "Properties" there is an item titled "When No Data Type". It was set to NULL. I tried this property set to "No Pages", "Blank Page" and "No Data Section" and I continue to get a chart with no data in it. If I missed something, let me know but this does not appear to work.
  10. Thank you both for the fast replies. I will be able to experiment with your answers later today. Thanks again! -Chris
  11. Hello. I am definitely a novice when it comes to Jasper Studio and Jasper Reports as I have only been working with it for about 2 months now. However, I have made good progress but I have hit an issue that I just can't figure out and I have yet to find a good answer in searching through this site and the internet in general.... I am using Jasper Studio 6.9.0 against a PostgreSQL database - so far so good. I am producing a summary report on a number of things across a date range and these are manifested as Bar Charts. So far so good... My problem is that I someitmes have a valid report date against a valid project where there is no data in the SQL database so therefore the bar chart is empty. So I get an empty bar chart.... I would like to NOT print the bar chart when it is empty. I have select the check box "remove line when blank" but this has no effect. Any thoughts or suggestions? Thanks, chris
  • Create New...