[Which is the right product to build reports and call them from a web app?]

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

[Unable to export Jasper Reports]

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.

[Sub reports not showing up as resources when publishing main report.]

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.

[Which is the right product to build reports and call them from a web app?]

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.

[Month Name Sorting in Chart (In Adhoc View Jasper Server)]

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.

[How to get total pages number from scriptlet]

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

 

 

[if else]

Hi, using code Java:

$P{PARAM_SITE}.contains("has_content") ? "your site" : "www.modulank.com"[/code]

 Summary:

CONDITION ? true : false[/code]

Regards.

[How to sum based on printed columns]

Your Welcome!! :)

[Error in Jaspersoft ETL express with SAP : Exception in thread "main"]

your welcome!

[How to sum based on printed columns]

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

[Return field value from dataset to main report]

HI,

You can not return values ​​from a dataset

Use subreport...  

Regards

[How to sum based on printed columns]

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

[Error in Jaspersoft ETL express with SAP : Exception in thread "main"]

Hello, follow you the next images

In ETL:

This setup works for me without problems

Regards!

[Problems with the fields list]

 

Hi ...

 

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

 

regards

[Creating table with double header]

Hi, use subreports...

[Creating table with double header]

Excuse my English...

[Creating table with double header]

Hi just have to use the Header band, with the components of the image,

the band finally in header, Header Reprint property mark ...

regards

[Error: SQL problems: no such column:]

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

[Configuring Dynamic Input Controls in Jasper Server]

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

[How to fill table rows with java.util.list values?]

Hi..

 

use JavaBean DataSource..

 

 

Regards

[Can't create a list field with JSON Datasource]

Hi..

 

Try java.util.Collection

 

Regards

[Parameter Default Value Expression for Number]

Hi

 

In the report, set property languaje = java

 

Regards...

[Error: SQL problems: no such column:]

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

 

[Own FontExtensionRegistry doesn't work after Update to 4.7.0]

Hello, I recommend using JR 4.7.1, 4.7.0 has many bugs ..

 

Sorry for my English ..

 

Greetings!

[Jasperserver 4.7 Table - Print when expression]

Hello, I suggest you do not use table in this case.

 

individual components used, and apply style, so you do seem a table

bands used header, detail, and footer (optional), use padding and border ...

 

excuse my English ..

 

regards