I am trying to create a modified version of the boxed SSRS PackSlip report that came with 10.1. I need to add the UD fields indicated below (from ShipDtl):
Since the report data definition does not already include these fields, I tried to use a subreport (In which I linked ShipDtl and ShipDtl_UD) but since I can only link the subreport by PackNum, all my UD fields for all lines are coming out on every line:
It makes sense why this is happening but I can’t think of an alternative way to access these UD fields. I checked to see if I could “un-exclude” the UD fields in the RDD but they don’t seem to be visible.
Do I need to modify the RDD itself? If I do, will the report still be a viable report style when printing from Customer Shipment Entry?? I am pretty new at this and my mind is boggling…Help!
How do I update the RDD in the boxed SSRS report to reflect these changes so I can access these fields within Report Builder? I understand that I will ultimately create a new style on the Epicor menu, but I need to edit the report to include the added UD fields, first and foremost.
After adding these UD fields, did you regenerate the data model in EAC? If so, you should see these fields available in the ShipDtl table so that you don’t have to join the UD table. Oh, don’t forget to stop and then start the app pool.
