Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2015 advanced find view RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    When using advanced find views with fiscal year parameters and exporting to excel as a dynamic worksheet we are getting an error as follows. Has anyone come across this error in 2015 on premise? If so is there a fix? Im not keen on granting execute to this function to public.

    The EXECUTE permission was denied on the object 'fn_EndOfThisFiscalYear', database 'COMPANY_MSCRM',schema 'dbo'.

    Thanks Jenn

    Thursday, October 29, 2015 9:10 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you however adding the reporting user group with execute rights on this function did not fix the issue.

    Then the right suggestion is to get in touch with MS Support and ask for a help.

    Dynamics CRM MVP
    My blog

    • Marked as answer by JenniferNHS Tuesday, December 22, 2015 8:41 PM
    Monday, November 2, 2015 10:57 PM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    Recheck this thread - https://social.microsoft.com/forums/en-US/882b1a12-f3c5-45bd-8445-6fe2dbf088c1/export-to-excel-permission-denied-fnendofthisfiscalyear

    Dynamics CRM MVP
    My blog

    Thursday, October 29, 2015 10:04 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you for your response. I did view this post earlier today however I would prefer not to have to give public access to run anything on the server. This seems to have happened after our upgrade from CRM 2011 to crm 2015 and as the administrator I can complete the function just fine but as a sales user they can not. There must be a security issue somewhere but I am unsure of the proper change to make to correct this.
    Friday, October 30, 2015 2:43 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Recheck second reply that is marked as an answer.

    Dynamics CRM MVP
    My blog

    Saturday, October 31, 2015 1:16 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you however adding the reporting user group with execute rights on this function did not fix the issue.
    Monday, November 2, 2015 10:50 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you however adding the reporting user group with execute rights on this function did not fix the issue.

    Then the right suggestion is to get in touch with MS Support and ask for a help.

    Dynamics CRM MVP
    My blog

    • Marked as answer by JenniferNHS Tuesday, December 22, 2015 8:41 PM
    Monday, November 2, 2015 10:57 PM
    Moderator