Jump to content
We've recently updated our Privacy Statement, available here ×

Connection problems with Postgresql database


fillipedesenvolvedor
Go to solution Solved by vchiem,

Recommended Posts

 

Gentlemen, I'm having problems connecting to the postgresql database, the existing connection test in jasper studio is showing that the connection is being successful, but when I run the report to execute my sql instructions and the data appears in the report nothing comes out! I am using a subreport that has another sql statement, when I execute only the subreport in the Preview option of the jasper soft studio, the sql statement is executed and shows the data correctly. But in the main report giving the preview, unfortunately no information is returned after executing the sql statement left in the main report, as I already said, I have no connection error I think the jasper soft studio has an internal bug regarding the connection to the postgresql database, in case anyone knows how to help me I really appreciate it! Great day for you, even more!

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

  • Solution

In the Dataset and Query dialog of the main report there is the "Data preview" tab. 
You can test whether data is feeding into this report by clicking on Read Fields and then Refresh Preview Data. If you can see data, then revise the design. Or perhaps start a blank report again and simply add one field to the detail band and see if the report previews with data. 
 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...