We want to add the Promise date to the releases on our PO Form. I made a copy of the canned report and linked it to a copy of the original RDD. Everything works fine. Then I unexcluded the PromiseDt column in the PORel table, synced the dataset and print previewed the report. I got double of the rel…

After looking and reading a second time, you are saying that the Report took a Line with a single Release for 2500 SF and when it created the Report it is showing a Line with two Releases for 2500 SF giving you a Line total of the 5000. What does the standard Report show? Can you share what the PO…

Correct. The standard report shows 1 release for a total of 2,500 parts. I didn’t change anything in the SSRS report or the RDD except for unexcluding the promise date from the porel table in the RDD. [image]

I tried to recreate at my end in a couple of versions but I wasn’t able to do it. You mention that you ‘synced the dataset’, I didn’t do that in my testing. Maybe you duplicate your process creating another copy of the base Report Style and RDD without the ‘sync’. I’m not sure it will work but it…

[image] Sync Dataset error on new Report Epicor ERP 10 “Sync Dataset” is almost never a good idea. And I mean like 99.9% of the time. All you need to do is Dup the report style Change the new styles RDD to the one you created Edit the report RDL, adding the fields and …

I got rid of everything and started again. However the report is just printing the label, not the value. [image] Made a copy of the RDD and unexcluded the column [image] Made a copy of the base report and selected my new RDD. [image] Updated the Dataset Query to add the ReleaseDt field: […

Just a guess here - try changing your select query to T1.PromiseDt instead of T3.PromiseDt? DaveO

I get an error when I change it to T1 Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘POHeader’. —> System.Data.SqlClient.SqlException: Invalid column name ‘PromiseDt’. Stack Trace:

I’m not seeing any issues with what you’ve shown. You could try in your RDD on the PromiseDt field to recheck the box in the ‘Exclude Label’. I only suggest this in that when I add columns to my RDDs I don’t uncheck and I don’t normally experience any issues.

What is the Table that you are calling it from in the RDD, I don’t see it in the screenshot. If it is POHeader then you would want T1 in the RDL but if it is PORel that would be T2. In 2024.1 the base RDD has the PromiseDate included in POHeader(T1) with PromiseDT excluded in PORel(T2). Based on t…

Ms. Mellissa: is the POHead.PromiseDt - enabled in the RDD? DaveO

PO Form SSRS & RDD

Epicor ERP 10

aosemwengie1 (Alisa Osemwengie) May 16, 2025, 6:46pm 5

Don’t do it. It’s never a good idea.