Hello;
First I wrote my SQL query. As you can see in picture 1 my SQL query is working. I'm designing with Crosswizard. You can see it in Picture 2. Then I press the Preview button, the fault in picture 3 occurs. However, you can see in picture 1 that my SQL query is running. So what is the solution for this error?
1 Answer, 1 is accepted
Hello Kaan,
In general, the error indicates the Reporting cannot find such field in the database. Looking at only the screenshots, I cannot tell what exactly went wrong in this case - it seems in design-time the connection is properly established ( as you've used the Crosstab Wizard), while at runtime, the error is raised.
Can you check whether the database restricts access to the corresponding tables for some users, for example, the Reporting engine user? Please, check the KB article SQL Server Login failed for user DOMAIN\COMPUTER$ for hints.
I also suggest using a SQL Server Profiler to see whether there are requests from the Standalone Designer to the database. I hope it will log relevant information.
I hope this would help troubleshooting the error. If you still experience the issue, please open a support ticket where you can send us the runnable report, logs, etc, so we can provide further assistance.
Regards,
Yana
Progress Telerik