[Sorting on Crosstab Measures Variable Total]

You can use http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.crosstab.column.header.sort.measure.index. Please refer to link below for explanation:

https://stackoverflow.com/a/51981585

Here is  a demo

http://somup.com/cYV3QffRXX

[Will Jaspersoft ETL Community Edition (v6.0.1) work on Windows 10?]

if it's still an issue please provide more details about the problem; screencast would be perfect

we need to at least know what product you are referring to exactly: TAC, studio, cmdline, jobserver etc or all-in-one installer?

most imoprtantly please note version 6.0.1 has reached EOF:

https://community.jaspersoft.com/wiki/jaspersoft-etl-version-retiredend-life-schedule

[How to generate adhoc reports and export to csv using http api?]

You should be able to use following syntax according to Ultimate guide instructions:

http://<host>:<port>/<context>/flow.html?_flowId=viewReportFlow&reportUnit=/path_to_your_report&output=pdf[/code]

[Limit on number of columns in table for PDF]

there are no additional limiatations enforced by JR library. If you can't open PDF file try using different software client. Foxit reader worked for  me in some corner cases when Acrobat didn't

[Jaspersoft ETL Job Scheduler (Talend Administration Center)]

JasperServer (JasperReports library) licenses and JasperETL licenses are different. If you purchased yours but can't access it please email support@tibco.com

P.s. You can schedule JasperServer jobs from JasperReports Server.

[ETL variable name table]

Hi,

Try using tJDBCTableList to filter the tables. Here is an example job:

http://community.jaspersoft.com/wiki/etl-query-multiple-tables-single-tpostgresqlinput-using-tjdbctablelist-regex-filter-table-names

[HTML5 charts not rendered in PDF format using Talend ETL]

Such components are not officially supported. We don't develop them so we can't troubleshoot them. Our advise is to use JasperServer HTTP or REST API to run the report.

This article demonstrated how to schedule a report via REST API using tREST component:

https://community.jaspersoft.com/wiki/schedule-report-rest-api-after-db-query-returns-successful-results

To run a report, simply use /rest_v2/reports/ or /rest_v2/reportExecutions end-points instead as described in documentation:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v640/reportexecutions-service#Running_a_Report_Asynchronously

[Few words missing in the automated pdf export from jasperserver report]

tjasperserverexec was designed a while ago and might not work correctly with recent versions of JRS. You should be using tRest component for web services. I designed an example job showing this functionality

You can also install this plug-in, it will add Jaspersoft components like tJrsRestReportExec, tJrsRestResources etc:

http://community.jaspersoft.com/project/jaspersoft-etl-plugin/resources

 

[zipping reports with password]

I did a sample with ETL in case someone is interested:
http://community.jaspersoft.com/wiki/jasperetl-schedule-report-and-encrypt-its-output

[Few words missing in the automated pdf export from jasperserver report]

could you attach an example please

[Getting 'Non SUpported SQL92 token' error messages]

Is ST.AUD$USER an actual field name or a variable?

FIY, specification is next:

http://jasperreports.sourceforge.net/sample.reference/query/index.html#query

[Is it possible to show last data labels in the series line chart]

This seems to be working using following plotOptions.series.dataLabels.formatter:

function() { var len = this.series.data.length; if(this.point.x == len-1) {return this.point.y;} else return null;}[/code]

Attached sample can be run with any DB

[jdk 1.8 JasperReport 4.7]

Support for Java 8 has been introduced in version 6.1

[Does JDK 8 supports JasperReports 4?]

Support for Java 8 was introduced in version 6.1

[is iReport compatible with java 8 now?]

iReport latest version is 5.6. That time (summer 2014) It wasn't certified for Java 8.

Plus, we no longer support 5.6 products. Please consider migrating to Jaspersoft Studio:

http://community.jaspersoft.com/project/jaspersoft-studio

[how to connect to jasperserver repository database]

If I were you, I'd design a script using REST API and execute it via cron on the server.

If you want to do something more complex, you could try Talend ETL job

[Excel XLSX export issue]

Does this happen in Microsoft Excel? Try using LibreOffice to open the file, for example.

[Map component issue in 6.2 Community]

you should try latest version of the studio first; if problem persists, upload your report and we'll take a closer look

[how to connect to jasperserver repository database]

Default repository DB name is 'jasperserver'. Credentials depend on what you specified during installation (default_master.properties file in case WAR file was used).

Although, you should upload resources by interacting with the application. You could use web UI (View/Repository then right-click on folder and select Add resource/File/Content Resource) or REST API web services to design a script/programm to automate the process.

[Customization of the report sending through FTP]

Hey, Denis. I did a sample job and wrote an article explaining how to achieve that using Talend ETL. I used local filesystem instead  FTP though:

http://community.jaspersoft.com/wiki/jasperetl-schedule-report-and-encrypt-its-output

Thanks for the tip, Hitoshi.

[Combining Jasper ETL with Jaspersoft Studio]

If this is still actual an issue, please provide more info about what exactly you are trying to achieve

[HTML5 report scheduled not displaying chart]

You need to make sure report runs fine from JasperServer UI first. I'm not sure community version supports HTML5 charts.

[Oracle PL/SQL functions in Studio]

Hi,

Have a look at the article on how to use PL/SQL in iReport:

http://community.jaspersoft.com/wiki/how-execute-ms-sql-stored-procedure-jasperreports-server

You might need to add jasperreports-extensions-3.5.3.jar to Studio classpath (Project/Properties/Java Build Path/Add External JARs)

 

[Connection to JasperServer from Jaspersoft Studio 5.5 using AWS]

if everything is fine regarding organization/user/password, check if version of JasperStudio matches version of JasperServer you are running

[Duplicate values in the Jasper report]

I can see all the columns have duplicate values. But what if 5th row has COL1 = "AP8" and/or 4th row has DATEVAL = "Apr 31, 2013" for example. What do you expect to see?

You could try creating a derived table with distinct(COL1) syntax. Not sure the output will meet your needs though