Users cannot access data in Excel Spreadsheets created by Excel Builder
Hello,
I have users who can publish ERB reports and see the files, but they are unable to access the data. Currently, they are setup in SQL as DB owners.
Any help is appreciated.
Thank you,
Steve
I have users who can publish ERB reports and see the files, but they are unable to access the data. Currently, they are setup in SQL as DB owners.
Any help is appreciated.
Thank you,
Steve
Answers
Is the user you are referring to their GP user or their Windows user? Their windows user will need to be setup as a db_owner for the specific database that the Excel report is pulling data from. We have some documentation online as far as permissions for excel reports: http://www.eonesolutions.com/Manuals/SmartList-Builder/SmartList%20Builder%202016/?page=toc377550957