Crystal V.10
XML Data using ADO.Net driver
I have a difficult chart coloring requirement to satisfy. I'm wondering if anyone can think of a workaround.
Assume:
1. Pie Chart Report
2. Segments show Asset Values grouped by "Asset Class".
3. Pie Segment Example: Global Equity--$124,000.
3. Asset Class is defined by a formula. Asset Class is a dynamic variable in the system. They can be created by user settings. The values cannot be known at design time.
4. Asset Values are defined by a formula.
Objective:
Asset Class is not known at design time. Set color to Asset Class Position instead--example Position 1, Position 2, etc. Position # refers to place on the User Input screen and is known at design time.
Problem:
1. Color Format Expert won't work because Asset Class Position is only available if I use is as the "On Change Of..." setting on the Chart Expert/Data tabl setting. This results in the segments being labeled by Position instead of Class Name. I can't assign aliases because I don't know what they are at design time.
2. Color can be assigned to the "position" on the chart by clicking a segment then using "Selected Item..." to set the color. This doesn't work for my situation because I need color set by Asset Class Position and this strategy attaches colors in the order that I define them on the chart.
Many thanks--Eric
XML Data using ADO.Net driver
I have a difficult chart coloring requirement to satisfy. I'm wondering if anyone can think of a workaround.
Assume:
1. Pie Chart Report
2. Segments show Asset Values grouped by "Asset Class".
3. Pie Segment Example: Global Equity--$124,000.
3. Asset Class is defined by a formula. Asset Class is a dynamic variable in the system. They can be created by user settings. The values cannot be known at design time.
4. Asset Values are defined by a formula.
Objective:
Asset Class is not known at design time. Set color to Asset Class Position instead--example Position 1, Position 2, etc. Position # refers to place on the User Input screen and is known at design time.
Problem:
1. Color Format Expert won't work because Asset Class Position is only available if I use is as the "On Change Of..." setting on the Chart Expert/Data tabl setting. This results in the segments being labeled by Position instead of Class Name. I can't assign aliases because I don't know what they are at design time.
2. Color can be assigned to the "position" on the chart by clicking a segment then using "Selected Item..." to set the color. This doesn't work for my situation because I need color set by Asset Class Position and this strategy attaches colors in the order that I define them on the chart.
Many thanks--Eric