Color Highlights does not work for chart

[Former Member]

When I set the color coding in the chart, it works fine if I run the crystal report on the same DB that I use to design the report.

Problem occurs if I run the report on another DB. Color Highlights does not work in that case.

I am using JRC to run the reports.

Thanks & Regards,

Amrita

[former_member11696]

Please re-post if this is still an issue to the Java Development - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly

[Former Member]

Morning Amrita,

Did you set a formula or used a chart expert for colour coding? Perhaps when the values changes over a newer database crystal loses it's colour coding.

Additionally if you change the db, please make sure you click on Verify Database and also make sure it's Set Datasource is pointing to the right DB tables.

Regards

Jehanzeb

[Former Member]

Hi Jehanzeb,

Thanks for your response.

I am using chart expert for the color coding.

There is no problem in database connection.

Regards,

Amrita

[Former Member]

Could you please explain how you are doing the colour coding? and how you are using the same chart with another database?

I have just done the same by creating a chart --->Format Series Riser, changed the colour and then changed the database field from another database and the chart colour stayed the same (in my case grey and yellow).

Regards

Jehanzeb

[Former Member]

Hi Jehanzeb,

In chart expert there is a tab "Color Highlightsu201D. In this tab one can specify the condition based coloring.

In my case I want to show "RED" color for Unauthorized events andu201D GREEN" color for Authorized Events.

While creating a report suppose I am using a database server "DB-A".I set the color highlights in the chart as I explained. Please be noted that when we click on the color highlights tab it asks for the database login.

To view the report we have our own server and we are using JRC APIs.

Hence I map my report with server and try to view the Report. My Server is connected with database "DB-B" which is different from the database I used to create the report.

This time color Highlight I have specified while creating the report does not work.

I have tried using the "Format Series Riser" option. But the problem with this is that, it does not color the chart conditionally.

I mean if I give GREEN for Authorized and RED for Unauthorized. It gives the green color either to Authorized or Unauthorized which so ever occur first in the chart.

For example:-suppose there is no Authorized Event on date 15-Jan-2009 and I select the date range starting from 15-Jan.In this case Unauthorized event is the first to print on the chart hence this event get the green color though I expect this events to be in RED color.

Regards,

Amrita