This error message will occur when a Crystal report is run which has had a a bespoke table or view added to it where the table or view has not been granted the necessary level of permissions to allow the end user to access it.
Please be aware to implement this fix will require an Administrator with SQL skills and access to the SQL server.
Open SQL Management studio and browse to the specific database
Browse to find the view or table reported on the error message
Right Click on the view or table and select Properties, Permissions, Search
Enter ASC_SUPPLY then select Check Names, followed by OK
You should get ASC_SUPPLY_CHAIN_R returned
Tick the box to the left of it then select OK
You will then get a row highlighted on the right with ASC_SUPPLY_CHAIN_R in it.
Tick the Grant column on the Select Row
Then OK.
This will grant Select permissions on the view for anyone in the ASC_SUPPLY_CHAIN_R database role , which will apply to all the users.
NB. If if any new bespoke views or tables are created on the database subsequently this process will be required to grant the required permissions to allow them to be used on any Crystal reports.