JasperSoft Studio Not Connecting to Database
I have been doing edits to our reports for years but have never been able to connect the IReport or studio to the Data Producers from my flex account. I'm trying to get the addition Var fields to make custom reports. I have followed all the instructions on webinars and the tutorial. for both local and remote XML. I still don't have any luck.
Anyone willing to help?
Suggestions on tips for copy var from other sample embedded reports. If you know how to make that work let me know.
Please note the following:
In the Studio i don't see the option for Remote XML as a data adapter but i have tried XML/A and Document and entered the URL following the format
https://COMPANY.flexrentalsolutions.com/xml-data/data-producer-financial-document?PROJECT_ELEMENT_ID=IDFROMSAMPLEQUOTE
and tried to local download backup run SQL server no luck
Am I missing something?
Can 1 Report Draw from Multiple Producers
I'm on Mac Mojave
Using Jaspersoft Studio 6.8 i've tried 6.0.1 as others suggested in the previous forum but it wont open
IReport 5.6 No longer will work on any of our macs.
-
Hi Mike-
Lots of good questions here.
Remote XML datasource is not an option in Jaspersoft Studio. The library that they use deprecated support of XPath2 which is the query language used in the datasources. It is theoretically possible to add XPath2 support into Jaspersoft Studio and I have tried but without success. Instead I just use iReport for development of XML instance reports.
You can get iReport 5.6 working on Mac OS by installing JDK/JRE7 and pointing the iReport installation directly to it. See this post or search for other similar ones.
What do you mean "i'm trying to get the additional var fields?" You can copy variables from one report by simply clicking on it in the left-hand report inspector, CMD+C, click on the Variables heading in the target report and CMD+V.
Jaspersoft Studio will work great for development of global / definition level reports using the downloaded MySQL backup. I run MySQL Server 5.5 which is what Flex runs so that the query behavior is the same. Follow the instructions to download and load the backup into your server. You will need to install the JDBC connector for Jaspersoft studio so you can then select that driver when creating the datasource.
Yes, in my experience 1 report can draw from multiple producers but only in a specific configuration. I have some XML instance reports where I have added a second dataset with a database query. For example a quote report which pulls additional data from the database which is not present in the quote's XML datasource. It's a pretty finicky process and hard to implement but has some great results. I have one client who sets print options for the quote in a tab of custom fields - these values are pulled via SQL query and used to control whether pricing and other info is shown on the quote.
I don't think you could get a report to pull from multiple XML datasources at this time.
If you would like hands-on help with any of this, email me to discuss further.
Cheers,
Bigs
Endorsed Flex Consultant / Custom Report Developer
bigs@squarewave.com.au
www.squarewave.com.au
Please sign in to leave a comment.
Comments
1 comment