Skip to Content
0

Blank Row while report export

Feb 02, 2017 at 10:28 PM

68

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jyothirmayee A Feb 15, 2017 at 09:03 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded