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?
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?