I am running into an odd SSRS problem ever since the Public Cloud upgrade this weekend to Kinetic 2025.2.7. For years we had a slightly customized ARForm used for AR Invoices. It has worked fine up until the Pilot Environment was upgraded to 2025.2.7 several weeks ago. At that point I was getting a Server error. For reference the base ARForm works fine. So beacause it had been a long time since our custom SSRS was created I decided to start fresh as there is not that much modications made to it. So in Pilot I found the base SSRS report style and went to Actions > Download SSRS Report. I made the simple modifications (removed a few fields on the report that we don’t use, moved a few fields around on the page, added 2 text boxes with some verbage, and added our company logo. I made no modifications to anything in the dataset. After that I saved my changes. I then went to the Report Styles and created a new report style, set all the settings to match the base form including the exact same RDD. The only thing I changed was the name of the report style and the path to be at reports/CustomReports/ARInvoiceForm/ARForm,reports/CustomReports/ARPBForm/ARPBForm. I clicked save in Reports Style and then went to my C:\reports folder and copied the 2 folders (ARInvoiceForm and ARPBForm) and moved them to the C:\reports\CustomeReports subfolder. I went back to the new report style and clicked Actions>Upload SSRS report. In Pilot everything then worked with choosing the new report style when I tried to print priview an AR Invoice. After the Production upgrade this weekend I tried the same steps above in Live Production environment and now I get the error below. Anyone have any ideas how I fix this? Again base report print previews fine.
The problem is either in the RDD or if those fields are unnecessary than you can remove them from the report. You would have to remove the textboxes and the fields in the dataset. I have had the same happen, unfortunately I don’t have great advice for why.
Depending on what version you are coming from the RDD that the ARForm is tied to has changed. You will likely need to point your current custom form to that RDD and most likely have to copy that RDD and make the custom changes to it to add in these custom fields.
Additionally it is only very recent version upgrades where I have not had to quasi-rebuild my custom RDD for the ARForm, this is about the only report I ever used to have trouble with but in the last version or two it has been pretty good.
To echo @leonardpothier, there are two different RDD’s… One is ARForm, the other is ARInvoice.
I’ve been using the ARInvoice RDD tied to my ARForm report styles. Which are you using?
Based on the error message, it appears that BranchID is in the report but not RDD. If you don’t need the field, try deleting it from the query in the .rdl and from the field list (in the .rdl).
So our old Custom ARForm was using the “ARForm” RDD. The new one I picked the “ARInvoice” RDD because I noticed the base form uses that one. My new custom report is a fresh copy of the base form.
So I am not actually adding in custom fields really. What I added was 2 text boxes with verbiage on the SSRS report directly and our Logo picture. The fields it says it is missing (invalid column name) I didn’t add to it, this is a direct fresh copy of the base form. I am not using a custom RDD, only the system one that the base form uses called “ARInvoice”.
