sofra

you can do it but you will not like my solution, since it's messy It can be done by injecting some JSP to the jasperintelligence-1.1.0/apache-tomcat/webapps/jasperserver/WEB-INF/decorators/main.jsp so you insert the following code in to main.jsp ------------------------------------------------------------------------------------------------------------------- <%@page import="java.sql.Connection"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.SQLException"%> <%@page import="java.sql.* "%> <% Class.forName("com.mysql.jdbc.Driver"); Connection myConn = DriverManager.getConnection("jdbc:mysql://host/test?user=user&password=pass"); Statement stmt = myConn.createStatement(); ResultSet myResultSet = stmt.executeQuery("select Id, Name from SomeTable ;"); if (myResultSet != null) { int i = 0; while (myResultSet.next()) { String db_name = myResultSet.getString("Name"); String db_id = myResultSet.getString("Id"); %> <div> <a href="javascript:setNameId('<%= db_name%>','<%= db_id%>');"> -<%= oname%> </a> </div> <% } } stmt.close(); myConn.close(); %> ---------------------------------------------------- now you have list of names that link to the appropriate field setters .... ... implement the setNameId, which set values to the input controlles you defined in report ---------------------------------------------------- <script> function setSiteAndOperator(site_text, operator_text) { document.getElementById("input_name").value=text; document.getElementById("input_id").value=text; } </script> ------------------------------------------------------ hide the widget if we have no input control variable ------------------------------------------------------- <script> if ( document.getElementById("input_name") == null ) { document.getElementById("widget_menu").style.visibility = "hidden"; } </script> -------------------------------------------------------

any news on the date ?