Report issueeeee

system · July 9, 2010, 11:57am

Hi

Might be it’s simple but i got struck here , I have data like below

Eg:
In the Report it’s capturing like this (A,B & E are field names)

A B
xyz singapore
xyz ireland
xyz Hongkong
xyz newyork

I want the Output like this.

A E
xyz singapore/Ireland/Hongkong/newyork.

can any one assist me.

Thanks!

Prince. (BOB member since 2009-11-17)

system · July 9, 2010, 12:57pm

What you ask would have to be done at the database / universe level. Do you have that kind of capability?

pablolee (BOB member since 2008-07-29)

system · July 9, 2010, 1:25pm

Thanks for your replay

yap, i have the access to database and universe as well, so i can do that at the database/universe level.

Thanks!

Prince. (BOB member since 2009-11-17)

system · July 9, 2010, 1:37pm

Check out https://bobj-board.org/t/19613 various methods available.

pablolee (BOB member since 2008-07-29)

system · July 9, 2010, 2:05pm

Hi

I checked the link, but even i dont’ want to use the pivot option because am having so many fields which are showing in the report, if i change it to pivot the entire format is going change and i don’t want that.

is there any other solution???

database level/universe level/ report level…give me the solution anywhere…

Thanks!

Prince. (BOB member since 2009-11-17)

system · July 9, 2010, 8:46pm

Hi,

Check this recent topic:

Marek Chladny (BOB member since 2003-11-27)

system · July 12, 2010, 8:10am

Read the whole thread, there are more than just the Pivot solution.

pablolee (BOB member since 2008-07-29)

system · July 12, 2010, 11:26am

@ Marek, @pablolee…

Hoooooooraaaaaaaaaaayyyyyy it’s working…
Thanks for your cooperation:D…

Prince. (BOB member since 2009-11-17)