kkumlien

There is now, 8.0 is our first LTS release: https://support.tibco.com/s/article/Changes-to-the-TIBCO-Jaspersoft-Release-Cycle-and-Introduction-of-Long-Term-Support-Model

Further options in the 2 answers here: https://community.jaspersoft.com/questions/501094/where-do-we-get-sample-db-used

Further options in the 2 answers here: https://community.jaspersoft.com/questions/501094/where-do-we-get-sample-db-used

Your local HSQLDB could be corrupted, if a restart doesn't fix it, you can run a copy.
See 2 possible options here: https://community.jaspersoft.com/questions/501094/where-do-we-get-sample-db-used

Studio should have its own local Sample DB, if for some reason it doesn't work, see 2 possible options here: https://community.jaspersoft.com/questions/501094/where-do-we-get-sample-db-used

Get 7.5.1 (only available with a commercial license), or see workaround here: https://community.jaspersoft.com/wiki/how-run-bundled-installer-tibco-jasperreports-server-macos-1015-catalina

Here's an article describing step-by-step an approach similar to Sherman's:
https://community.jaspersoft.com/wiki/creating-domains-using-rest-v2

See latest comment on the bug report here: https://community.jaspersoft.com/jasperreports-server/issues/10886#comment-859521
It might not help for Studio but it might for JasperReports Server.

Go to: https://community.jaspersoft.com/bug-tracker > Click "Create new Bug Report" > Select Project: "Jaspersoft Studio"
Or go to: https://community.jaspersoft.com/node/add/bug?field_bug_project=496

See solution here: https://community.jaspersoft.com/wiki/getting-timeout-pop-message-tibco-jasperreports-server-dashboard-designer

I've seen the error "PhantomJS is not working properly in your system" as well with JRS 6.4.2 on High Sierra. PhantomJS is still installed but if I run it on the command line, I get the error "Segmentation fault: 11".
So it seems PhantomJS 1.9.8 that is installed (as per the release notes) is not compatible with macOS Sierra or High Sierra.
I've installed 2.0.0 manually via brew and it seems to work on 6.4.0, still need to try it on 6.4.2 (it should).

Hi Dharmesh,
if you're referring to JasperReports Server, there is no version 6.5.1. That version is just for the open source versions of JasperReports Library and Jaspersoft Studio.

This tutorial explains exactly how: 

Have you tried changing resource.add.files.js instead (in the same folder scripts/bower_components/jrs-ui/src/)? I tried on 6.4.0 and it worked for me.
E.g. in this example I removed PNG as a valid option:
After you've modified the JavaScript, please be sure to re-create the optimized scripts (https://community.jaspersoft.com/documentation/tibco-jasperreports-server-ultimate-guide/v640/customizing-javascript-files), or to use the non-optimized version (by changing the relevant property on the server or adding _opt=false to any URL in JRS).

Here's a good example: http://www.baeldung.com/spring-jasper

You can print out information to the console as described in How to get Jaspersoft Studio logging output from within scriptlet.
Or you probably want to enable FINE-level logging for the specific class you're interested in. See Configuring Apache Commons Logging and Log4J in Jaspersoft Studio (the article you referred to) and https://community.jaspersoft.com/questions/841628/it-possible-log-generated-sql-jasper-studio for an example.

Hi Hulya,
as mentioned by Rohit in his comment, the issue is not with the data source but with the CVC setup.
See the answer here for more guidance: http://community.jaspersoft.com/questions/845837/jasper-report-custom-visualization-problem

Java Util Logging (but not Log4j) should work as per Configuring Apache Commons Logging and Log4J in Jaspersoft Studio if you set this in log.properties:
net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.level = FINE[/code]and comment out the default level for the
FileHandler:
# java.util.logging.FileHandler.level = INFO[/code]Also make sure
java.util.logging.FileHandler.pattern
and
-Dorg.apache.commons.logging.diagnostics.dest point to different files. The file set in
java.util.logging.FileHandler.pattern should contain your SQL statements.

Hi Willem,
you probably don't need this by now, but for other users...
Release notes specific to the Library are here: https://sourceforge.net/p/jasperreports/news/
General release notes for Jaspersoft are together with the other documents: https://docs.tibco.com/products/tibco-jasperreports-server-6-4-0
HTH!
Cheers

Hi Rafael,
thanks for your question! Ad Hoc and Dashboard designers currently (as of in 6.3) cannot be embedded via Visualize.js. Many customers use a mix of Visualize.js (for Reports and Dashboards) and HTTP API (for the Designers). See here for a comparison: http://community.jaspersoft.com/wiki/comparison-embedding-visualizejs-vs-http-api-iframe
There are plans to implement embedding the Designers via Visualize.js, but I cannot give you any certain date or release number, for the moment.
Kind regards

There should not be performance differences in theory.
See this article for a comparison: http://community.jaspersoft.com/wiki/comparison-embedding-visualizejs-vs-http-api-iframe

http://community.jaspersoft.com/wiki/how-use-multiple-data-sources-jaspersoft-studio-or-jasperreports-server
https://community.jaspersoft.com/wiki/multiple-datasources-ireport-lists-tables-and-subreports

Based on the comment above from Ted, he resolved his own question by enabling the flag (selecting the checkbox) "Transmit whole context" on the parent job, which is documented here: https://help.talend.com/display/TalendOpenStudioComponentsReferenceGuide60EN/tRunJob

Hi Ted,
unfortunately using bind variables is only allowed in row components and not input components: https://jira.talendforge.org/browse/TDI-6749
You can still concatenate the context variable to the query string as you would do in Java, for example:
"SELECT count(1) FROM business WHERE business_id = " + context.search_idI'm assuming search_id is a number so no need to surround it with single quotes. Otherwise it would be:
"SELECT count(1) FROM business WHERE business_id = '" + context.search_id + "'"See this screenshot for an example:

Please accept and/or up-vote the answer if you think it's useful, thanks!
Cheers

Hi Urvashi,
why are you using two Detail bands?
Unless you want to print the tables for each row in the Detail band, then I'd suggest moving both of them to the Title or Summary band.
Then remove the Details bands if not required.
Kind regards