I want to implement a red/green circle in a table which size would be dependent on percentage - for example +100 would be big green circle, -10 would be small red circle.What would be the best way to do it? I tried with scatter graph but can't persuade graph to stay in the middle. I almost succeeded with pie chart and adjusting chartarea size dinamically through CustomPosition property (this works, but i get some strange code error and cant access chart area after that, though report works anyway.Any other ideas? The simpler the better.I am using SQL 2008.Thanks!

Hi Ivan,We do not have exactly what you want, but have you taken a look at the Gauge control? It allows for what you could call "cool" visualizations similar to what you are looking for.Brad Syputa, Microsoft Reporting Services This posting is provided "AS IS" with no warranties.

Create 10same sizeimageshaving cicles of different size inside. Put image into celland write expression which would return image name depending on value range.Other way to do this. Is to create images in form of BLOBS in DB. And use that table in dataset SQL query according to your rules.

I am trying to avoid the solution with different images (but will use it if i don't find anything better).I'll take anotherlook at gauge.Thanx!

As alternative you can try to use some of chars from system symbol font and again write expressions for font size and color depending on value. This is not implemented in Gauge so far.

Hi Ivan, Perhaps try the following (if you still need it): 1 - use a single image of a "green circle". 2 - place a Rectangle component in your Table Cell. 3 - place in an Image field on the Rectangle. 4 - set the Image field to use your circle image. 5 - set the property for Image->Sizing to "Fit" (or "Fit to Size" via the dialog). ... now the tricky part 6 - depending on your measure (+100 or -10 etc)... use the expressions to assign values to the Image field properties: Left & Top and Width & Height. This should allow you to dictate the size of the image based on your measures... obviously the image maintains the same colour unless you use another "red circle" image. Cheers.