1. We have a report definition containing fields like

PropertyName, PropertyValue, Locale, DisplayValue

Let's say, For property X1, and for Locale German or (any other Locale), there are 3 PropertyValues(Say 1, 2, 3), DisplayValue(de1, de2, de3).(i.e. 3 rows)

And for that same property(i.e. X1), for Local English there are 4 PropertyValues(say 1,2,3,4) and Display Values(En1, En2, En3, En4).(i.e. 4 rows)

if, we query, for property X1 and Local = German, it should pick de1, de2, de3,En4.

Is there any way to do this in the report definition