Hello All! Grasping at straws here I am not sure why I cant get over this bump.
I have a couple lists that are doing this to me.
I am using several case statements like this
CASE
WHEN ([ITEM 1] = 'VALUE' and [ITEM 2] = 'VALUE')
THEN ([OBJECT])
end
So they're 5 columns like this. I don't want to use an ELSE ('') due to not wanting a blank cell. I am wanting all the data to be in 1 row.
So ideally it should come out as
NAME | ITEM 1 | ITEM 2 | ITEM 3 | ETC | ETC | ETC
However, I instead get
NAME | ITEM 1 | BLANK | BLANK | BLANK | BLANK
NAME | BLANK | ITEM 2 | BLANK | BLANK | BLANK
NAME | BLANK | BLANK | ITEM 3| BLANK | BLANK
I have played with pivoting but it apprently doesn't understand. I have tried row suppression options. I have tried inserting the "ELSE (NULL)" and excluding nulls.
I am just lost.
Anyone able to help on this? I appreciate any assistance.
why not use other containers like repeater instead of list?
CASE
WHEN [ITEM 1] = 'VALUE'
THEN [OTHER ITEM]
END
...is the same as...
CASE
WHEN [ITEM 1] = 'VALUE'
THEN [OTHER ITEM]
ELSE NULL
END
Based on your desired output, I think you want to aggregate the results. For example, try changing the Detail aggregation property for that data item to maximum.
Quote
Thank you so Quote from: dougp on 06 Feb 2019 03:09:05 PM
CASE
WHEN [ITEM 1] = 'VALUE'
THEN [OTHER ITEM]
END
...is the same as...
CASE
WHEN [ITEM 1] = 'VALUE'
THEN [OTHER ITEM]
ELSE NULL
END
Based on your desired output, I think you want to aggregate the results. For example, try changing the Detail aggregation property for that data item to maximum.
Thank you so much. This is exactly it.