Skip to Content
avatar image
Former Member

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 User1 0 1 1 1 1 User2 1 0 0 1 1 User3 0 0 0 0 1

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 14, 2015 at 09:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Jan 14, 2015 at 04:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded