{"id":1553,"date":"2022-07-01T11:24:23","date_gmt":"2022-07-01T09:24:23","guid":{"rendered":"https:\/\/expert-only.com\/?p=1553"},"modified":"2022-07-01T16:07:21","modified_gmt":"2022-07-01T14:07:21","slug":"erreur-ssrs-system-formatexception","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/","title":{"rendered":"Erreur SSRS System.FormatException"},"content":{"rendered":"\n

Le message d’erreur SSRS System.FormatException appara\u00eet durant l’\u00e9dition d’un rapport SSRS. Rapport qui contient entre autres un graphique. Le logiciel Visual Studio crash syst\u00e9matiquement ensuite et affiche l’erreur. Le rapport comporte des \u00e9l\u00e9ments comme le Tablix SSRS et \u00e9diter le graphique provoque le crash de Visual Studio.<\/p>\n\n\n\n

La configuration logicielle est la suivante, Visual Studio 2019 est install\u00e9 avec SQL Server Data Tools en compl\u00e9ment.<\/p>\n\n\n\n

Comment \u00e9viter l’erreur SSRS System.FormatException avec Visual Studio?<\/h2>\n\n\n\n

Voici quelques lignes contenues dans le message d’erreur exact :<\/p>\n\n\n\n

Problem signature:
Signature 04: Microsoft.ReportingServices.Designer.Controls
Problem Signature 09: System.FormatException<\/p>\n\n\n\n

Solution en trois \u00e9tapes pour r\u00e9soudre l’erreur SSRS System Format Exception<\/h3>\n\n\n\n

En effet, les trois \u00e9tapes suivantes permettent de r\u00e9soudre le probl\u00e8me simplement. Il faut compl\u00e8tement r\u00e9installer l’outil car l’installation semble \u00eatre corrompue.<\/p>\n\n\n\n

  1. D\u00e9sinstaller compl\u00e8tement SQL Server Data Tools<\/strong> (SSDT) pour Visual Studio 2019. Pour cela, depuis le menu \u00ab\u00a0D\u00e9sinstaller ou changer un programme\u00a0\u00bb de Windows.<\/li>
  2. Fermer<\/strong> toutes les applications et red\u00e9marrer le PC<\/strong>.<\/li>
  3. R\u00e9installer SSDT<\/strong>, les fichiers d’installation sont disponibles en suivant le lien en bas de cet article.<\/li><\/ol>\n\n\n\n

    Le lien suivant contient les liens pour les deux types d’installation pour la version 2015 : <\/p>\n\n\n\n

    T\u00e9l\u00e9charger SQL Server Data Tools pour Visual Studio 2015<\/a><\/strong><\/p>\n\n\n\n

    La premi\u00e8re est une installation l\u00e9g\u00e8re au d\u00e9part (environ 1 Mo), qui t\u00e9l\u00e9charge les fichiers n\u00e9cessaires pendant l’installation.<\/p>\n\n\n\n

    Enfin, la deuxi\u00e8me installation est de type ind\u00e9pendante (Stand-Alone en Anglais). Elle est donc contenue dans un fichier ISO avec tous les fichiers n\u00e9cessaires, sa taille est d’environ 1 Go.<\/p>\n\n\n\n

    Ce lien officiel sur le site de Microsoft contient les liens pour les derni\u00e8res version en date, soit Visual Studio 2022 et Visual Studio 2019 : <\/p>\n\n\n\n

    T\u00e9l\u00e9charger SQL Server Data Tools pour Visual Studio 2022 et 2019<\/a><\/strong><\/p>\n\n\n\n

    Cet article explique comment r\u00e9soudre le probl\u00e8me li\u00e9 \u00e0 l’erreur SSRS System.FormatException avec Visual Studio 2019.<\/p>\n\n\n\n

    Une autre erreur li\u00e9e aux bugs Visual Studio est l’erreur SSRS Undocumented Error<\/a><\/strong>.<\/p>\n\n\n\n

    Pour aller plus loin sur Reporting Services, voici comment utiliser du SQL dynamique dans les datasets SSRS<\/a><\/strong>.<\/p>\n\n\n\n

    \nhttps:\/\/expert-only.com\/ssrs\/requete-sql-dynamique-dans-un-dataset-ssrs\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"

    Le message d’erreur SSRS System.FormatException appara\u00eet durant l’\u00e9dition d’un rapport SSRS. Rapport qui contient entre autres un graphique. Le logiciel Visual Studio crash syst\u00e9matiquement ensuite et affiche l’erreur. Le rapport comporte des \u00e9l\u00e9ments comme le Tablix SSRS et \u00e9diter …<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[170,566,565,567,229],"class_list":{"0":"post-1553","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-ssrs","7":"tag-rapport","8":"tag-reporting","9":"tag-ssdt","10":"tag-tablix","11":"tag-visual-studio"},"yoast_head":"\nErreur SSRS System.FormatException - Reporting Services<\/title>\n<meta name=\"description\" content=\"Suivre les \u00e9tapes de cet article pour corriger l'erreur SSRS System.FormatException qui provoque le crash de visual studio et SSDT.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Erreur SSRS System.FormatException\" \/>\n<meta property=\"og:description\" content=\"Suivre les \u00e9tapes de cet article pour corriger l'erreur SSRS System.FormatException qui provoque le crash de visual studio et SSDT.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-01T09:24:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-01T14:07:21+00:00\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Erreur SSRS System.FormatException\",\"datePublished\":\"2022-07-01T09:24:23+00:00\",\"dateModified\":\"2022-07-01T14:07:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/\"},\"wordCount\":373,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"keywords\":[\"rapport\",\"Reporting\",\"SSDT\",\"Tablix\",\"Visual Studio\"],\"articleSection\":[\"SSRS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/\",\"name\":\"Erreur SSRS System.FormatException - Reporting Services\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"datePublished\":\"2022-07-01T09:24:23+00:00\",\"dateModified\":\"2022-07-01T14:07:21+00:00\",\"description\":\"Suivre les \u00e9tapes de cet article pour corriger l'erreur SSRS System.FormatException qui provoque le crash de visual studio et SSDT.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Erreur SSRS System.FormatException\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Erreur SSRS System.FormatException - Reporting Services","description":"Suivre les \u00e9tapes de cet article pour corriger l'erreur SSRS System.FormatException qui provoque le crash de visual studio et SSDT.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/","og_locale":"fr_FR","og_type":"article","og_title":"Erreur SSRS System.FormatException","og_description":"Suivre les \u00e9tapes de cet article pour corriger l'erreur SSRS System.FormatException qui provoque le crash de visual studio et SSDT.","og_url":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-07-01T09:24:23+00:00","article_modified_time":"2022-07-01T14:07:21+00:00","author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Erreur SSRS System.FormatException","datePublished":"2022-07-01T09:24:23+00:00","dateModified":"2022-07-01T14:07:21+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/"},"wordCount":373,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"keywords":["rapport","Reporting","SSDT","Tablix","Visual Studio"],"articleSection":["SSRS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/","url":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/","name":"Erreur SSRS System.FormatException - Reporting Services","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"datePublished":"2022-07-01T09:24:23+00:00","dateModified":"2022-07-01T14:07:21+00:00","description":"Suivre les \u00e9tapes de cet article pour corriger l'erreur SSRS System.FormatException qui provoque le crash de visual studio et SSDT.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssrs\/erreur-ssrs-system-formatexception\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Erreur SSRS System.FormatException"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1553"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1553\/revisions"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}