Hi All,
I am facing an issue with the crosstab. Need your assistance with it.
Please see attached sample report.
I have to display all priority and reason codes irrespective of whether data is there or not. For which I have used left outer join. So I am getting few records with null priority and reason codes. I need to hide this from the display.
I used a variable and tried to hide the null but this is causing the cells to shift to the left and causing alignment issues. Since I am using crosstab space which spans across all the codes I am unable to hide the crosstab space.
Hope the question is clear. Any thoughts and ideas would be of great help.
You haven't said what source your data is coming from, but assuming it's relational you presumably need filters for
[Priority] is not missing
and
[Reason Code] is not missing
Thank you BigChris for the response. When I do that it is filtering out the records that I need. I was able to achieve it using union. Appreciate your help.