Wow - this topic really comes up quite often. I guess getting the data team’s attention to prepare more suitable reporting data is getting harder and harder these days!
Try some of these links:
Hello,
I would like to concatenate the results from an object
For eg: Let’s say there are 2 object [Item] and [Color].
For each item I would like to display colors in the same row in the table.
For eg:
Item 1 Red, Yellow,Orange
Item 2 Pink, Blue, Orange
Currently, I get each of these in separate rows:
Item 1 Red
Item 1 Yellow
Item 1 Orange
Item 2 Pink
Item 2 Blue
…etc
Is there a way to combine the colors in the same row for a give item on the report?
Thanks,
Stara
stara (BOB m…
@Fherry:
An alternate way for this type of report columns is to create universe objects and use them in the reports.
The objects can be created using CASE WHEN …END statements.
BO_Chief
Hello !
My question is : How two concatenate all the values of an object (for example the city) corresponding an another object
Ex : A lives in Paris, Barcelona, London, New York and B live in Tokyo, Sydney, Perth and San Francisco.
I would have two objects : On for the person and the other for all the cities where he lived.
Object 1 Object2
A Paris - Barcelona - London - New York
B Tokyo - Sydney - Perth - San Francisco
Thanks to help me.
The databs…
I think we need some kind of pre data formatted loading.
We need to write some Pl/SQl scripts to load that kind of data in a table and then create report on it.
man4urheart
Atul Chowdhury (BOB member since 2003-07-07)