2 Replies Latest reply: Apr 18, 2012 10:10 AM by James Allen RSS

    v11 11154 & Cross Table bug

    Amir Vastani

      Has anyone faced a bug with Cross Table load in v11?


      I used the QV Developer sample Budget.xls and it shows the proper Cross Table transformation in the Preview, however after the reload, both the transformed columns are the value of the Header Row.


      I also have a bug with INPUTFIELD in v11 whereby is you do fieldName AS inputFieldName, then try to use it, the straight table is blank.

        • v11 11154 & Cross Table bug

          Yes - exactly the same CrossTable bug you have found. The Preview looks fine, but the actual end result is totally useless (both transformed columns just have the header row values). I've just wasted an hour on-site with a client bashing my brains against the wall trying to figure out what's going wrong, without looking totally stupid


          My version is 11149 (v11)

          • v11 11154 & Cross Table bug

            Update: I have found that the CrossTable bug only surfaces if your header row values are numbers only (e.g. 1,2,3,4...). If you put some text in there aswell (e.g. Month 1, Month 2, Month 3...) the bug disappears and QV will read the crosstable correctly.


            I have infomed QV support, awaiting a response. This is definately a bug.