Skip to main content
Question

User role unable to see report: "The report is unavailable, because a field for sorting can't be shown."

  • December 21, 2022
  • 0 replies
  • 196 views

MattMakris
Forum|alt.badge.img+7
I have a role that has access to only one table. When logged-in as this role, I'm getting this error when accessing this table:

"The report is unavailable, because a field for sorting can't be shown."

I have given field-level access to every field in every column as well as every sorting field and still get the same result. Does the role also need access to tables referenced in relationship fields?


------------------------------
Matt Makris
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Yes, the Role will indeed need access to the other tables referenced in the report sort or columns which you want to to show.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------