ciprian_ivan

Yes, you are right. "Mandatory" solves the problem. Thank you !

Hello, During the last 2 months I have used extensively JasperServer for the reporting needs. It works great, it looks great. There is one issue i stumbled upon frequently: all input controls involving several choices (simple lists of values, radios, queries) have one default value: "---" in at the top. Is there any way to remove/customize that ?? Thank you, Ciprian PS: felicitari echipei romanesti de la Jasper

A colleague find a solution: In webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties/validation.properties you have to set: Validator.ValidSQL = ^{s*(?i)(withs+.*)?(select|call|exec(ute)?)s+[^;]+}$ to allow for {call "sp_name"(...)} And IT WORKS! Thanks a lot for responsiveness !

-- -------------------------------------------------------------------------------- -- Routine DDL -- Note: comments before and after the routine body will not be stored by the server -- -------------------------------------------------------------------------------- DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_show_users`(IN `user_id_low_param` INT, IN `user_id_high_param` INT, IN `birth_date_low_param` DATE, IN `birth_date_high_param` DATE, IN `school_ID_param` INT) READS SQL DATA BEGIN /* Variables: */ /* SQL Statemens: */ select user_id, concat(last_name, ", ",first_name) as userName, date_of_birth as BirthDate from user_profiles where school_instance_id = school_ID_param AND ( (user_id >=user_id_low_param) and (user_id <=user_id_high_param) ) AND ( (date_of_birth >=birth_date_low_param) and (date_of_birth <=birth_date_high_param) ) order by date_of_birth, user_id; END

Hello, I wrote a simple stored procedure (no parameters in the report query, only hard-coded values as IN variables for the procedure). When i test it in Ireport, it works fine, the result is as expected. When i create a "JasperServer" report and try to "Run Jasper server report", i get the ERROR message: 1 - An error has occurred. Please contact your system administrator. (6632) java.lang.Exception: 1 - An error has occurred. Please contact your system administrator. (6632) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Can someone give me a pointer in the right direction ?? i "google" without results until now. Thank you, Ciprian

Hello, First of all, thank you for those 2 useful tools ! Ireport and JServer are just great. I followed step by step the tutorial at: https://www.jaspersoft.com/blog-entry/jasperreports-interactivity-the-table-component The "table" component works just fine in IReport, in both cases: "previewed" ; "Run JasperServerReport" in Repository Navigator. PROBLEM: when trying to access the report in JasperServer directly, the application returns nothing. What possible cause may lie behind this problem ? I tried to see if there is a "dataset" transfer problem, (as the "table" gets its data from a dataset, not the main query) and i created a different report with one chart, who also gets its data from a dataset, not the main query. The chart works smoothly. Thanks a lot. Code:<datasetRun subDataset="MyTable_dataset" uuid="391fdcb3-4e46-47eb-bbc8-d9e8d5ad1f7b"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression></datasetRun>