jayarajsp
asked on
Crystal report & Chart color
Hi All,
I am developing an application in Crystal report with ASP. Here I am
creating graphs(gantt chart) in Crystal report
and calling it in ASP through the report designer component.
My problem is, I am unable to make the graph with custom colors. Is there
any way to specify the graph content color using some conditions or formula?
Or is it possible to set the chart color programatically?
Please help me,
its urgent..
ThanX
Jayaraj S
I am developing an application in Crystal report with ASP. Here I am
creating graphs(gantt chart) in Crystal report
and calling it in ASP through the report designer component.
My problem is, I am unable to make the graph with custom colors. Is there
any way to specify the graph content color using some conditions or formula?
Or is it possible to set the chart color programatically?
Please help me,
its urgent..
ThanX
Jayaraj S
By the way I didn't directly answer, but it isn't possible to set the colors through RDC - it can only be done in the designer. http://support.businessobjects.com/library/kbase/articles/c2014923.asp
frodoman
frodoman
ASKER
Hi frodoman,
You r correct. I think there is no way to generate the color dynamically. I am using crystal report version 10.0. There in the chart color format designer window, we can specify the graph content color. But what I required is to specify the same dynamically...using some conditions.
Because in my gantt chart, I want more than one bars have the same color and next set of bars have another color as they belongs to same group.
If I specify the color through the designer window, it wouldn't update the color of the newly added group data in the data base..(because we r specifying a particular color for a group). Then we have to specify a new color manually through the report designer window for that group, thats the problem... Also the database contains thousands of group means we need to specify thousands of colors in the designer window....that is not practical I think...
So what I am searching is a way to specify the colors (can be three colors, so if we have more than three groups, the fourth group will take the first group's color) dynamically so that each alertnative group will have different color always.
(cycles through these three colors). Is there any way to do this.... please help me...
Thanks & Regards
Jayaraj S
You r correct. I think there is no way to generate the color dynamically. I am using crystal report version 10.0. There in the chart color format designer window, we can specify the graph content color. But what I required is to specify the same dynamically...using some conditions.
Because in my gantt chart, I want more than one bars have the same color and next set of bars have another color as they belongs to same group.
If I specify the color through the designer window, it wouldn't update the color of the newly added group data in the data base..(because we r specifying a particular color for a group). Then we have to specify a new color manually through the report designer window for that group, thats the problem... Also the database contains thousands of group means we need to specify thousands of colors in the designer window....that is not practical I think...
So what I am searching is a way to specify the colors (can be three colors, so if we have more than three groups, the fourth group will take the first group's color) dynamically so that each alertnative group will have different color always.
(cycles through these three colors). Is there any way to do this.... please help me...
Thanks & Regards
Jayaraj S
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you're using a standalone version of Crystal then you can do it through the designer by rt-clicking on the section and selecting Format -> Select Item and then specify the color desired.
HTH
frodoman