Blank Row while report export

[former_member402770]

Hi Experts,

I refered various forum on the column LOV field to row LOV concatenation by delimiter

ie: 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

1) Is there a way to combine the colors in the same row for a give item on the report without using previous function?

2) Using Previous function does fix my problem in the webi report. Since data volume is huge in size i have used input control to filter the report column value which is fine, the issue when i export the report this formula variable row LOV concatenation column is missing the multivalue data as shown in the attachment.

capture.jpg

Appreciate your response here,

Many Thanks.

[jyothirmayee_s · Accepted solution]

Hi,

Attachment doesn't help.

Can you post sample data what you need and how should it look like?. Per my knowledge you wont be able to display multicolor for each cell but should be in a row depending on your conditional formatting.

Thanks,

Jothi