Display all groups in the header section with condition
I've been turning around an issue for 2 days that looks simple to me in the beginning.
Actually I have a group on a database field in my report that displays always 2 values (groups). It's working correctly but I need to bring it to the Header section and display the 2 values as an information.
The values I need are extracted from a table on these 2 conditions:
If Database.field A has value 1 then I need to display in the header the Value in the same row that shows under the field Name X
If Database.field A has value 2 then I need to display in the header the Value in the same row under the field Name Y
The problem is that if I copy the Group from details to the Header section, it shows only one value while I need to display both values consequently.
The ideal solution for me is to show in the report header :
Information A (displays if Database.field A = 1) : Displays to field Name X of this value
Information A (displays if Database.field A = 2) : Displays to field Name Y of this value