cancel
Showing results for 
Search instead for 
Did you mean: 

Eliminating a column on a cross tab

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Ended up revising my TSQL code to return a null value instead for the last field. Yes I now have an extra field with all '0's on my report but it should serve it's purposes.

Answers (1)

Answers (1)

former_member183750
Active Contributor
0 Kudos

Antonio, if you wish to see how the GridValue function works, consider downloading SAP Crystal Reports 2013 eval from here:

http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx

CR 9 and CR 2013 are side by side compatible.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Former Member
0 Kudos

Hi Ludek,

It would be great but Crystal Reports 9 does not have this function.