SSRS 2008 how to define a custom legend and display colors of legend in table
How would i go about setting the background color in a table to a legend series color in a chart control? Thanks! Jay
October 5th, 2010 10:37pm

Hi Jay, Do you mean you need display the background color in Tablix columns corresponding to the Series color in Chart as the following picture shows? If I have misunderstood, please let me know. By default, Chart in Reporting Services use the built-in color palette to fill each series. To make the Tablix column and Chart Series use same colors, we can first override the default palette by define our own colors on the chart, and then specify the same colors to the Tablix column. Please refer to the detailed steps below: 1. Right click series in the Chart, and select Series Properties in the popup menu. 2. In Series Properties window, select Fill in the left list. 3. Click the fx button after the Color dropdown list. 4. Input an expression for the colors displayed in the series. For example, I specified the express to switch color by field value like: =Switch(Fields!Category.Value="Accessory","Red",Fields!Category.Value="Bike","Blue",Fields!Category.Value="Clothing","Yellow",Fields!Category.Value="Component","Green") You can modify the expression based on your requirement. 5. After that, the Chart Series will display the colors we specified. Then we can specify the same colors to the column in Tablix. Thanks, Tony Chain Tony Chain
Free Windows Admin Tool Kit Click here and download it now
October 8th, 2010 9:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics