I have a custom ARForm set with our company customization in Epicor. I would like to clone the custom form to create two separate ARForms, one with US info and another with CDN info.
I tried copying the custom form and applied the same Data definition for both forms. When I go into SQL SSRS to edit the forms, I only see one custom report in reports > CustomReports > ARInvoiceForm > ARForm, which is the original copy from the standard.
I would like to have the option in the dropdown to select the StandardSSRS, CustomCDN, and CustomUS. I have this now after copying the custom form, When I print off both custom forms I get the same output.
How can I edit the two custom forms in SSRS as only one is showing in the CustomForms.
Any suggestions or different ways I can I achieve this would be great.
Go to the SQL SSRS and open the US (or original customized form).
Save it it as ARForm_CAN-xxx (or whatever so you can identify it.
In Report Style Maintenance, make a new style (using all the same values as the as the original US one).
Change the file name in the report path to “ARForm_CAN-xxx” (or whatever you named it.
Go back into SSRS report designer and make your changes to the SSRS RDL form
When I run a report I get the following error that form cannot be found
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: The item ‘/EpicorPilot10/reports/CustomReports/ARInvoiceForm/ARForm-US’ cannot be found. —> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/EpicorPilot10/reports/CustomReports/ARInvoiceForm/ARForm-US’ cannot be found
Did I miss a setting in the Report Style Maintenance?
Unless you create a new Report Data Definition (RDD), the Data Definition for the US style should be ARForm.
In Report styles, The Data Definition refers to the data to be passed to the SSRS report.
The Report path refers to the particular SSRS RDL to display the data. So two differnt styles can use the same Data Def, and just have different layouts.
