I can't create a report; the message 'incorrect syntax near' appears

Created by Flavia Menegazzo, Modified on Wed, 6 Sep, 2023 at 9:59 AM by Flavia Menegazzo

BA can bring a lot of data, rows, and columns, but there is a limitation.


The 'incorrect syntax near' error occurs when the amount of information (whether it's rows, columns, or characters) exceeds the functionality limit.


Therefore, to generate reports where this message appears, the solution is to add filters (source, users, surveys, etc.), or reduce the analyzed period, or even reduce the selected rows and columns.

It may be necessary to generate more than 1 report with the same data and different filters.


I hope I've helped, and I hope you can generate your report now.


See ya!

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article