RDD Linked Table Data

Kinetic ERP
1

Checking to see if anyone else is having issues with data from linked tables appearing on reports?

As an example, I have a custom PackSlip RDD where I used the JobNum linked table on ShipDtl to bring in CreateDate and ProdQty. However, the fields on the report show no data.

This is where I miss being able to query the report database. :cry:

2

Mr. John: I know one thing that always seems to get me - is when i am adding the Field names to the dataset (not the Select Query) in SSRS and I misspell the field name. The report will run without error (at least for SaaS customers) but the field will show blank.

I try to always use the Link fields whenever i can (easier than adding a table and fields).

DaveO

1 Like
3

Thanks @DaveOlender , I will check that out.

1 Like
4

This will be the answer.

You have to do ParentTableAbbreviation(i.e. T1).Linkedtable_LinkedTableFieldName in your RDL query after you add it to your data definition.

5

Bold prediction @utaylor ! Don’t you know I am the linked table king of EpiUsers!!

1 Like
6

I meant Dave’s suggestion is the answer. If you use a linked table you need to add the reference in your query. Now that I am re-reading it though I see he meant misspelling it in your Query fields section. That very well could be.

7

@utaylor & @DaveOlender you were both on the right track. It was a user error. Not me though, it was this user → :disguised_face:

I forgot to put the fields in the query :man_facepalming:t2:

2 Likes