phuchoa0502

burferd Wrote: In the Services window, I added the driver in the Databases -> Drivers section. Does that not add the library to the classpath? If not, then how do I add it? I did this to add an Oracle driver and that allowed me to make a connection in iReport, but not the SQL Server driver. I'm not familiar with the jtds-1.2.5.jar file you mention. I wold prefer to use the same drivers that I use for my application, however. Pls adv me some info: - what languagues you use for programming? - i don't understand this: "I added the driver in the Databases -> Drivers section" where is it? - you want to make connection in ireport or what? Post Edited by phuchoa0502 at 03/09/2012 09:27

burferd Wrote: I just downloaded the latest version of Jasper Reports and iReport and am attempting to create a new database connection to my SQL Server database. I am using this driver: sqljdbc4.jar and added the driver to the Databases->Drivers section in the Services window. I then attempted to create a new database connection using the connection information that works in my application. In the New Connection dialog, I tried both the Field Entry and Direct URL Entry methods. In both cases, when I fill out the connection information and push OK, the dialog greys out with only the Cancel and Help buttons active. I suspect it is attempting to create the connection, but apparently never does. The database is active and I can connect to it with both my application and the SWL Server Management Studio using the information I entered for the connection in iReport. Is there a problem with creating SQL Server database connections in iReport 4.5.0? Any suggestions on how I can create the database connection? Should I back off to an older version of iReport? Thanks i think you were not add the jar file in to classpath of ireport, right? should add it. or you can try use jtds-1.2.5.jar for SQL server connection.

mohitraj Wrote: I have been trying to display a list of objects in the detail band. Object has a property called 'Position' which can have 2 possible values 'Left' and 'Right'. All the objects with Position='Left' need to come in left and correspondigly Position=Right have to be in Right column. For example below: Left Obj 1 Right Obj 1 Left Obj 2 Right Obj 2 Left Obj 3 Right Obj 3 I have flexibility in manipulating the object I pass on to the report. And if the alternative is using a sub-report, even that can be achieved. Thanks in advance for going through this problem. Mohit Raj 1. did you know to use JRBeanCollectionDataSource for display list? 2. i thought you can grant if condition in field expression, for example in left column: if(position.equals("left") { //show your value here } you should try this. hope can help!

First say thanks to Mathias in http://javaskeleton.blogspot.com for basic info to make this topic. what you need is: I. use Ireport to design report. i use ireport 4.0.2 1. install the font which is used for text in your reports to ireport. tools-> options -> fonts tab -> install font -> follow install winward to install font. remember choose the pdf encoding is identity-H, and stick embed this font to pdf document. 2. export the jar file of the installed font by export as extendsion. and add those jar to your project's classpath. 3. all text in your reports should use the same font or the font already install to ireport. for ex: i use arial font. 4. all text in reports should have pdf encoding is Identity-H or Identity-V up to your language. i use vietnamese so i choose Identity-H 5. it's done. try and revert out come to here. thanks for coming this topic. i capture some pictures for demo, pls find att for your ref. if it helpful, pls vote it. thanks.

Hi cn73! Could you please to explain more detail how to solve this problem, because now i also get it. thanks Hans