hekuran23

Hozawa, Thank you very much for your effort. Actually I'm new in Jasper Report, and don't have much knowledge. I could concatenate whole statement in one line, but I do not know how to fetch the second line and put in the report, I tried to do this "$F{ID} == 1001" in variables, but it's only TRUE when you put the ID of First row, and gives the name, but once you put a variable with id 1010, it does not fetch the name but only returns NULL. Could you help me solve this. Thank you.

Wanted to ask if it's possible in Jasper Reporting to do the following: Query Result: ID Name ------- ------------ 1001 NICK 1010 BOB 1022 TOM I have text in REPORT that needs to fetch all the names, The creditor, Nick with id 1001, bla bla bla bla, and the Guarantor BOB with id 1010 Bla bla bla bla, and guy who vouches TOM with ID 1022, bla bla lba. Is it possible to fetch the second of third row of query in Variable. I tried like this but NO LUCK. I put this on Variable Expression: ($F{ID} == 1001) ? $F{NAME} : "" Thank you very much in advance, appreciate your time.