Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Develop motivation and a positive attitude. Help yourself - by developing your talents and skills
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

30
January

How Do I Create a Custom Chart Palette in SQL Reporting Services 2008

During a recent SQL Reporting Services 2008 training session, one of the delegates asked how one would create a custom palette, for a chart


Solution

In previous versions of SQL Server Reporting Services, if one wanted to change the colour palette of a chart, one would have to manually write come code to program the colours, and then assign the code to the report.

In SQL Server Reporting Services 2008, Microsoft has added a feature that allows designers to quickly create their own custom colour palettes to report objects easily.

To create a custom palette for a chart:

  1. Create the chart

  2. Select the Chart object

  3. In the Chart Properties, under the Chart Category, change the Palette option to Custom

  4. Find the CustomPaletteColors option



  5. Next to the (Collection) label, press the ellipses (...) button

    This activates the ReportColorExpression Collection Editor:

    SSRS 2008 Custom Chart Palette dialog box

  6. Press the Add button

  7. Press the Color dropdown button to select the required colour:

    Add custom colours to the chart palette

  8. Repeat steps 6 and 7 to complete the color palette:

    Completed SSRS Custom Chart Palette


  9. When the colour palette has been completed press the OK button

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

1

Mohammed Asif Khan

14
February
Hi Thanks for the solution
2

Martin Zutter

17
May
Hello Is there a way to use this configured custom palette in more then one chart? Something like copy the palette. Thanks in advance Martin
3

Julia

18
May
Hi Martin,

Unfortunately this feature is a property of the individual chart rather than of SSRS 2008 itself.

The quickest and easiest way to use the custom chart palette for a number of different chart, is to create the original chart palette, and then copy and paste the chart item and use it as a template item within the report solution.

Julia

MAKE A COMMENT

Name *

Email Address *

Comment *