kbonheur

As usage of callouts is rather insufficient for our developers, we are looking for another way to add some metadata to a specific element on the report. Can "properties expressions" be used for this end and very importantly will this have any side-effects (compilation problems, lower performance of report generation,...)? Does anyone have an opinion of what I'm proposing here? Any help would be much appreciated.

Hello, I'm quite new to JasperServer and I want to use a pie chart and drill-down the results by clicking on a specific piece. So far I managed to activate the hyperlink, but each time a click a piece I'm getting a NullPointerException. I've attached a printscreen of the hierarchy of the repository (relevant to my problem) and also a printscreen of the hyperlink Section. The third attachment contains the error message. I've searched a lot of forums, but not one that really helps. Any help would be much appreciated.

Thank you so much for your reply to my question. In the shown example there are id's in each table, so they have a unique reference to a record with one single field. In my case I need a concatenation of different field to make it unique, so I'm still at a loss :(.

Hello, I'm quite new to JasperServer and I need Cascading Multi-Select Controls with 3 levels: 1) Employer level --> ID : Employer_Multi_Select 2) Employee level --> ID : Employee_Multi_Select 3) Contract level --> ID : Contract_Multi_Select We don't have an ID column, the unique key consists out of multiple columns : 1) EmployerNumber 2) EmployerNumber + EmployeeNumber 3) EmployerNumber + EmployeeNumber + ContractNumber The first 2 levels I can manage with the cascading multi-select Query Controls, but I'm lost as of creating the third level. Beneath I've added the 3 query's for each control, as the query is too long I've only added the column that is used as the value : 1) SELECT employerNbr FROM employer_table ORDER BY employerNbr ASC 2) SELECT CONCAT_WS('|', employerNbr, employeeNbr) AS concat_employer_employee from employees_table WHERE $X{IN, employerNbr, Employer_Multi_Select} ORDER BY employerNbr ASC, employeeNbr ASC 3) SELECT CONCAT_WS('|', employerNbr, employeeNbr) AS concat_employer_employee, employerNbr, employeeNbr, contractNbr FROM contracts_table WHERE $X{IN, concat_employer_employee, Employee_Multi_Select} ORDER BY employerNbr ASC, employeeNbr ASC, contractNbr ASC In the third level I always get the error in TomCat : "Caused by : com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'concat_employer_employee' in 'where clause'. Meanwhile I know that I can't use colunm aliases in a where clause, but the obvious question now is : Is there any other way to solve this? Any help is much appreciated.