system
August 7, 2015, 10:57am
1
Hi,
For one ID’s have with multiple country, display the country in a single cell separated by semicolons.
SOME DUMMY DATA
ID NAME COUNTRY
10 KING East Honolulu
10 KING Honolulu,Oahu
20 SCOTE Honolulu
20 SCOTE Oahu
AND EXPECTED REUSLT WOULD BE in single row AS BELOW,
ID NAME COUNTRY
10 KING East Honolulu,Honolulu,Oahu
20 SCOTE Honolulu,Oahu
So request you sir please suggest me how to do this in one of webi report.
I have to show many id’s uning date parameter in the section in the repoet not single row.
Regards,
Kiran
rajenimk (BOB member since 2015-01-16)
system
August 7, 2015, 11:11am
2
Search and Ye will find:-
https://bobj-board.org/t/170527
Mak 1 (BOB member since 2005-01-06)
system
August 7, 2015, 6:27pm
3
This worked fine in BOXI 3.1 but in 4.1 it is having problems. I suspect that something has changed in the calculation engine that is changing the behavior of these variables. I haven’t been able to find a work around yet.
torybennetsen (BOB member since 2013-05-07)
system
August 10, 2015, 7:41am
4
Must be your variable set up, as at least one of those methods from that post, or the ones linked to, was proven to work in 4.1, see above.
Mak 1 (BOB member since 2005-01-06)