slow

from http://dynamicjasper.sourceforge.net/docs/features.html JRXML template files support: You can use a base template jrxml file in which common styles, company logo, water mark, etc can be pre defined. JRXML can be created with iReport... you can make some tests to verify it...

try to take a look to your report structure... I'm sure that you have created cells taht don't match perfectly. if you want a perfect excel you must create a perfect report... with no space between elements... I have created very very large excels... (more tahn 80 columns * more than 1000 rows...) without problems... read this for help: http://fecplanner.com/jasperreports/docs/tips.tricks.html#friendly give us a feedback... _________________________________________ if you like it... give me KARMA points please! : ) _________________________________________ listening: Almamegretta - Sole "sole quando sorgerai su di me su di noi? vorrei sole su di me su chi non l’ha visto mai…"(a.) Post Edited by slow at 09/08/2010 09:23

this is a good question for a rainy day like today... there is no way to convert the number from arabic (1,2,3...) format to roman format (I,II,III...) automatically... you must create your own converter (with java) and then use it in you report... so, I have made one for you using code from net. try to do this to have your roman numbers: -download the attached JAR and add it in you ireport classpath (tools-->option-->classpath-->add jar) -in your main report node, click and in the properties windows, scroll down and find "import" -set this import: ireport.util.slow.number.romanconverter.RomanConverter -define a textfield of type String, setting this expression: RomanConverter.toRoman($V{variable}.intValue()) where $V{variable} is an Integer value from 1 to 3999. and run your report... give us feedback... _________________________________________ if you like it... give me KARMA points please! : ) _________________________________________ listening: Almamegretta - Gramigna "lassame sta’ nun me tucca’ lassame sta’ nun me ‘nquita’ chesta È a vita mia e voglio campa’ comme dico io" (a.) Attached an example of use... Post Edited by slow at 09/08/2010 09:26

take a look to dynamicjasper... http://dynamicjasper.sourceforge.net/

I repeat: I think ireport hasn't rules that can change dinamically the horizontal position of elements, but only vertically (as I have suggested before) so you must change your subreport position or reduce the subreport dataset to one elements if you can (with "distinct" sql clause) I have taken a look to your image and it's hard to me figure why to you set a subreport in the bar above your data... listening: Joy Division - Shadowplay

sorry... I haven't read your post correctly. I apologize... I have read the word horizontal only now... The jrxml isn't complete... but viewing the image, why do you set two subreport? it seems that there is one near TOTAL and one below it... The one near TOTAL, if has multiple elements overrides the other elements (and this is correct!) and I think ireport hasn't rules taht can change dinamically the horizontal position of elements, but only vertically (as I have suggested) (here I'm not able to test or correct your jrxml... I'm in a office at work!) listening: Joy Division - Dead Souls

try this: set the "Position Type" of all elements besides the subreport to "float" or "Fix Relative to Bottom". give us feedback... _________________________________________ if it works... give me KARMA points please! : ) _________________________________________ listening: Almamegretta - Sanacore

I'm sorry but I still do not understand where is the difficulty... are your values in a String format? if they are in a double/Double format... why you don't you use a simple definition as you wrote? ($V{v1}/$V{v2}) Post Edited by slow at 09/02/2010 13:15

Hi memory... thanks for the mail and for appreciate my previous answers unfortunately I don't use Jasper Server (with "IS" do you mean it?) so I can't suggest to you any methods to solve this issue. Anyway, if you have a java.lang.ClassNotFoundException error, it's an error better than other. Why? you can find where is located this class, I mean to find the jar that contains it and then place it in the application classpath. It isn't so hard to do. try to do this little trick: in your report main node click and then in the properties windows , at the bottom, click on import. add: com.jaspersoft.jasperserver.api.metadata.user.domain.User try to run your report. if it doesn't work, try to find the jar that contains user class and add it in the ireport classpath.

try this: --click on the main report node. --in the properties find the "imports" button and click... (it's at list bottom) --add your class name (with package !!) --save, recompile, run... give us a feedback... _________________________________________ if it works... give me KARMA points please! : ) _________________________________________ listening: Death in Vegas - Dirge

try this in your condition: new Boolean($F{Field}.toString().equalsIgnoreCase("MAN")) change the "Field" word properly with your field name. if you have a String field you can remove the toString() function. give us a feedback... _________________________________________ if it works... give me KARMA points please! : ) _________________________________________ listening: Muse - Plug In Baby [Live From Wembley Stadium] Post Edited by slow at 08/31/2010 10:12

