{"id":1121,"date":"2022-07-04T07:30:44","date_gmt":"2022-07-04T05:30:44","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1121"},"modified":"2022-11-03T17:50:06","modified_gmt":"2022-11-03T16:50:06","slug":"requete-sql-dynamique-avec-ssrs","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/","title":{"rendered":"Requ\u00eate SQL dynamique avec SSRS"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment cr\u00e9er une requ\u00eate SQL dynamique dans un dataset SSRS ?<\/em><\/strong><\/h4>\n\n\n\n<p>Avec SQL Server Reporting Services (SSRS), les champs utilis\u00e9s dans un objet de type tableau sont li\u00e9s \u00e0 la base de donn\u00e9es et donc \u00e0 une requ\u00eate, de pr\u00e9f\u00e9rence dynamique. Mais comment la rendre dynamique ? Gr\u00e2ce \u00e0 un jeu de donn\u00e9es ou dataset qui est lui-m\u00eame le r\u00e9sultat d&rsquo;une requ\u00eate SQL. Ce dataset se rattache \u00e0 une data source ou source de donn\u00e9es. <\/p>\n\n\n\n<p>En effet, cette source de donn\u00e9es contient une connexion. Par exemple \u00e0 une base de donn\u00e9es ou \u00e0 un cube OLAP utilis\u00e9s comme sources. La restitution des donn\u00e9es rend possible la cr\u00e9ation de rapports statiques gr\u00e2ce \u00e0 des requ\u00eates fig\u00e9es. Ou encore des rapports dynamiques avec des requ\u00eates dynamiques.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#1-utiliser-une-requete-sql-dynamique-avec-ssrs\" >1. Utiliser une requ\u00eate SQL dynamique avec SSRS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#2-exemples-de-code-sql-dynamique-avec-reporting-services\" >2. Exemples de code SQL dynamique avec Reporting Services<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#21-premiere-solution-avec-une-requete-sql-et-une-formule\" >2.1 Premi\u00e8re solution avec une requ\u00eate SQL et une formule<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#22-deuxieme-solution-avec-des-conditions-dans-la-requete-sql\" >2.2 Deuxi\u00e8me solution avec des conditions dans la requ\u00eate SQL<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#3-conclusion-sur-les-requetes-dynamiques-ssrs\" >3. Conclusion sur les requ\u00eates dynamiques SSRS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-utiliser-une-requete-sql-dynamique-avec-ssrs\"><span class=\"ez-toc-section\" id=\"1-utiliser-une-requete-sql-dynamique-avec-ssrs\"><\/span>1. Utiliser une requ\u00eate SQL dynamique avec SSRS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Utiliser des filtres pour tirer le meilleur parti des requ\u00eates SQL Server et afficher une s\u00e9lection pertinente des donn\u00e9es. Autrement dit, sans filtre toutes les donn\u00e9es sont affich\u00e9es. Ou alors les donn\u00e9es sont restreintes par exemple via la date du jour, du mois ou le trimestre en cours.<\/p>\n\n\n\n<p>Les filtres permettent \u00e0 l\u2019utilisateur de s\u00e9lectionner une ann\u00e9e, un produit ou un client particulier. Il est recommand\u00e9 d&rsquo;impl\u00e9menter un maximum de fonctions dynamiques dans les rapports SSRS. En plus de cela, l&rsquo;utilisation conjointe de plusieurs param\u00e8tres permet d&rsquo;affiner la s\u00e9lection des donn\u00e9es.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-exemples-de-code-sql-dynamique-avec-reporting-services\"><\/span>2. Exemples de code SQL dynamique avec Reporting Services<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/reporting-services\/create-deploy-and-manage-mobile-and-paginated-reports?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener noreferrer\">Reporting Services<\/a> est l&rsquo;outil de Reporting et de Tableaux de bord de la suite Microsoft BI. Il est d&rsquo;ailleurs compl\u00e8tement Responsive depuis la version SQL Server 2016.&nbsp;C&rsquo;est \u00e0 dire que les rapports s&rsquo;adaptent parfaitement aux diff\u00e9rents formats d&rsquo;\u00e9crans. C&rsquo;est \u00e0 dire : \u00e9crans de bureaux (desktop), ordinateurs portables (laptops), aux tablettes et aux smartphones. Il existe plusieurs approches pour g\u00e9rer les filtres, voici deux options simples.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21-premiere-solution-avec-une-requete-sql-et-une-formule\"><\/span>2.1 Premi\u00e8re solution avec une requ\u00eate SQL et une formule<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La solution la plus facile \u00e0 maintenir est la suivante, avec un champ CITY pour s\u00e9lectionner la ville. Au pr\u00e9alable, le syst\u00e8me \u00e9value le param\u00e8tre PARAMETERS!PARAMETER2.VALUE en fonction d&rsquo;un premier param\u00e8tre visible. Param\u00e8tre s\u00e9lectionn\u00e9 depuis une liste de choix par l&rsquo;utilisateur, \u00e0 l&rsquo;ex\u00e9cution du rapport.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT \t*\nFROM \tTABLE1\nWHERE \tCITY = PARAMETERS!PARAMETER2.VALUE<\/pre>\n\n\n\n<p>Pour ce faire, dans les propri\u00e9t\u00e9s <strong>Expression <\/strong>du param\u00e8tre PARAMETER2, ins\u00e9rer un code avec une fonction fonctionnelle, comme celui-ci:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">=IIF(Parameters!Test.value = \"Valeur\",\"CONDITION1\", \"CONDITION2\")<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"22-deuxieme-solution-avec-des-conditions-dans-la-requete-sql\"><\/span>2.2 Deuxi\u00e8me solution avec des conditions dans la requ\u00eate SQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Voici la deuxi\u00e8me solution qui est d&rsquo;\u00e9crire en dur les deux param\u00e8tres dans l&rsquo;expression de la requ\u00eate. Elle est moins \u00e9l\u00e9gante et plus complexe \u00e0 d\u00e9velopper avec plusieurs filtres : <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">IF PARAMETERS!PARAMETER.VALUE = UNEVALEUR\nSELECT * FROM TABLE1 WHERE CHAMPS = CONDITION1\nELSE\nSELECT * FROM TABLE1 WHERE CHAMPS = CONDITION2<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-conclusion-sur-les-requetes-dynamiques-ssrs\"><\/span>3. Conclusion sur les requ\u00eates dynamiques SSRS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ce tutoriel SSRS pr\u00e9sente 2 options pour cr\u00e9er une requ\u00eate SQL dynamique dans un dataset. Il est donc pr\u00e9f\u00e9rable d\u2019utiliser la premi\u00e8re solution pour pouvoir centraliser le code dynamique directement dans les expressions et les r\u00e9utiliser dans plusieurs requ\u00eates. Pour aller plus loin, voici comment <a href=\"https:\/\/expert-only.com\/ssrs\/deployer-un-rapport-ssrs-avec-visual-studio\/\">d\u00e9ployer un rapport SSRS depuis Visual Studio<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"ZV1mYa4mLu\"><a href=\"https:\/\/expert-only.com\/fr\/ssrs\/deployer-un-rapport-ssrs-avec-visual-studio\/\">D\u00e9ployer un rapport SSRS avec Visual Studio<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0D\u00e9ployer un rapport SSRS avec Visual Studio\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssrs\/deployer-un-rapport-ssrs-avec-visual-studio\/embed\/#?secret=dcJcdCioN4#?secret=ZV1mYa4mLu\" data-secret=\"ZV1mYa4mLu\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment cr\u00e9er une requ\u00eate SQL dynamique dans un dataset SSRS ? Avec SQL Server Reporting Services (SSRS), les champs utilis\u00e9s dans un objet de type tableau sont li\u00e9s \u00e0 la base de donn\u00e9es et donc \u00e0 une requ\u00eate, de <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/\" title=\"Requ\u00eate SQL dynamique avec SSRS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10627,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":{"0":"post-1121","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssrs"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Requ\u00eate SQL dynamique avec SSRS - Reporting Services<\/title>\n<meta name=\"description\" content=\"Pour cr\u00e9er une requ\u00eate SQL dynamique dans un dataset SSRS, utiliser cet exemple de script \u00e9valu\u00e9 \u00e0 l&#039;ex\u00e9cution du rapport Reporting Services.\" \/>\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\/requete-sql-dynamique-avec-ssrs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Requ\u00eate SQL dynamique avec SSRS\" \/>\n<meta property=\"og:description\" content=\"Pour cr\u00e9er une requ\u00eate SQL dynamique dans un dataset SSRS, utiliser cet exemple de script \u00e9valu\u00e9 \u00e0 l&#039;ex\u00e9cution du rapport Reporting Services.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/\" \/>\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-04T05:30:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-03T16:50:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"3 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\/requete-sql-dynamique-avec-ssrs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Requ\u00eate SQL dynamique avec SSRS\",\"datePublished\":\"2022-07-04T05:30:44+00:00\",\"dateModified\":\"2022-11-03T16:50:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/\"},\"wordCount\":549,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg\",\"articleSection\":[\"SSRS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/\",\"name\":\"Requ\u00eate SQL dynamique avec SSRS - Reporting Services\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg\",\"datePublished\":\"2022-07-04T05:30:44+00:00\",\"dateModified\":\"2022-11-03T16:50:06+00:00\",\"description\":\"Pour cr\u00e9er une requ\u00eate SQL dynamique dans un dataset SSRS, utiliser cet exemple de script \u00e9valu\u00e9 \u00e0 l'ex\u00e9cution du rapport Reporting Services.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Requ\u00eate SQL dynamique avec SSRS\"}]},{\"@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":"Requ\u00eate SQL dynamique avec SSRS - Reporting Services","description":"Pour cr\u00e9er une requ\u00eate SQL dynamique dans un dataset SSRS, utiliser cet exemple de script \u00e9valu\u00e9 \u00e0 l'ex\u00e9cution du rapport Reporting Services.","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\/requete-sql-dynamique-avec-ssrs\/","og_locale":"fr_FR","og_type":"article","og_title":"Requ\u00eate SQL dynamique avec SSRS","og_description":"Pour cr\u00e9er une requ\u00eate SQL dynamique dans un dataset SSRS, utiliser cet exemple de script \u00e9valu\u00e9 \u00e0 l'ex\u00e9cution du rapport Reporting Services.","og_url":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-07-04T05:30:44+00:00","article_modified_time":"2022-11-03T16:50:06+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg","type":"image\/jpeg"}],"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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Requ\u00eate SQL dynamique avec SSRS","datePublished":"2022-07-04T05:30:44+00:00","dateModified":"2022-11-03T16:50:06+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/"},"wordCount":549,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg","articleSection":["SSRS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/","url":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/","name":"Requ\u00eate SQL dynamique avec SSRS - Reporting Services","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg","datePublished":"2022-07-04T05:30:44+00:00","dateModified":"2022-11-03T16:50:06+00:00","description":"Pour cr\u00e9er une requ\u00eate SQL dynamique dans un dataset SSRS, utiliser cet exemple de script \u00e9valu\u00e9 \u00e0 l'ex\u00e9cution du rapport Reporting Services.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/earth-A051C64B9CD_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssrs\/requete-sql-dynamique-avec-ssrs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Requ\u00eate SQL dynamique avec SSRS"}]},{"@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\/1121","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=1121"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1121\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10627"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}