amit.saini

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

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.

Anybody help me out on this pls.

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 PoliciesNo. of LivesGross PremiumChannelCH0110001800$200,000 Branch1250500$50,000 ProductA100250$20,000 ProductB75100$15,000 ProductC75150$15,000 Branch27501300$150,000 ProductD5001000$100,000 ProductE250300$50,000

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 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.