Can we combine two tables and get the fields without need to not walk to use in a report

[Nasreen2]

Hi All,

I got a requirement where user wanted to use the fields of multiple tables(task, asmt_assessment_instance, asmt_metric_result) in a single report since they wanted all the fields to be selectable directly from a single report for some Reporting automation to be done. So, I have created a database view combining these tables, and when I use this DB View in the report, the fields/columns coming from other tables are available as dot walking fields as shown below.

Here instead of dot walking, they wanted the fields to be available for direct selection like for example, instead of expanding the Assigned to field and then selecting the required field, they want that field to be directly selectable without expanding.

Is this possible to configure? 

Thanks,

Nasreen

[Ankur Bawiskar]

@Nasreen2 

If my response helped please mark it correct and close the thread so that it benefits future readers.