{"id":15130,"date":"2022-10-10T12:46:02","date_gmt":"2022-10-10T07:16:02","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/"},"modified":"2022-10-10T12:46:02","modified_gmt":"2022-10-10T07:16:02","slug":"solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/","title":{"rendered":"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query&#8230; or can they?"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-54586513\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"54586513\" data-parentid=\"54581864\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>In the query designer drag a dimension on top of your report. Chose an <code>Operator<\/code> and a <code>Filter<\/code> and check the checkbox by <code>Parameters<\/code> and BOOOM you have your parameter. If you go now into your report designer you find the parameter you just checked in the folder <code>Parameters<\/code> on the left navigation pane (on top of the <code>Datasets<\/code> folder). Now open the folder an right click on your parameter for the properties.<\/p>\n<p>You can set now a default value. If not the report opens and waits until a users selects a value from the drop down selection. After the selection the parameter gets passed to the query and the query gets executed and the report rendered.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved In SSRS 2008, how are parameters passed down to the DatSet Query&#8230; or can they? <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] In the query designer drag a dimension on top of your report. Chose an Operator and a Filter and check the checkbox by Parameters and BOOOM you have your parameter. If you go now into your report designer you find the parameter you just checked in the folder Parameters on the left navigation pane &#8230; <a title=\"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query&#8230; or can they?\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/\" aria-label=\"More on [Solved] In SSRS 2008, how are parameters passed down to the DatSet Query&#8230; or can they?\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[1626,500,3930,1627,1630],"class_list":["post-15130","post","type-post","status-publish","format-standard","hentry","category-solved","tag-reporting-services","tag-sql-server","tag-ssrs-2008","tag-ssrs-2008-r2","tag-ssrs-tablix"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query... or can they? - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query... or can they? - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] In the query designer drag a dimension on top of your report. Chose an Operator and a Filter and check the checkbox by Parameters and BOOOM you have your parameter. If you go now into your report designer you find the parameter you just checked in the folder Parameters on the left navigation pane ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-10T07:16:02+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query&#8230; or can they?\",\"datePublished\":\"2022-10-10T07:16:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/\"},\"wordCount\":144,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"reporting-services\",\"sql-server\",\"ssrs-2008\",\"ssrs-2008-r2\",\"ssrs-tablix\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/\",\"name\":\"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query... or can they? - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-10T07:16:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query&#8230; or can they?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query... or can they? - JassWeb","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:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query... or can they? - JassWeb","og_description":"[ad_1] In the query designer drag a dimension on top of your report. Chose an Operator and a Filter and check the checkbox by Parameters and BOOOM you have your parameter. If you go now into your report designer you find the parameter you just checked in the folder Parameters on the left navigation pane ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/","og_site_name":"JassWeb","article_published_time":"2022-10-10T07:16:02+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query&#8230; or can they?","datePublished":"2022-10-10T07:16:02+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/"},"wordCount":144,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["reporting-services","sql-server","ssrs-2008","ssrs-2008-r2","ssrs-tablix"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/","url":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/","name":"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query... or can they? - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-10T07:16:02+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-in-ssrs-2008-how-are-parameters-passed-down-to-the-datset-query-or-can-they\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] In SSRS 2008, how are parameters passed down to the DatSet Query&#8230; or can they?"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=15130"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15130\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=15130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=15130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=15130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}