abdon

I can create reports and charts for my datas in myswl database. R - I suppose you're asking about the feasibility of creating a report for you data stored on a MySql database. The answer is yes you can create such reports with JasperReports. whether we can use excel as a datasource for jasper and ireport? R - As far as I know, this can't be done out of the box. But you can write a java class that knows how to read your excell files and implements net.sf.jasperreports.engine .JRDataSource, and this will do the job. Bruno Abdon

Maybe. Make sure you use the latest version of iReport and of the Jasper library to compile it (in the case you're not compiling from iReport). I have succesfully used the list component with 3.7.4. Bruno Abdon

1) What are the knowledge we need to have to work with jaspersoft like mysql,xml etc...? R - Java, SQL, XML 2) We have our datas in mysql database,how we can get report using it in jasperserver? 3) Whether we can view the database in jaspersoft ? 4) Can anyone explain how to generate a report step by step with a sample database and table in mysql. R - You should try reading the official documentation at http://jasperforge.org/website/jasperreportswebsite/trunk/documentation.html?header=project&target=jasperreports Bruno Abdon

What the error message says is the the <list> element is in the wrong place (maybe improperly nested). Bruno Abdon

Let me try to explain the situation In my code, I create a JRFileVirtualizer evertime I'm going to fill a report, like this: JRVirtualizer virtualizer = new JRFileVirtualizer(50,System.getProperty("java.io.tmpdir")) Map parameters = new HashMap(); parameters.put(JRParameter.REPORT_VIRTUALIZER,virtualizer); InputStream reportInputStream = ... jasperPrint = JasperFillManager.fillReport(reportInputStream, parameters);My question is, am I allowed to reuse the same virtualizer for other calls to JasperFillManager.fillReport? Like in: JRVirtualizer virtualizer = this.virtualizer; //same instance every time!! Map parameters = new HashMap(); parameters.put(JRParameter.REPORT_VIRTUALIZER,virtualizer); InputStream reportInputStream = ... jasperPrint = JasperFillManager.fillReport(reportInputStream, parameters);Bruno Abdon Post Edited by abdon at 05/08/2010 11:48

Maybe you could create a custom DateUtils class where you would put all the Calendar uglyness, all shielded by nice method signatures like Date DateUtils.getFirstOfTheMonth(Date date); Date DateUtils.getFirstOfPreviousMonth(Date date);Then you import this DateUtils into your report and use the methods on your expressions. For the moment, I can't think of anything better than Calendar for doing such calculations. Bruno Abdon Post Edited by abdon at 04/08/2010 16:09

What do you mean by "the first of the month for that date"? If you mean the first day of the month, just statically use '1'; But if what you mean is the fist three letters of the month, you can try setting your text-field pattern property to 'MMM'. Code: Post Edited by abdon at 04/08/2010 15:17

Is it safe (and thread-safe) to reuse an instance of JRFileVirtualizer (or any other JRVirtualizer implementation, for what is worth)? In my code, I create a new instance every time I'm going to call some JasperFillManager's "fill" method. Could I use the same instance for every "fill" call?