[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Crystal report & Chart color

Posted on 2004-08-10
6
Medium Priority
?
919 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:jayarajsp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 11761830
If you're using the version of Crystal that comes with Visual Studio, then there isn't a way to set them.

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
0
 
LVL 42

Expert Comment

by:frodoman
ID: 11761846
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
0
 

Author Comment

by:jayarajsp
ID: 11782065
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
0
 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
ID: 11783690
Sorry...

You can conditionally color based on a value - so you can have all values below 100 be green and all values above 100 be red (for example) but it's only based on the value that you're charting so you can't cycle them the way you're talking about.  At least you can in the standalone version - I'm not even sure that works in the .net version.

Unfortunately I believe you're out of luck unless you buy the standalone version or buy a 3rd party plugin that extends the capabilities of the crystal charting dll's.  If you want to go that route, then look at CRChart ( http://www.threedgraphics.com/tdg/noteworthy/FAQCRChartbyThreeDGraphics.html ) - I've used it and it's pretty good.

frodoman



0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question