Skip to Content

Blank Row while report export

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.

capture.jpg (14.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 15, 2017 at 09:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded