SSRS sub-reports after upgrade

Epicor ERP 10
1

After upgrading from 10.1.400 to 10.2.300, things are going fairly smooth.

But one thing that reared its head was that the subreports in customized RDL, are failing.

I’ve not customized the sub-report. So it is a copy of the original sub-report for the original form from 10.1.400. Here’s a time line…

On server ‘A’ running 10.1.400:

  1. Copied POForm report style to POForm_001. This copies every RDL in /reports/PurchaseOrderForm/ to /reports/CustomReports/PurchaseOrderForm/. One of those files is POForm-PORelQty

  2. I customize CustomReports/PuchaseOrderForm/POForm (saving it as POForm_001). None of the customizations affect sub-report POForm-PORelQty.

Report POForm_001 runs just fine on server ‘A’

On server ‘B’ (which is a new install of 10.2, and App and DB’s from ‘A’ copied over and upgraded)…
3. Copied CustomReports/PuchaseOrderForm/ folder to server ‘A’ to server ‘B’

  1. Running report POForm_001 on system ‘B’ runs, but with “Error: sub report …” where the POForm-PORelQty sub-report should render.

I have to replace /CustomReports/PuchaseOrderForm/POForm-PORelQty with the one from
reports/PuchaseOrderForm/POForm-PORelQty in order for the sub-report to work.

A comparison of the two original POForm-PORelQty sub reports (the one imported to 10.1.400 when it was deployed, compared to the one imported when 10.2.300 was deployed), show they are significantly different. I’m guessing the datasets created by the RDD’s differ too.

2

tagging @Jason_Woods - as the above might be something you run into.

3

Are you sure that the name of the subreport is POForm-PORelQty? out of the box the name does not have POForm, it is just called PORelQty? Although it should not matter, I am just raising the possibility that this subreport has been modified.
Also, is the dataset in the subreport pointing to the correct database?.
Can you post the full error message?

4

Here are screen shots of the “out-of-the-box” files for the PurchaseOrderForm report. The first is from 10.1.400.23

Screenshot_20191228-121238
Screenshot_20191228-121238853×364 175 KB

And the following is from 10.2.300.23

Screenshot_20191228-121458
Screenshot_20191228-121458984×624 284 KB

5

Are you sure that the name of the subreport is POForm-PORelQty? out of the box the name does not have POForm, it is just called PORelQty? Although it should not matter, I am just raising the possibility that this subreport has been modified.
Also, is the dataset in the subreport pointing to the correct database?.
Can you post the full error message?

Did you compare the RDD between the two versions?