I am preparing to go live with Kinetic 2024.1.12 in near future. My old ARInvoiceForm custom changes from 10.2.700 won’t work in new version. I am attempting to redo my form using the duplicated base report data definition of ARForm. For my testing, I MAKE NO CHANGES TO THE RDD or .rdl form at this point. I just save the copied rdd and assign it to a new report style. Then I generated a preview of an invoice using the new report style. I cannot generate a preview of the form in Visual Studio. I receive this error:
***"*Program Ice.Services.Lib.RunTask when executing task 12472599 raised an unexpected exception with the following message: RunTask: Ice.Core.SsrsReporting.SsrsCaller.SsrsException: The SSRS server returned the status code 500 (InternalServerError) with the following error text: System.Web.Services.Protocols.SoapException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘ARForm’. —> System.Data.SqlClient.SqlException: Invalid column name ‘Calc_TrackByAttribute’. Invalid column name ‘RptLiteralsLServiceSource’."
I have tried removing the Calc_TrackByAttribute and RptLiteralsLServiceSource from the dataset query in Visual Studio. This allows me to view the report but I still receive warnings that the field definitions exist for the dataset without the associated query results. I tried to remove the fields from dataset also, but then the report errors out again with error that the fields are referenced in the .rdl without the appropriate dataset defs. These fields are needed in visibility expressions within the ARForm.rdl. How does the base report run but yet the copied rdl and rdd for this form do NOT work even though NO changes were made???
Does anyone know how to resolve this error and get the desired info to the .rdl for processing?
I removed the problematic columns from the dataset query but kept it defined in the dataset field definitions. This allows the form to work but I keep getting warnings that the columns are defined but no data is going to them. This is true because I removed from the query to try to get it so that I could work on the form.
I found the columns in the actual .rdl by looking at it in Notepad++. They are actually used in a visibility expression. I can just remove them from that expression but was afraid that would change the functionality of the form. Maybe that is my best option… just remove it from visibility expression, dataset query, and dataset field definitions within Visual Studio???
I thought someone might know of a better way??? It boggles my mind that the base form and rdd would have this issue when I just duplicate them with no changes. How does the standard form work? Makes no sense to me.
Oh wow! I never noticed that there are 2 AR Invoice RDD’s now! That explains it! Thanks so very much!
How do you tell which rdd the base form is using within Kinetic (or Classic) so that I don’t make this same mistake on another form?