Skip to Content
avatar image
Former Member

Cross-tab expert missing field

My report, showing results of surveys, is connected to an MS Access database, which gets data exported from some 3rd party application. A new free-form question was added to the 2 other ones that were there before. I'm trying to add a cross-tab, similar to the way the other 2 questions were added. When looking at the Field Explorer, I see my new field, yet I don't see it in the available fields when clicking on the cross-tab expert.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 08, 2017 at 02:24 PM

    Hi Phyllis,

    1. Create a new formula and reference the database field in this formula.

    2. Use the formula field in the crosstab instead of the database field.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded