Was this page helpful?

Reports Internal

    Week period in English week, from Sunday to Saturday !

    The DATEFIRST default value for English logins in SQL SERVER is set to 7 which corresponds to Sunday.

    To use a French week from Monday to Sunday , you have to:

    Run SQL Management Studio

    Check the DATEFIRST (master database):

    reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)

    Set Monday as default DATEFIRST:

    reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)

    Set up French language as default language for NEWTEST_REP account and the server administrator account

    Restart the SQL Server (NEWTEST) service, SQL Server Agent (NEWTEST) and SQL Server Reporting Services (NEWTEST)

    Check that the DATEFIRST is 1

    Run a subscription job through SQL Agent and verify that your report has good data from Monday to Sunday

     

     

    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    1118 view(s), 1 edit(s) and 1320 character(s)

    Comments

    You must login to post a comment.

    Attach file

    Attachments