Hi, i have below query that i want to use in the Report. However when i copy paste the below query in data tab where Queries are written i am getting error messages. The same query executes and displays results without errors in SSMS. Please advice what i can do to make the below work for reports -------------- ------ERROR MESSAGE in BIDS---------- An error occured while executing the query. Incorrect Syntax near 'GO' Incorrect Syntax near 'GO'