Question on BEX reporting - need one more field

[Former Member]

Hi,

We have a BEX report with certain fields & the report works fine. The problem is few of our users need an extra file like: for certain document types they would like to see a text as 'Special orders'. Is there any functionality for strings at the report level. Something like a 'If' statement? Can we use Variables here?

Thanks in Advance.

ST

[Former Member]

Hi ST,

Maybe you can try one of these options:

- Program on the update of that characteristic's texts that sets a description field to be "Special orders" (remember that you have short, medium and large descriptions). Then you could display that field on the report for that users, or they could even hide/unhide it.

- If you want to keep both the description and the "special order" field on the report, I would suggest to add a new text attribute to the characteristic, filled as described above.

- Finally, you could also try to use a "replacement path" variable that displays "nothing" or "special order" depending on the characteristic value (using "if" statement as a formula, like: condition * if + not condition * else)

Hope it helps,

David.

[Former Member]

There are no variables available for display attributes, but users can switch how characteristics will be displayed (as Key, Text, Key & Text, Text and Key, no display).