[DETAILS:displaying rows of data in single row]

You can use LISTAGG function in the query to get the desired result.

[Maximum Rows allowed within jaspersoft for all reports in Jasper]

 

Requirement is to limit the no. of rows returned within Jasper by default. Can we achieve it through changing something on data source level or at one place. So that changes imply for all the reports.

[Need help in Crosstab Jaspersoft Studio]

Anybody help me out on this pls.

[Need help in Crosstab Jaspersoft Studio]

Hi, 

Below is the crosstab template where we have 3 dimensions and 3 measures. 

Need help,  if channel, branch & product are row groups and measures are Policies, lives & Premium then what would be the column groups. How we achieve the same cross tab.

Jaspersoft does not allow measures as columns. However, column groups are a mandatory element of the cross tables

		No. of Policies	No. of Lives	Gross Premium
Channel	CH01	1000	1800	$200,000
	Branch1	250	500	$50,000
	ProductA	100	250	$20,000
	ProductB	75	100	$15,000
	ProductC	75	150	$15,000
	Branch2	750	1300	$150,000
	ProductD	500	1000	$100,000
	ProductE	250	300	$50,000

 

 

[can we write sql statements in Parameter as a default value expression]

we need to query the database directly and displayed result  as a default value expression of a parameter.

[can we write sql statements in Parameter as a default value expression]

Can we write sql statements in Parameter in Jaspersoft studio to show value directly returned from SQL query as a default value expression.

For instance :  Select max(value) from table

Value will be dynamic in nature.