Hi
We have an issue with data display in one of our reports.
Below is the sample data that our query is fetching.
Col1 Col2 Col3 Col4 Col5 Col6
1 A 1234 Null Checked Null
1 A 1234 UnChecled Null Null
1 A 1234 Null Null Checked
2 B 3456 Null Null Checked
2 B 3456 Null Unchecked Null
2 B 3456 Checked Null Null
We need to show data as below in the report
Col1 Col2 Col3 Col4 Col5 Col6
1 A 1234 Unchecked Checked Checked
2 B 3456 Checked Unchecked Checked
Please help us in resolving this.