Eliminating a column on a cross tab
Currently using Crystal Reports 9 and I have a dynamic cross tab that serves as a checklist.
For example - The cells are a count of the column field.
|User||Test1||Test2||Test3||Test4||Field to be removed|
My issue here is that I need to remove the last field but keep the user on the list. If I do a selection filter or a group filter that filters out the last field, User3 will be eliminated because it will have no records of field Test1-4.
Abhilash Kumar replied
You can suppress columns using GridValue functions, however I don't think GridValue functions (available in CR 2008 or higher) work in CR 9.
If you wish to see all Rows, you should consider creating a 'look-up' table that has all values you see in the Crosstab's rows and Left Join this table to the existing table so there aren't any 'gaps' in data.