Hi Guys,
I am building a report that prompts for a vendor:
When I run the report it shows the Vendor ID:
I would like it to show the vendor name:
Currently my schema on report designer looks like this:
And no filters for that particular field:
Here is the report:
Does anyone know what I should do to display the Vendor name
Best answer by BenjaminCrisman
View originalYou can use AcctName from the vendor table.
=[Vendor.AcctName] instead of @Attorney.
Hi Yisroel39,
When i use acctName the field is no longer a lookup field
Change it here.
Also, under your filter image above does not show ‘attorney’ parameter being used.
Hi Yisroel39,
When i change it
this is the result:
Review your table joins.
Any Ideas?
+4
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
