ecanaveras

Hi Eyesmagicx, I must clarify. Jasper Studio "JS" is used to create reports with custom layout, simple or complex layout. This IDE generates a JRXML using the Jasperreports library, you cannot use it to launch reports from another app (only to "build" reports) Jasperreports "JR" is a JAVA library with a free version, it is the report engine. (don't forget this) you can use it as a "plugin" library in your projects. Jasperreports Server "JRS" is a web application (a frontend that allows you to easily deploy | use reports), it has a free and paid version. You can use your reports directly in a java web app (that you create) directly using the "it's what @ does" library. jgust, indicates it in his comment", or you can use JRS which already exists. Regarding your confusion, JRS Professional and Enterprise allow the creation of Ad HOC reports (simple and very limited web reports), usually created by the end user (does not require a developer). Important, everything mentioned uses the Jasperreport library (it is the report engine) Regards

Hi friend, As of JRS 7.5 it is necessary to indicate the KEY with which you are going to export, See Here the documentation. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v80/import-export-encryption-keys#Encryption_Keys Greetings.

Hi friend. - Make sure that the subreport ID is the same as what you call it in the main report. (repo:id) - Make sure you pass the connection. - Make sure to pass the parameters required by the subreport. - Make sure you have data in your datasource. If that doesn't work, go back to JasperStudio and run the subreports individually to determine what's going on. Greetings.

Hello, It depends on the need of your project. Jasper Studio: Designer (IDE, now even with web version) Jasper report IO: - It is a microservice, - Repository in folders - PDF, XLS, CSV, etc. - Exclusive to generate documents | files - It is possible to use an online viewer - Can be used in containers (Docker | Kubernetes) - Less expensive license Jasper Report Server: - WEB application (Use a web server) - Repository in Database - PDF, XLS, CSV... - *Dashboards, Adhoc, Domains, Topics, etc. -User | roles - *More expensive license, depends on the edition (Reporting, Professional, Enterprise) * Dashboards, Adhoc, Domains, are only accessible in Professional editions | business * There is a Community version, very similar to the Reporting Edition (No payments | No official support, only community support) Jasperreport IO & Jasperserver allow you to use reports in different ways. -URLs - Rest API - Visualize (JavaScript Library) -Iframe (Embed) Greetings.

Hi, i optimized the code by @nareshkumar326: Create a Calculated Field, expression: Concatenate(Mid(' ', MonthNumber("Date ordered"), 12), MonthName("Date ordered"))[/code]* Replace "Date ordered" for your Date. Regards.

Hi, it is posible: This is a example, scriptlet. public class PagesCount extends JRDefaultScriptlet { public Integer getPagesNumber() { try { return (Integer) this.getVariableValue(JRVariable.PAGE_NUMBER); } catch (JRScriptletException ex) { Logger.getLogger(JRSPagesCount.class.getName()).log(Level.SEVERE, null, ex); } return null; } ...}[/code]Regards

Testeaded in Jasperserver 7.5.0 Thanks you!

Hi, using code Java: $P{PARAM_SITE}.contains("has_content") ? "your site" : "www.modulank.com"[/code] Summary: CONDITION ? true : false[/code]Regards.

Your Welcome!! :)

your welcome!

creates variables for all columns, use the column showing the expression to return the field to add or 0 ex: $P{SHOW_COLUMN_A} ? $F{FIELD_COLUMN_A} : 0

HI, You can not return values ​​from a dataset Use subreport... Regards

Hi, Use Variables: VAR1 = COLUMN_A $P{SHOW_COLUMN_A} ? $F{FIELD_COLUMN_A} : 0[/code]VAR2 = COLUMN_C $P{SHOW_COLUMN_C} ? $F{FIELD_COLUMN_C} : 0[/code]VARn = COLUMN_N $P{SHOW_COLUMN_N} ? $F{FIELD_COLUMN_N} : 0[/code] Expression: $V{VAR1} + $V{VAR2} + $V{VARn}[/code] Regards

Hello, follow you the next images In ETL: This setup works for me without problems Regards!

Hi ... you should use a subdataset, and use the fields you add to subdataset, functions as tables regards

Hi, use subreports...

Excuse my English...

Hi just have to use the Header band, with the components of the image, the band finally in header, Header Reprint property mark ... regards

The error occurs because your SQL statement is not correct! Use: SELECT * FROM TABLA_1 T1, TABLA_2 T2 WHERE T1.KEY=T2.KEY AND T1.YERPER=$P{yerPer} ORDER... Bye

Hello, you have referenced the companyname parameter in the report, so will take the value of url .. That is, stay with 2 controls, usernames, companyname regards

Hi.. use JavaBean DataSource.. Regards

Hi.. Try java.util.Collection Regards

Hi In the report, set property languaje = java Regards...

The error occurs because your SQL statement is not correct Use: SELECT * FROM TABLA_1 T1, TABLA_2 T2 WHERE T1.KEY=T2.KEY AND T1.YERPER=$P{yerPer} ORDER... Bye

Hello, I recommend using JR 4.7.1, 4.7.0 has many bugs .. Sorry for my English .. Greetings!