Failed to Retrieve Data from the database.

getting the following error message stating that

Failed to retrieve data from the database.

Details:4200:[Microsoft][ODBC SQL server Driver][SQL server] Incorrect syntax near 'Category ID', [Database Vendor Code: 102],

i am not sure why I am getting above error message when running the report.

I have a view linked to table. The Category ID is in View that I have created.

need your help if you know what steps I should take to reslove the issue, thanks!

mansoor