Page 1 of 1
Error in web app but not in desktop designer
Posted: Wed Aug 10, 2022 11:37 pm
by KDH
I have built a report in the desktop designer and it is working fine in the designer app. When I load the report to run in asp.net app I am getting this error:
"The column 'VersionID' does not exist in the Data Source 'VersionsSplitOrderNumber_Select' and the relation 'Name' can't be created"
The web app is running version 2020.2.3
Any suggestions on how to get past this? I have attached the report
Re: Error in web app but not in desktop designer
Posted: Thu Aug 11, 2022 7:34 am
by Lech Kulikowski
Hello,
Please set the CacheAllData=true property for the report.
Also, please check the last release build.
Thank you.
Re: Error in web app but not in desktop designer
Posted: Thu Aug 11, 2022 3:21 pm
by KDH
I am getting the same error when I set Cache all data.
Unfortunately I am not able to upgrade the version running in the app at this time.
Re: Error in web app but not in desktop designer
Posted: Fri Aug 12, 2022 6:57 am
by Lech Kulikowski
Hello,
Could you send us test data for your report?
Thank you.
Re: Error in web app but not in desktop designer
Posted: Fri Aug 12, 2022 4:49 pm
by KDH
Unfortunately cannot share the database and mocking up data would be very difficult as the report is tied to stored procedures that pull data from 50+ tables
Re: Error in web app but not in desktop designer
Posted: Mon Aug 15, 2022 7:13 am
by Lech Kulikowski
Hello,
We couldn't reproduce the issue on our data. Please try to check the last release build.
Thank you.