Filling a cell with color depending upon value

kumaresh

Hi

Have a look at the picture that i have attached. The report am currently working on has a requirement like this. If the value is 98%, the cell has to be filled up to 98 % of its width by a color upon a cell whose background is with another specific color. And in this, the value, here, 98%, should always be displayed right aligned.

I have attached a report. The approach I have followed is, I have used a dynamic text element to fill up with with the color by specifying the corresponding value as its cell width. In this approach, am not able to get the value (say, 98%) to appear on the right side of the bar.

Whether the bar is half filled or fully filled, the value should appear only in the right hand side. For this purpose only, I have used two dynamic text elements.

Also, the report is needed in PDF format too. While exporting the report as PDF, i observed few changes. i.e., i fixed the height of the dynamic text equal to that of the cell that holds the dynamic text. While running in Web Viewer, the dynamic text appears correctly. But while running in PDF, only half the height of the dynamic text is filled with the color specified.

Can anyone suggest me with ideas to crack this?
Also if there are anyother approaches to do this, request the members to share those with me.

PS - I tried using a chart. Right aligning the labels option was not available in it. Also this bar comes along in a table (in a column) in the report am working on.

JasonW

Take a look at the modified attached example.

Jason