pjtech

Hi Thanks for the reply. Yes at the moment we use controls with SQL select query for the required date values. However, we need to validate the parameters before the report is submitted. A simple example a user may put in a start date greater than the end date. Although the example is just dealing with two dates the live application there is a requirement for more sophisticated validation, hence the use of a scriptlet. Also some of these parameters are rather heavy on resources therefore we want to hold them as static variables as they will be common across a number of reports. Again Thanks Peter

Has anyone had experience of inserting and populating a selection form before a report is generated in Jasper Server? The following is an example is what I want to achieve: Retrieve the Max and Min values of a date held on the database. Display a form that uses JCalandar and invite the user to change the date values if required. Validate the dates on the form and then pass it back to the report.I am currently using JRScriptlet that works for retrieving values / but not for the form display. I am using callBeforeReportInit hook to display the selection form. I would be grateful if some one could point me in the right direction. Thanks Peter

Hi, Thanks for the quick reply. Yes I done that and you can load the schema. But the problem is you still cant insert a datatype as the insert bombs out. For now I reverted to MySql 5.1 and its working fine. Again Thanks for yor help. Peter

Hi Guys, I am having an issue where JasperServer is bombing out on MySql 5.5 both on the install and when I attempt to insert a Data Type. Table jidatatype has a column name of maxValue which I beleve is a reserved word on 5.5. Has anyone had the same issue or got a workaround? Thanks Peter