Connect a db to JasperReports vía IP.

I have the ip of my db but I don´t have the server. I need to connect my report to that db so I can run it. Can someone help me with this?

The USER_ID, SITE_ID and SITE_NAME should come from that DB.

Thanks!

gab_lpc's picture
Joined: Mar 14 2023 - 8:53am
Last seen: 3 months 2 weeks ago

USER_ID, SITE_ID and SITE_NAME should come from the db.

gab_lpc - 4 months 3 weeks ago

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

arai_4 - 4 months 3 weeks ago

1 Answer:

Hello 

If you  have build a report using studio you need to have data adapter to run report. Please refer below guide to create data adpter connection:
https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-u...
 
If you are on Jasperserver you need to create data source connection where you can pass host,port and table name where those fields are present. Refer chapter 4 from below guide:
https://community.jaspersoft.com/documentation/v8-v80-v800/tibco-jasperr...
https://community.jaspersoft.com/wiki/connecting-jasperreports-server-yo....

akkhedka's picture
1018
Joined: Jun 24 2020 - 11:06pm
Last seen: 4 days 2 hours ago
Feedback
randomness