Display process bar in cell directly [message #422033] |
Sun, 13 September 2009 22:42 |
juniormy
Messages: 11 Registered: August 2009 Location: US
|
Junior Member |
|
|
Background
For users of report, graphics is much more intuitive than data. As a result, statistical chart is widely used in report. However, sometimes users may want to display the process bar in cell directly to compare data.
Solution
RAQ Report is a free professional Web-based Java reporting tool, and it can help users to make all kinds of complex reports with statistical chart.
At the same time, as RAQ Report is a real Excel-like reporting tool, users can display process bar in cell directly with it. Moreover, users even can make process bar with data in cell.
Example
Design a report like the one below:
A3=&B3
B3= ds1.select(Order ID,true,,ShipVia)
C3= ds1. ShipVia
D3=(C3/C3[`0]{}[1])*100
E3="<table width="+D3[`0]{}[A3]+"% border=0 cellspacing=0 cellpadding=0> <tr> <td bgcolor=#990033><div color=#ffffff align=right>"+C3+"</div></td> </tr> </table>"
Graphic Illustration
For more details you can refer to http://www.raqsoft.com.
|
|
|