Glad you got it sorted. Did you ever check the Filter and Order By properties? Something was hiding somewhere.
Glad you got it sorted. Did you ever check the Filter and Order By properties? Something was hiding somewhere.
I have it solved, although I don't know what it was. I just used the new report.
Thank you all for your help.
it is not unknown for strange error messages to occur when proper naming conventions are not followed. Using square brackets often solves the problem, but not always
In your case you have spaces in field names, using # and using reserved words.
That 'solution' indicates the original report was corrupted.
Decompiling will often fix such issues by removing all compilation code and with that any corruption in that code.
Last edited by isladogs; 05-07-2021 at 07:30 AM. Reason: Corrected ...Decompile not recompile