An error has o curred while processin Table 'crosstab1'

1 Answer 41 Views
Report Designer (standalone)
Mesut
Top achievements
Rank 1
Mesut asked on 22 Feb 2022, 08:39 AM

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

Sort by
0
Yana
Telerik team
answered on 25 Feb 2022, 08:08 AM

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

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
Report Designer (standalone)
Asked by
Mesut
Top achievements
Rank 1
Answers by
Yana
Telerik team
Share this question
or