Images on SSRS bar chart
Hi, Thanks for looking into this thread. Using SSRS 2012 - Requirement is to display Upward / Downward arrows (images) next to the bar. Means, wherever the bar ends, just after it, need to display upwards / downward arrow, based on any data calculation. Couldnt use image from toolbox directly on the chart area. Hence, tried to use Background image property in chart series but unable to display the image as expected. Please share a solution. Thanks ! Niraj
May 13th, 2012 1:25pm

Hi Niraj, From your description, you want the Bar chart to display upward/downward narrow next to the end of each bar. Based on your scenario, there are two workarounds for your reference: Workaround 1: Add Marker to the Bar Chart Click on the bars in the chart, the Chart Series appear in the Properties pane.Under the Appearance tab, expand the Marker option.Select Triangle in the drop-down list of Marker Type and reset the Size property. Besides, you can control the marker type or marker color based on an expression based on your requirement. Currently, it is not supported to use an image as the marker. For example, I set the marker color by using the expression =iif(Sum(Fields!SalesAmount.Value)>4000000,"Red", "Aqua"). The report looks like: Workaround 2: Add Image to the Bar Chart Series Click on the bars in the chart, the Chart Series appear in the Properties pane.Under the Appearance tab, expand the Marker and expand Image.Then you can customize the image MIME Type, Source, Value and so on. However, the Position property is not applied to Bar Chart. For example, there are two embedded .png images in the report, and I set the expression of Value expression to =iif(Sum(Fields!SalesAmount.Value)>4000000,"redkpi", "greenkpi"). The report looks like: So, no matter we add the marker or image, there will be overlapping portions. If you have any questions, please feel free to ask. Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 8:56am

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

Other recent topics Other recent topics