This error occurs when a Crystal Report is run against a bespoke table or view that has not been granted the necessary permissions for the end user to access it. Granting Select permissions on the table or view to the ASC_SUPPLY_CHAIN_R database role will resolve the issue for all users.
⚠️Important: Implementing this fix requires an administrator with SQL skills and access to the SQL server.
Grant permissions on the table or view
Open SQL Server Management Studio and browse to the specific database.
Browse to find the view or table named in the error message.
Right-click the view or table and select Properties.
Select Permissions, then click Search.
Enter ASC_SUPPLY, then click Check Names, then click OK.
ASC_SUPPLY_CHAIN_R will be returned — tick the checkbox to the left of it, then click OK.
The ASC_SUPPLY_CHAIN_R row will appear highlighted on the right.
Tick the Grant column on the Select row.
Click OK.
This grants Select permissions on the view or table to all users in the ASC_SUPPLY_CHAIN_R database role.
📌Note: If any new bespoke views or tables are added to the database in future, this process will need to be repeated to grant the required permissions before they can be used in Crystal Reports.