Hi
I have had to copy and edit a standard Report Data Definition ‘QuotForm’ in order to add some additional fields. So I now have ‘QuotForm_JGR’.
In the Report Styles I have changed my Data Definition from ‘QuotForm’ to ‘QuotForm_JGR’. Do I also have to change this in the SSRS report as the dataset currently reads dsQuotForm.
I have edited the SQL of the dataset to include the new field and added it to the field list, but when I try and import my report to Epicor it fails.
Any suggestions?
what’s the error?
Well that’s super helpful. 
My thoughts exactly. Epicor support couldn’t offer much advice either.
You zipped them back up the same way you downloaded them, right?
Yes
I’d start by double checking your SQL. Sometimes you got to do a custom report a step at a time. Tedious but, change the SQL syntax, test, add the field, test again.
Thanks @Randy. While I haven’t got my report working yet it is giving me a more meaningful error that I can work with.
The upload now works, but when I generate the report, I am told the '‘SalesPersonTitle’ isn’t available.
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 ‘SalesPerson’. —> System.Data.SqlClient.SqlException: Invalid column name ‘SalesRepCode_SalesPersonTitle’.
Below are screenshots of my Report Data Definition and SQL Query
="SELECT T1.Company,
T1.QuoteNum,
T1.PrimeRep,
T1.Name,
T1.SalesRepCode_FaxPhoneNum,
T1.SalesRepCode_EMailAddress,
T1.SalesRepCode_SalesPersonTitle
FROM QSalesRP_" + Parameters!TableGuid.Value + " T1"
I am hoping that I am just missing something really simple, so any help would be great.
from the data definition screenshot it looks like you need to change
T1.SalesRepCode_SalesPersonTitle to
T1.SalesRepCode_SalesRepTitle
Agree @zwilli526 think his DS Expression should be:
You would also need to update the column names {Field Source/Field Name (if desired)} looking at the image.
Thank you. That works perfectly.
