{"id":1114,"date":"2015-03-10T19:13:05","date_gmt":"2015-03-11T01:13:05","guid":{"rendered":"https:\/\/clarkcreations.net\/blog\/?p=1114"},"modified":"2015-03-11T12:58:00","modified_gmt":"2015-03-11T18:58:00","slug":"5-simple-things-i-always-forget-about-ssrs-custom-color-palette","status":"publish","type":"post","link":"https:\/\/clarkcreations.net\/blog\/5-simple-things-i-always-forget-about-ssrs-custom-color-palette\/","title":{"rendered":"5 Simple things I always forget about SSRS – Custom Color Palette"},"content":{"rendered":"

There are spells where I am inside SSRS daily and then there are some stretches of time where I wrapped up doing other things and don\u2019t see SSRS for months on end. I always seem \u201csurprised\u201d when I forget some of SSRS\u2019s behaviors. I am sure sometimes I am just pushing the bad out of my head and other times it might be that I just don\u2019t use it often enough to keep that info close to the top of my stack. So I decided that I should start a small blog series as a gentle reminder to myself and maybe along the way it will help someone else.<\/p>\n

Custom Color Palette<\/h2>\n

I was working on some custom SCSM reports for a client–I was subcontracting from a consulting firm–there was a lack of requirements, especially in the design. I was adding charts and of course the color palettes available are almost hideous. That is when I remembered that I could go create a custom palette of colors to use. I fire up Adobe PhotoShop<\/a>, import a screen shot of the client\u2019s website and use the color picker to identify a set of colors that I want to use. I know that a lot of companies have a defined logo\/color palette but since that wasn\u2019t available this was the next best thing. The best part is this is a simple task but it has a huge impact<\/p>\n

After adding a chart to your report find Chart<\/strong> section the Properties<\/strong> Window. Select the ellipsis after CustomPaletteColors<\/strong>. (image below<\/em>)<\/p>\n

\"custompalette_1\"<\/a><\/p>\n

You\u2019ll get a popup window ChartColor Collection Editor<\/strong>. The left window allows you to mange the order the colors will be used; the right window is how you identify the colors. Select Add<\/strong> to place additional colors. When you pick the the drop down arrow for the color, you are presented options: a set of available colors, More colors<\/strong> and Expression<\/strong>. (image below<\/em>)<\/p>\n

\"custompalette_2\"<\/a><\/p>\n

After selecting More Colors<\/strong> you are given another popup window, Select Color<\/strong>. From here, you have the option to choose which color selector you are going to use, including a standard color list (default).\u00a0 Since I had the colors defined, entering the RGB numbers is the best option. You must click add and define each color you want used in your chart. (image below<\/em>)<\/p>\n

\"custompalette_3\"<\/a><\/p>\n

Now that you have defined a custom color palette you must tell the chart to use it. In the Properties<\/strong> window, under Chart<\/strong> find Palette<\/strong>, from the chooser select Custom<\/strong>. You can see that the chart is automatically updated with the new colors. (image below<\/em>)<\/p>\n

\"custompalette_4\"<\/a><\/p>\n

After you have defined colors for a custom palette they become available for use in other places. In the image below there is a horizontal line; below it are the 2 custom colors that were set up in the above example. This is the fill properties on a text box.\u00a0 This however doesn\u2019t work the other direction, for example if you add a color from the fill properties it doesn\u2019t become available in the CustomPaletteColors<\/strong>. It is available in other choosers like: text box fill, text color and background fill.\u00a0 (image below<\/em>)<\/p>\n

\"CustomPalette_5\"<\/a><\/p>\n

Other random musings. If you delete the chart the custom palette disappears with it. If you know you are going to create multiple reports with charts needing the same custom color palette you could create a blank report with a chart, define the custom palette and save it as a template. You don\u2019t have to set up data sets or sources, just select cancel<\/strong> when that comes up.<\/p>\n","protected":false},"excerpt":{"rendered":"

There are spells where I am inside SSRS daily and then there are some stretches of time where I wrapped up doing other things and don\u2019t see SSRS for months on end. I always seem \u201csurprised\u201d when I forget some of SSRS\u2019s behaviors. I am sure sometimes I am just pushing the bad out of my head and other times it might be that I just don\u2019t use it often enough to keep that info close to the top of my stack. So I decided that I should start a small blog series as a gentle reminder to myself and maybe along the way it will help someone else.<\/p>\n

Custom . . . → Read More: 5 Simple things I always forget about SSRS – Custom Color Palette<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[286,269,270,147,239,149],"tags":[],"class_list":["post-1114","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-how-to","category-instructions","category-sql","category-sql-server","category-ssrs","odd"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/1114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/comments?post=1114"}],"version-history":[{"count":0,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/posts\/1114\/revisions"}],"wp:attachment":[{"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/media?parent=1114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/categories?post=1114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clarkcreations.net\/blog\/wp-json\/wp\/v2\/tags?post=1114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}