Business Objects 6.51 Webi Tool Question

[baycolor]

Hi,

I'm using the BO 6.51 webi tool (java report panel).

A report I have is sourcing data from two tables that have a one to many relationship (contacts to contact codes). My output has the contact name and the contact code number as below.

Contact ContactCodeNumber
Joe 1
Joe 5
Dave 3
John 5
John 7

I would like to get one row of output per contact like:
Contact ContactCodeNo
Joe 1;5
Dave 3
John 5;7

I know how to do this in Crystal Reports. Is it possible in BO 6.51 webi? If so how?

Thanks in advance.

 

[skrandel]

No, it's not possible.

You could do something with a crosstab, but that's your only option.

Steve Krandel
Intuit

 

[baycolor]

Thank You!