Edit Advanced Query Editor from Desktop?

[Dhayorr]

Am pulling data from an excel sheet, so I added some lines in the Advanced Editor and the below error keeps popping up when i try to apply changes.

Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
Table

[ntaylo06]

You'll have to give more information. What were you trying to do? 

[Dhayorr]

I previously had the first 4 lines for the report and report worked perfectly. I then added the lines as shown below but on applying it, it showed the error I earlier reported. Checked everything i can and it still keep throwing that error. 

[Dhayorr · Accepted solution]

I later found the reason for the error message. A column name i was referring to wasn't in the particular xls file i was using, the reason for the error i was receiving. 

Thanks