I want to merge 2 rows in I-Report

0

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.

Fname

Lname Event1

Event2

abc xyz Yes Yes

 

 

 

 

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

1 Answer:

0

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
1597
Joined: Sep 26 2006 - 8:06pm
Last seen: 2 days 16 hours ago
Feedback
randomness