Adding UD Fields into a New Blank SSRS Report

ewidjaja · January 24, 2019, 5:39pm

Hi All,
I am building an SSRS report by itself (no Epicor, RDD, etc.), just accessing the database straight from Report Builder. It is working so far, except for the UD fields. SSRS gave me no errors about joining to a UD table, and the report would come up but with blank values on the UD fields.

Any ideas?
Thanks!
Elvin

Aaron_Moreng · January 24, 2019, 5:48pm

Did you join to the View or the UD table itself?
Epicor will create a view in the db which joins in the table with the UD table

ewidjaja · January 24, 2019, 5:52pm

The one i have tried so far is inner joining QuoteQty to QuoteQty_UD on QuoteQty.SysRowID = QuoteQty_UD.ForeignSysRowID

How would I access the view?

ewidjaja · January 24, 2019, 5:57pm

I tried using dbo.QuoteQty but no luck

Aaron_Moreng · January 24, 2019, 6:05pm

reference your database in there as well

This worked for me:

ewidjaja · January 24, 2019, 6:49pm

That did it! I also found out that using the query designer works too. Very odd.