SSRS Job Traveler (Joining to UD table in data set expression, UD field is not returning data in report)

Epicor ERP 10
19

Here is the solution I found that resolved my UD problems in 10.2

Steps to add UD fields if they are not recognized in the data source exclusions:

  1. Navigate to RDD and expand data sources
  2. Click on the data source (table) that you would originally link your secondary table to (PART)
  3. With the parent data source selected you need to drill down to “description fields” and select a direct link to your secondary table (My example Jobhead and Part had “PartNum” in common.)
  4. Chose to bring over “SkidProgram_c and IndivSkidLabel_c”
  5. Saved the data set and navigated to report styles
  6. Unfortunately I had to sync the report style so my dataset would see the UD changes (This will overwrite your data set expressions, so I suggest you always make copies doing this)
  7. After syncing my RDD to the report I confirmed my dataset had the fields in the expression and in the field section.

image
image.png767×527 25.6 KB

T1.[PartNum_IndivSkidLabel_c], T1.[PartNum_SkidProgram_c] FROM JobHead_" + Parameters!