rajuchacha007, I spended more and more words to suggest to you how use the Joda library , or Java Object to show or manipulate milliseconds... but in the late post you wrote i read this sentence: "Also, how to view milliseconds in mysql. I have been trying to get milliseconds column but not successful yet." when I show millisecond in my example, I obtained them from java object (Date) or Oracle columns... I haven't a MySql installation on my work pc. but... you can try more and more times... you'll never obtain milliseconds if you start from date coming from mysql DB. why this? MySql time object (timestamp or date) doesn't support millisecond... so each date(or time) has details only from year to seconds. read here: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html http://bugs.mysql.com/bug.php?id=8523 http://dev.mysql.com/doc/refman/5.1/en/datetime.html "However, microseconds cannot be stored into a column of any temporal data type. Any microseconds part is discarded." As you can see... milliseconds aren't supported by MySql... so, your dates (I wonder how you have not noticed it before) have exactly 0 milliseconds each time you print them in the pdf files in the long format... So... you can try to store in a different column in your mysql db the milliseconds you want...or save it in the long format or in the string format...but if you have date and time already stored in mysql DB, I think there ins'nt a way to obtain milliseconds from your mysql data object. (I did a quick check ... and only the last post you mentioned using mysql!!!) _________________________________________ if you like it... give me KARMA points please! : ) _________________________________________ listening: MUSICA NUDA - Sacrifice Post Edited by slow at 08/31/2010 09:52

you can use your variable names... but don't change the java object... $V{jodaPeriod} is a Joda Period object... or, if you prefer, you can create a String variable or a String textfield that uses a Period to show data (as I show in the perviuos post)... if you use long , i think it's impossible show hours, minutes etc etc if you don't create a function that translate it in you format ore use one that do it for you. you can try to use the java SimpleDateFormat object if you prefer to use the long values but not the Joda Object... in a TextField of type String you can use: (new SimpleDateFormat("HH 'hh', mm 'mm,' ss 'ss',SS 'ms'")).format(new Date($V{ms}.longValue()-3600000)) where $V{ms} is a Long Object and 3600000 (=60min*60sec*1000ms=1hour) is the amount of millisencond I subract to regain the extra time (1 hour) that the default SimpleDateFormat give to print the 0 GMT time in my Locale. _________________________________________ if you like it... give me KARMA points please! : ) _________________________________________ listening: Prodigy- Narayan

hi rajuchacha007, as I wrote, "Time_diff uses the joda Period to create a time difference and print only the details you prefer (hours, minutes, seconds, milliseconds...)" you can read here: http://joda-time.sourceforge.net/apidocs/org/joda/time/Period.html and here: http://joda-time.sourceforge.net/key_period.html and here: http://stackoverflow.com/questions/1440557/joda-time-period-to-string about Joda Period... so, in your report you must define a variable with Joda Period object, (suppose we call it $V{joda_period} and the a textfield with the expression: $V{joda_period}.getHours()+"hh "+$V{joda_period}+"mm "+$V{joda_period}+"ss "+$V{joda_period}+"ms " or in a simpler way, a TextField with this expression: " "+(new Period($V{start_time}.getTime(),$V{now}.getTime())).getHours()+"hh"+ " "+(new Period($V{start_time}.getTime(),$V{now}.getTime())).getMinutes()+"mm"+ " "+(new Period($V{start_time}.getTime(),$V{now}.getTime())).getSeconds()+"ss"+ " "+(new Period($V{start_time}.getTime(),$V{now}.getTime())).getMillis()+"ms" where $V{start_time} and $V{now} are java.util.Date Object and the getTime() method returns the millisecond representing this date. (you can use your millisecond if you have it) I hope this can help you... Keep in mind that I never used Joda and did not know it before you cite it, and it is really easy to use... _________________________________________ if you like it... give me KARMA points please! : ) _________________________________________ listening: Tiromancino - E' necessario "E’ necessario che io sia coerente con me stesso per dare il peso giusto e un senso a tutto il resto" (t.)

uhm... can you be more clear? what is your issue? printing the result in your format? or capture in a variable the division result?or what else?