Hello I don't understand the main idea... (Jasper, iReports) and sorry for my english When someone knows something thanks!! majaa
I have a file jrxml: <queryString><![CDATA[select username, first_name, last_name, email from user where username=$P{AAA}]]></queryString> where AAA is <parameter name="AAA" isForPrompting="true" class="java.lang.String"> <defaultValueExpression ><![CDATA["zzzz"]]></defaultValueExpression> </parameter> action-servlet.xml is the same as in the tutorial UserReportController.java: model.put("AAA", "bbb"); model.put("format", format); model.put("WEBDIR", reportResourcePath); model.put("dataSource", userManager.getUsers(new User())); return new ModelAndView("userMultiFormatReport", model); 1. In iReports editor all is ok! But later.. Is there something wrong? perhaps with parameter AAA? 2. When I define dataSource as all users, I get all users.. Is it another way? no to define dataSource? I want to have many reports and I don't know all reports query! Ok I can read it from xml but must I? 3. Can I define query (ireports) like: select $P{ETW}, count(*) from bbb group by $P{ETW} 4. How can I define such a query : select ... where ccc in {'a', 'b', 'c'} with ireport where 'a','b','c' are changeable.. so one parameter eg $P{E} for more als one string.. how to define parameter E? //I'm using Appfuse 1.9.3, ireports 1.3.0 thanks for any help!