Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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.