UD Field Data not showing on SSRS Report

Hello All,

We added a new UD field to our Part menu.

I have that field as a column on a new version of our Stock Status report, but the data is not showing. What am I missing?

1 Like

It would probably help to include screenshots of your report data definition, rdl dataset select statement, etc.

Hi Sorry about that.

image

image

And the expression for the field containing the data on the report?

1 Like

Did you add the field here?


Just PartAssociate in Field Name and Field Source should work.

1 Like

Here ya go.

Is “UD_PartAssoc_c” the name of your UD field?

I previously had issues with a couple UD fields early on in my customizing where I included an “underscore” in the name. The problem is, Epicor uses the underscore to perform logic in various situations.

For example, the first field in your query is T1.Calc_UOMConvWarning. The system uses that underscore to signify the calc field.

Similarly, if you used Linked Tables in your RDD, the RDD uses a format of (for example): T1.CustNum_CustID. It is using the underscore in this case to identify the CustID field from the CustNum linked table, which is linked to T1.

Long story short… I have found it is problematic to use underscores in your UD field names.

1 Like

Yes we have added it there.

Try making those (Field Name & Field Source) both PartAssoc.

I’ve never used different names.

We did already, but still same outcome. No data shows.

Epicor automatically adds that _c to the UD fields. Is there a way to change it?

When you’re doing that did you also change it in the query?

Okay… well, then I’m going to revert back to my previous post that it could be your UD field name containing that first underscore.

The underscore at the end “_c” is okay. but I think the system is misinterpretting the first underscore.

T1.UD_PartAssoc_c

If it follows the same logic, it thinks T1 (Part) is the main table, “UD” is a linked table, and PartAssoc_c is the field name. Which is not correct.

1 Like

In your query you have it set as “T1.UD_PartAssoc as PartAssociate” but then reference it as “PartAssoc” instead of “PartAssociate”.

Good catch there!

Just tried that, but still same result
image

image

We are going to try this.

1 Like

Let us know how it goes. SSRS can be a pain!

So we ended up rebuilding our report style and it just worked…didnt change the underscore for the UD field. We built the report the exact same way as the first time, not sure what happened… but thx for everyones help!

1 Like

Well now I’m wondering if this is what I need to do with the issue I’m having in my most recent post. For the life of me I can’t get the report to show in two columns on the page.

Glad it worked out and thanks for letting us know. Might be helpful to others to mark your own post as the solution.