Database View report drilldown not working

[yundlu316]

Hi Everyone,

Our team has created a database view that combines sys_user, tasks, and aprofile table we built separately.   From this database view, I was able to create a column report that shows past due tasks by manager.   I also created a drilldown view where if someone clicks into one of the columns, they can see a list report of details.   The initial view of this column report shows up just fine, however, when you click into a particular column, the list report never shows up and all I see is a spinning circle saying "Loading Report..."

Any ideas?

Thanks.

[devi_putra · Accepted solution]

Hi David,

So you are impersonating with some other user who has role "HR Supervisor". Here you are able to see the report but when you click on the Red column you are getting that message. So as i mentioned above, whenever you click on the Columns in the Report you will be redirected to the List view of that particular Table which is used in the Report. Here as you have created this report on a Database view, so when you click on Red column you will be redirected to list view of the Database view(here i.e Database view for sys_user, task, and employee profile).

Now the reason why that message is coming is:

The User you have logged in might not have a Read access to any one of the above mentioned tables(sys_user, task, and employee profile).

So could you please open each table individually & check the Read access controls given roles & see if this user has those Roles.

How to check this--->

Login as Admin user, go to "Tables" module, open the required table(for example: say i am opening "Task_sla" table)

Then you will see

Then in the Related Lists you will see the Access Controls for that table,

Search for read operation ACL

Open this ACL, & see the Roles given in this ACL...

So just check the roles given in ACL's similarly for all the 3tables mentioned above & see that those Roles are given to the User you are impersonating to view the Report Content.

Hope this will help you.

Thanks,

Devi.

PS: Hit like, Helpful or Correct depending on the impact of the response.

[yundlu316]

Hi Devi,

I was able to fix this issue by going into System Security > ACL and creating a new read ACL specific to my database view.

Thanks for all your help!

[devi_putra]

Hi David,

Thanks for your reply.

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this discussion from your "inbox", use the "mark as correct" option under actions. If you are viewing it directly from the thread use the Correct Answer link (red with a star).

Thank you

Devi