Excel Report Builder Report Publishing
Module: SmartList Builder
Why this feature is cool!
In Microsoft Dynamics GP 2010, any user will be able publish Excel Report Builder reports as long as certain criteria are met. The user must be one of the following:
This enables more users than simply ‘sa’ to publish Excel Report Builder reports, empowering users outside of IT to manage this process and extend the reach of information throughout the organization.
What does it look like?
Go to Microsoft Dynamics GP menu, then Tools > SmartList Builder > Excel Report Builder > Excel Report Builder > Publish button
It says I do not have permissions to publish the excel report however I'm a power user.
Are you using the GP 2010 beta release? If so, make sure your user has one of these rights in SQL if you aren't using SA or DYNSA:
Any user in the db_owner database role in SQL
Any user in the SysAdmin fixed server role in SQL
Any user in the dbCreator fixed server role in SQL
This only works in GP 2010, not GP 10.0.
How do you setup security for GP 10 allowing an user to publish a report. The user is able to do everything except publish.
Unfortunately in GP 10, only SA can publish reports. We understand this was too limiting for many, so that is why in GP 2010 we added the feature for non-sa users to be able to publish. This is not a feature available in GP 10 however.
As power-user we are asked to enter the System Password to publish an Excel Report. Is this how it is designed?
Yes. When you create an Excel Report a new SQL Veiw is created. Only administrators can create SQL Views.