Unable to create reports

shaik23
Tera Expert

Hi mates,

Why i am unable to create reports on sys_data_source table i have admin access as well, any clues ?, while searching for table it is not showing the table.

 

shaik23_0-1722418856352.png

I have not impersonated.

5 REPLIES 5

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

System tables are excluded from being reported on.

If you must report on a system table, you can add it to the glide.ui.permitted_tables property.
Navigate to System Properties > UI Properties and locate the property labeled List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable. Proceed with caution.

-Anurag

Dr Atul G- LNG
Tera Patron
Tera Patron

ACL blocking it:

 

AGLearnNGrow_0-1722419148484.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG 

 

Does this ACL (report_view) impacting to create report? because earlier i have created ACLs same like report_on and report_view on custom table when we didn't given access to view reports still the user able to create report but the reports not visible.

Hi @shaik23 

 

This can be the reason also, as @Anurag Tripathi mentioned, need to update in property level as well. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************