![\"\"](\"https:\/\/mkncreations.com\/site\/wp-content\/uploads\/report-properties.png\")
<\/p>\nIf you would like to show and hide certain columns in SSRS here is what you should do.<\/p>\n
1. Hit the “Design” tab of the report.
\n2. Go to “Report” then from the drop down select “Report Properties”<\/p>\n
<\/p>\n
3. Click on “Code” and paste the following:<\/p>\n
”’ summary
\n”’ Return whether the passed column name has been selected
\n”’ in the multi-value parameter, whether it should be visible
\n”’ or not.
\n”’ end of summary
\nPublic Shared Function IsColumnSelected(ByRef objMultiValueParam() As Object, ByVal strColumnName As String) As Boolean<\/p>\n‘ return whether the passed column name is in the multi-value
\n‘ parameter array
\nReturn 0 < InStr(vbNullChar & Join(objMultiValueParam, vbNullChar) & _
\nvbNullChar, vbNullChar & strColumnName & vbNullChar)<\/p>\nEnd Function<\/p><\/blockquote>\n
4. Create a Parameter called “Show Columns” with the following Query:<\/p>\n
SELECT ‘Column1’ AS [Label]
\n, 1 AS [Value]<\/p>\nUNION<\/p>\n
SELECT ‘Column2’ AS [Label]
\n, 2 AS [Value]<\/p>\nUNION<\/p>\n
SELECT ‘Column3’ AS [Label]
\n, 3 AS [Value]<\/p>\nUNION<\/p>\n
SELECT ‘Column4’ AS [Label]
\n, 4 AS [Value]<\/p><\/blockquote>\nColumn1, Column2 etc. should be the names of your columns.<\/p>\n
5. Under each column select the “Column Visibility…” and paste this expression.<\/p>\n
=Not Code.IsColumnSelected(Parameters!ShowColumns.Value, “1”)<\/p><\/blockquote>\n
The expression example above is for Column1. For Column2 you will change it to this:<\/p>\n
=Not Code.IsColumnSelected(Parameters!ShowColumns.Value, “2”<\/strong><\/span>)<\/p><\/blockquote>\n
So in short you have to 1st map the Columns with numbers that represent them and then in the expression for the column visibility to use the corresponding numbers (values).<\/p>\n","protected":false},"excerpt":{"rendered":"
If you would like to show and hide certain columns in SSRS here is what you should do. 1. Hit the “Design” tab of the…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,11],"tags":[138,137,79,21,82,81,136,50,78,38,49,135],"class_list":["post-526","post","type-post","status-publish","format-standard","hentry","category-how_to","category-ssrs","tag-columns","tag-hide","tag-microsoft","tag-ms","tag-multiselect","tag-parameter","tag-show","tag-sql-2","tag-sql2008","tag-ssrs-2","tag-tsql","tag-visibility"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/526"}],"collection":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/comments?post=526"}],"version-history":[{"count":3,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/526\/revisions"}],"predecessor-version":[{"id":1010776,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/526\/revisions\/1010776"}],"wp:attachment":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/media?parent=526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/categories?post=526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/tags?post=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}