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
Error in web app but not in desktop designer
Error in web app but not in desktop designer
- Attachments
-
- sample.mrt
- (170.57 KiB) Downloaded 86 times
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: Error in web app but not in desktop designer
Hello,
Please set the CacheAllData=true property for the report.
Also, please check the last release build.
Thank you.
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
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.
Unfortunately I am not able to upgrade the version running in the app at this time.
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: Error in web app but not in desktop designer
Hello,
Could you send us test data for your report?
Thank you.
Could you send us test data for your report?
Thank you.
Re: Error in web app but not in desktop designer
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
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: Error in web app but not in desktop designer
Hello,
We couldn't reproduce the issue on our data. Please try to check the last release build.
Thank you.
We couldn't reproduce the issue on our data. Please try to check the last release build.
Thank you.