{"id":7323,"date":"2014-06-07T02:25:14","date_gmt":"2014-06-07T02:25:14","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/modified-reporting-services-report-rdl-does-not-change-collection-of-common-programming-errors\/"},"modified":"2014-06-07T02:25:14","modified_gmt":"2014-06-07T02:25:14","slug":"modified-reporting-services-report-rdl-does-not-change-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/modified-reporting-services-report-rdl-does-not-change-collection-of-common-programming-errors\/","title":{"rendered":"Modified Reporting Services Report &#8211; RDL does not change?-Collection of common programming errors"},"content":{"rendered":"<p><strong>TL\/DR Version:<\/strong> Reporting Services is <em>not<\/em> giving you the correct RDL.<\/p>\n<p>Your question prompted me to further investigate a suspicion I already had on SSRS for quite some time: <strong>report parameters can behave in unexpected ways for report developers when deploying (or downloading) report definitions<\/strong>. One related scenario I had noted before:<\/p>\n<ol>\n<li>Create a report with parameters.<\/li>\n<li>Deploy the report for the first time.<\/li>\n<li>Update the report parameters in some way.<\/li>\n<li>Deploy the same report once more.<\/li>\n<li><strong>Result:<\/strong> parameter settings are <em>not<\/em> succesfully updated on the server.<\/li>\n<li>Delete the report from the report manager.<\/li>\n<li>Deploy the report once more (effectively the same as step 2).<\/li>\n<li><strong>Result:<\/strong> Report parameters <em>are<\/em> updated correctly.<\/li>\n<\/ol>\n<p>In short, if you want to update parameter settings for deployed reports you&#8217;ll first need to delete it and then deploy it, or update the settings directly via the report manager.<\/p>\n<p>Back to your question(s). You&#8217;re not missing anything, this just seems the way SSRS is behaving (intended or not). The RDL schema has this (abbreviated) piece:<\/p>\n<pre><code>\n    \n        \n            \n        \n        \n        \n        \n        \n        \n        \n        \n        \n    \n    \n\n<\/code><\/pre>\n<p>So, there should be a &#8220;Hidden&#8221; element for your ReportParameter.<\/p>\n<p>I just verified your findings (in SSRS 2008), and think I may have the answer to your second question: <strong>SSRS is indeed <em>not<\/em> coughing up the correct version of the RDL<\/strong>. It&#8217;s missing various bits about the parameters, including the element on being hidden or not.<\/p>\n<p>Funny thing is: if you change the report in BIDS and set the parameter to hidden, the RDL <em>will<\/em> be changed and have the <code>true<\/code> element.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TL\/DR Version: Reporting Services is not giving you the correct RDL. Your question prompted me to further investigate a suspicion I already had on SSRS for quite some time: report parameters can behave in unexpected ways for report developers when deploying (or downloading) report definitions. One related scenario I had noted before: Create a report [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7323","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=7323"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7323\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=7323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=7323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=7323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}