Hi All, I’m new to working with Epicor (Kinetic 11) and SSRS Report Builder. I’ve been able to customize the Job Traveler but have hit a wall with bringing in some fields that are in a user-defined table. I added the table in data definitions and created the relationships exactly as it was done for…

It’s a pain in the a… I’ll see if I can find you a post so I don’t have to explain it :rofl:

I can’t find what I want, but if you’ve already got the rdd fixed up, open up the Traveler.rdl file in report builder. In the tree on the left, right click on Datasets->JobHead, select Datset Properties. Stay on the Query screen, and click the little Fx button by the Query Expr window. Inside th…

Thank you. I did try that a few times with no luck.

Well maybe something is wrong with your rdd. Let’s see how you set up the link, and the query text.

[image] Link POform SSRS to Memo table no value return issue Kinetic 202X Oh sorry, I’m pretty new to using this forum so I didn’t even realised that the post was actually viewed by people sweat_smile I’ll just write the scenario that required me to link the Memo and the …

Thank you for the very detailed response. I have taken all the steps mentioned. I’m working with Epicor trying to get this to work as well. Still no luck. I keep thinking I’m closer but no avail. I believe the problem lies in the syntax in SSRS that I have. The problem is the Part_UD table can only …

[image] ngreene: Part_UD table can only be joined to Part table by SysRowID and ForeignSysRowID Here is your issue. You do not need to bring in Part_UD. Your UD fields will be brought in via part. Check the exclusions list, and remove all the part_ud stuff.

Another useful trick I like to do is run the report and set the archive period for a day or week, then look at the tables in the Report temp tables to confirm that the RDD is returning data, once I do that I then ensure that the query in the report data sets has the fields in the query and the field…

I started with that option and it wouldn’t come over. Also, all exclusions have been checked over as well. I also set the archive period to day.

Issue Bringing in UD Table to Custom SSRS Report

Kinetic ERP

klincecum (Kevin Lincecum) June 20, 2023, 4:27pm 7

Topic		Replies	Views
SSRS Job Traveler (Joining to UD table in data set expression, UD field is not returning data in report) Epicor ERP 10	18	3654	February 23, 2018
Difficulty getting UD field onto Job Traveler Kinetic ERP ssrs	40	2126	December 21, 2023
Add new field from another table in Epicor 10.1.500 Epicor ERP 10 reports	9	1505	February 12, 2020
Report Data Definition Kinetic ERP epicor , customization , ssrs , reports	17	3346	July 13, 2023
Trouble adding table to sub report in Job traveler Epicor ERP 10 e10 , ssrs , reports , rdd , sub-report	29	3450	November 18, 2020

Issue Bringing in UD Table to Custom SSRS Report

Related topics