Resolve MULTIVALUE in one cell

building reports webintelligence
1

Hi all,

I have a crosstab table that will result in MULTIVALUE if I drag insufficient objects into the table.

Is it possible to convert MULTIVALUE to a long list?
For example, suppose that cell contains ‘ABC’, ‘CDE’, ‘DEF’. Instead of showing MULTIVALUE in the cell, it display as

ABC,CDE,DEF

Thanks

summoner :hong_kong: (BOB member since 2008-12-18)

2

Yes, use sufficient objects and hide the unwanted column, there is no direct option for hiding a column but you will find many tricks in this forum to do that, just like below one:

Prashant Purohit :india: (BOB member since 2009-02-18)

3

Thanks for reply

But we are not looking for hiding columns. Our user requirement is to show mulivalue into single cell.
As internal discussion, we are finding a way to convert multilines into a string of list because there can be hundreds of row for that information. Converting it into a string can simplify the report.

summoner :hong_kong: (BOB member since 2008-12-18)

4

Create a variable that concatenates all the strings together and use that in one column. You might need to use a lot of IF statements to avoid commas with null entries.

debbie

Debbie :uk: (BOB member since 2005-03-01)

5

Your approach will lead to hard coding and that is not at all suggested.

Prashant Purohit :india: (BOB member since 2009-02-18)