Kinetic Cloud - RDD linked Table Fields

Kinetic ERP
1

I have added a linked table and some fields within a standard Epicor RDD (after duplicating it), the below is the linked table and field selection.
When I try to edit the SSRS report that this produces it says it doe not recognise the fields.

image
image1233×626 136 KB

I have tried adding them into the query then adding the field as ‘query’ type.

Any ideas why the fields are not being recognised?

2

Show a screenshot of your query expression.

3

This is the error:

image
image1603×830 456 KB

This is the query:

image
image1591×317 13.2 KB

I was trying with just one field to start with

4

That error means there is a syntax mistake, like missing quotes, words that run together (missing space) etc. If you go back to the original query that works and add one thing at a time should be able to figure out where the error is.

5

The only bit I added is the below highlighted yellow

image

6

If you remove that bit, does it work again?

7

Yes, works fine without it

8

Are sure there is a space after ClassID in the query expression? Are you sure your custom report style is referencing that customized RDD?

1 Like
9

Thank You !!! there was a space after ClassID, i deleted it and reput it in and its worked, not sure why that made the difference but happy that it is working now :slight_smile:

3 Likes
10

Welcome to SSRS

1 Like
11

I had already OCR’d this to help so here it is. (Didn’t check for accuracy against pic yet)

= "SELECT 
    T1.PartNum,
    T1.AltMethod,
    T1.RevisionNum,
    T1.Calc_ShortPartRevDesc,
    T1.Calc_RequiredQty,
    T1.Calc_TopPartSeed,
    T1.PartDescription_PartDescription,
    T1.PartDescription_IUM,
    T2.AltMethod AS PartMtl_AltMethod,
    T2.Company,
    T2.MtlSeq,
    T2.PartNum AS PartMtl_PartNum,
    T2.QtyPer,
    T2.RevisionNum AS PartMtl_RevisionNum,
    T2.UOMCode,
    T2.ViewAsAsm,
    T2.Calc_AltPartRevAltMethod,
    T2.Calc_AltPartRevRevision,
    T2.Calc_Level,
    T2.Calc_ShortPartMtlDesc,
    T2.Calc_PartNumIndentor,
    T2.Calc_RequiredQty AS PartMtl_Calc_RequiredQty,
    T2.Calc_SeqNum,
    T2.Calc_TopPartSeed AS PartMtl_Calc_TopPartSeed,
    T2.Calc_UOM,
    T2.Calc_PartMtlDesc,
    T2.PlanningPct,
    T2.MtlPartNum_ClassID
 FROM 
    PartRev_" + Parameters!TableGuid.Value + " T1
 LEFT OUTER JOIN 
    PartMtl_" + Parameters!TableGuid.Value + " T2 
    ON T1.Company = T2.Company 
    AND T1.Calc_TopPartSeed = T2.Calc_TopPartSeed"

Yep, SSRS will strip new lines etc, and run your fields together. Need a space after everything.

2 Likes