JobTraveler report add a new table (Part) and get no results

Epicor ERP 10
,
1

Hello to all,

This is my first attempt to add a table to a RDD. The jobtraveller report needs to have a field from the Part table (Part.Specification).

I added the table, added the relationships (to the best I could figure it out ) got a few errors because my fields were excluded… :wink: but got it to work without errors.
So I went under the Reports table and saw my Part table present, but it is empty.

I was wandering what am I missing in my setup.

The following document contains my snapshots modified dataset query.
New table added to JobTraveler RDD.docx (121.4 KB)

Anyone could help me resolve this?

Thank you.

Pierre

2

One difference is I have Relation Type in the Report Data Definition set to Output

3

Not answering your particular question but I find the Linked Tables features much easier than adding a new table. Start with selecting the JobHead table and go to the Lined Tables Tab. Make sure that PartNum is in the Picked panel.

image
image806×525 26 KB

Switch to the Description Fields tab and make sure PartNum is chosen for Pick Fields for this Link. Now just select the fields you want, like Specification.

image

In your SSRS report, you access the field as PickedFieldName_Field, e.g. PartNum_Specification.

Before adding a table, I will try using a Linked Table first since there are fewer steps to get the job done.

2 Likes
4

That was the solution to have data in the Part table!
thanks!

5

Thanks Mark,

I will test your suggestion as well…

Pierre