Can't find my table when creating a report.

DP16 · ‎05-09-2019

Do you know why I can't find the table I created when I try to create a report?

pavan9885 · ‎05-09-2019

Hi open the read Acl and see any roles defined for that .

1. we can do it two ways here.

1) check the role for the ACL and you can assign that role to you (if you have permissions)

2. Remove the role for the Read acl and try to logout and login again.

3. Now you can check you can see the table name .

Let me know if you still have issues.

Thanks,

Pavan

Note: Please mark my answer correct / Helpful so this would be useful for others and it will not be wipped out from the community .

View solution in original post

DP16 · ‎05-09-2019

Hi Carl,

I don't have access to Tables and Columns, I only have access to "Tables."

I should be noted that I can still create reports. But I'm limited as to what I can do.

However, by not going through the "Create Report" route, I'm having trouble creating pie charts, and bar charts, etc.

Carl Fransen1 · ‎05-09-2019

The 'Tables' module will also work, head to that, then find your table, open it up, scroll to the bottom and you'll see all the 'Related Links', one of these is 'Show List'. Then once in the list you can click on any column label, using the hamburger icon, and select 'Create Bar Chart'.

Then you'll be able to create the exact report you want as you're table is auto-populated.

Cheers

Carl.

DP16 · ‎05-09-2019

Strange as this may sound, I think I figured out the answer to my own question.

In order for the TABLE to appear over in the area where you create reports, you have to change the operation of the table from read, write, delete, etc., TO "REPORT ON." - keep reading.

And here's my table.

Now, I have no clue why my table appeared FOUR times over in the ACL section. But I just wanted to thank Parven for leading me in the right direction.

S_C Pressley · ‎05-10-2019

Good job