I am using a nested query concept, where main named query returning 4 different type data and subquery is returning few columns based on the named query data, now when placing that in a table group, sub query column wise data key needs to be placed dynamically
FOR EXAMPLE: If Named Query DATA=1 it will SHOW “@A@” in sub table column-1, IF DATA=2 then in subtable it will show “@B@“ in sub table column-1
I am binding Dynamic DataKey as@TYPE: @TYPE@.Start measure where TYPE will be coming from parent query result but its not working
You cannot change data keys dynamically. You can hide table columns dynamically. Consider putting all four keys in your table and hide the ones that don't apply.
OKay, that also works but I am using this -
@DESCRIPTION@="AA"?"True":"False"
as keychain expression in visible property but this doesn’t work, am I missing something?
Probably just @DESCRIPTION="AA"@
(Don't use the trinary operator to convert a boolean conditional to boolean constants, and especially not to strings that just look like booleans.)
It worked just with - DESCRIPTION!="AA"?”True”:”False”. It was not accepting “@“
You do not use @ in a keychain expression. They are for normal placeholders only.
