The fields from Reference field coming as blank in report

[shrivasu]

Hi,

I was creating this report on m2m_kb_task table by adding few fields from (task+) reference field   and few from (knowledge article+) reference field .

when I run this simple report the columns which are on task and knowledge article table is showing as blank . I have checked the ACL and it fine , I am able to generate report on task and knowledge table individually. Any suggestions ?

Thanks,

Umesh

[bernyalvarado]

Would you mind sharing some screenshots?

a) Your table in a list view. Navigate to m2m_kb_task.list

b) A screenshot of your report.

If it's blank I can think of two things:

a) the value does not exist

b) the display value of the record been referenced is blank.

Thanks,

Berny

[shrivasu · Accepted solution]

Solved . There were no Read ACL for this table , so created one and it worked fine after that .