Report on Database view

[GBS]

I have created a database view that combines an incident table and a metrics definition table, and I have created a report on the database view. User was able to access the data from the list view but was unable to view the data on  report. Getting the attached error.

[Ankur Bawiskar]

@GBS 

Did you try creating a fresh database view?

[GBS]

@Ankur Bawiskar 

Yes and created a report on that database view 

[Mark Manders]

With a database view you will need to make sure that the user has access to all tables involved (db view, and the tables it is created of).

[Shruti]

Hi,

Check the report_view ACLs on both the tables. Make sure the user has required roles to access the database view report

[Ct111]

Go to  ACL module and verify the ACL's 

that start with name incident or  metrics  and have type as report_view

and understand what is blocking the access in roles or under script section.