Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamically Color Coding Pie Charts

Status
Not open for further replies.

varadha72

Programmer
Oct 14, 2010
82
US
I am using Crystal Reports 2008.
Database Fields-
ID Product Code Amount Color Code
1 pkt1 50 190,127,127
2 pkt2 5 222,169,169
3 pkt3 10 122,30,30
4 pkt4 15 203,135,85
5 pkt5 20 234,221,128

Requirement-
1. Plot a pie chart with “Amount” on change of “ID”.
2. The chart should display the “amount” in a customed color panel. This is provided in the Database (Color Code).
3. The Color code can be edited in the Database by the client, hence this will be a dynamic field.

4. The chart should dynamically pick the color code and plot the Pie Chart using this color code from DB ONLY.
5. Note- The color code cannot be auto-populated or manual entered.

Question: Please let me know how I can Plot a Pie Chart dynamically picking the color code from the Database directly using comma seperated values and not hardcoding them?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top