I want to merge 2 rows in I-Report


Hi Friends,

I am stucked in a situation where with my SQL query I am getting an output such as-:

Fname Lname Event1 Event2
abc xyz No Yes
abc xyz Yes No

So this is the output which iam getting with my SQL query and I want my output to be of single row so that the end user have a glance at the report and can easily guess which are the event that guy has attended.


Lname Event1


abc xyz Yes Yes





afaquecena's picture
Joined: Apr 23 2015 - 4:56am
Last seen: 1 week 4 days ago

1 Answer:


You should modify the query, in order to get a single row per each name. For instance:

select Fname, Lname, max(Event1) as evt1, max(Event2) as evt2 from my_table group by Fname, Lname

shertage's picture
Joined: Sep 26 2006 - 8:06pm
Last seen: 6 days 11 hours ago