I recently encountered this error in one of the crosstabs of a report I am editing:
QE-DEF-0030 Expression parsing error.
QE-DEF-0360 The query contains a reference to at least one object '[SQL2].[migratedColumn]' that does not exist. Possible cause is the use of 2-part reference to a model query item, which is a deprecated feature.
This happens when I run or preview the report. Tabular view of the query is ok and returns data.
The root query, let us call it YTD, has SQL as its source. The crosstab's query source, is using YTD as its source:
I check everything in the query and crosstab, including the data items for sorting, etc and everything seems to be ok. .Took me several hours to figure out what is wrong.
Turns out, I edited the SQL and somehow did not validate it. Validating the SQL made the error go away.
