Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

UserTest1Test2Test3Test4Field to be removed
User101111
User210011
User300001

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.

Any ideas?

Former Member
replied

Hi Antonio,

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.

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question