kaushikaraju1609

Hi All, We have a requirment to develop a multilevel crosstab using Jasper reports.One of the crosstab query has 'CASE WHEN THEN' statement. Because of the CASE statement, the jasper is not accepting the fore coming parameter as a parameter.So we Created Cascading Input Controls for the 'CASE' statment. In that case we have to map the parameters to the crosstab element, but the crosstab element is not allowing to create or copy paste the parameter. We tried this method which has been posted in the repective website but that didnt help us out. https://helicaltech.com/passing-parameters-from-crosstab-to-subreport-in-jasper/ Attaching the jrxml file FYR. Jaspersoft studio version : 7.1.0

Current crosstab report is attached FYR.

Sample expected crosstab report is attached FYR. Screenshot Name : Expected_Crosstab_Sample.png

Hi All, We have a requirment to develop a multilevel crosstab using Jasper reports. Sample expected crosstab report is attached FYR. Screenshot Name : Expected_Crosstab_Sample.png We were able to achieve the Multi level crosstab as shown in the screenshot : Following are the issues that needs to be adddressed to achieve the expected crosstab report : 1). Set the Header for each column as shown in the screenshot : Expected_Crosstab_Sample.png 2). Need to increase the width of the Row group,Column group,Measures as per the data size, which currently is not being allowed. Attaching the jrxml file FYR. Jaspersoft studio version : 7.1.0