Trying to modify RDD for PackSlip report - SSRS

Epicor ERP 10
1

Hello all,

I have an SSRS report that uses the boxed “Packslip” RDD and a modified SSRS report. I would like to use a field that is not visible in the original RDD - “ShipDtl.OurInventoryShipQty.”

To accomplish this, first I went into the Packslip definition within Report Builder and tried to add the field to the dataset myself:

1
1.png589×661 22.9 KB

When that didn’t work for me, I duplicated the RDD within Epicor and made sure my desired field was not “excluded”:

2
2.png1005×688 43.8 KB

I went to my report style and chose my new RDD for the selected report:

3
3.png753×49 1.96 KB

Here is where I get stuck:

Can I use the same report in Report Builder but access the new RDD as well? As of now, the report is still pulling the original “PackSlip” definition:

4
4.png1315×792 87.3 KB

Thanks so much. I’m really hoping to better understand how this works.

Alice

2

After copying the RDD and including your desired field, you need to go into the PackSlip rdl and add that field to the dataset, the same way you did in your first screenshot. Also remember to add the field on the Dataset > Fields tab. This isn’t automatically updated when you change the query text.

3 Likes
3

Tyler is right, you needed to add it to your query if it wasn’t already there, and then you have to add it to the Fields Tab.

1 Like