Hello all,
I have a couple of UD fields I need to include in an SSRS report. They are descriptively named “Number 01” and “Character02.” I can view and access these fields both through Crystal Reports and the Epicor BAQ designer:
In Crystal:
And in BAQ Designer:
But alas! When I try to garb these fields in Report Builder, they are missing:
Any thoughts? I really need to make this work…
Thanks,
Alice
From the looks of it you are using a direct SQL connection for the SSRS report. You would need to reference the table ShipDtl_UD and join it with ShipDtl.
Excellent, thank you! I will start there.
Even easier than adding another table and linking, just use dbo.ShipDtl rather than Erp.ShipDtl.
Lots of people seem to now know about this, but to me Epicor is creating a SQL view for any tables that have UD fields that combines Erp.TableName and Erp.TableName_UD into a single view with all columns called dbo.TableName.
Also, you might want to check the Report Data Definition. You may not need to link the table. Many included column are already linked in 10.1. You will still need to select the UD field in the report SQL statement. Good luck.
