report issue while geeting the value of relate filed

i have a module called docket and it consist a relate filed that point to other module called branch.when i save a record for docket module using a relate value from branch module its saves the page successfully

ISSUE:
when i goto report module and select a module docket where i choose to column name and a relate field and simply saves the report it show 0 records but when i remove the relate column it show correct values…

its a logical mistake or its a bug in suitecrm?

check your the sugarcrm.log file and see if there are any database errors when you run the report,