pavel_psycho

Use buttons on that I mark on attachment With best regards, Pavel

First of all set JAVA_HOME on classpath. The second is try to manual set java home for iReports.%iReport_home%\etc\ireportpro.conf uncoment line jdkhome="c:/Program Files/Java/jdk1.6.0_26" and set path to your java. With best regards, Pavel

The first way (if the number of columns are fixed, but you could use crosstab if required dinamically(all consist of your requirements)): You could create report template using iReport with for example 5 columns. Every column has header and detail. Header like as detail can has expression (on iReport right mouse click on element ->"Edit expression") on this section you could write expression where you can specify which field or label should jasper print. You can run report from java and send parameters which data should print. Example expression: $P{VALUE_FROM_JAVA} == 1 ? $F{FIELD1} : $P{VALUE_FROM_JAVA} == 2 ? $F{FIELD2} :"" The same for label. But it's not the best way because you should get from DB all data: FIELD1 and FIELD2 and on runtime jasper will exec your expression and print required data. The second way: You can generate using java jrxml file by hand. It's simple xml. And on runtime past required labels, fields and query. And then just compile and run it. The plus is you will get only data that required for your report. But if you use jasper server you will need to import this file to server. The minus it's could be more complicated :) If you have any questions - you are welcome :) With best regards, Pavel Post Edited by pavel_psycho at 07/26/2011 13:59

Not at all but dinamically report generate with crosstab, but anyway you have to specify wich fields sould be present, by which report filter data and etc. Almostly dinamic report you could create with Java and jasper lib. You will create by hand report file and then run it. If you have any questions - you are welcome :)

Many thank's for this materials. I just finish watching your webinar - this information is exactly what I was trying to find. Early I working with cognos and some features what I want to know I find only on your webinar. Many thanks.