Is there a way to programmatically override a formula used in a report?

[inthegroove]

I want to programmatically change the color to Black when printing (FieldObject, TextObject).
I've found a way, but it's not perfect.

My Code here..
List<FieldObject> fldobjitems = rd.ReportDefinition.ReportObjects.OfType<FieldObject>().ToList();
foreach (FieldObject fldobj in fldobjitems)
{
if (fldobj.Color != System.Drawing.Color.Black) fldobj.Color = System.Drawing.Color.Black;
}
.
.
.

Formulas for Color are defined in some fields, but they are not changed.

select CurrentFieldValue
case "-":
RGB(0,0,0)
default:
RGB(255,0,0)

Is there any workaround?
thanks.

[ido_millet · Accepted solution]

You need to change the expression -- not the property value.
That is possible to do, but it is easier to simply use a parameter to control the expression and simply feed a value into that parameter.

[inthegroove · Accepted solution]

There are report files that are already in use,
but there is a case where a customer requests all text colors to be black, so I am looking for a way to solve it programmatically.
I've found some workarounds, but it seems that fields with 'Format Field -> Font -> Color - Formula' cannot be changed programmatically.
Still looking for a way.

Thank you for your reply.

[ido_millet · Accepted solution]

At least with the .NET runtime I know from direct experience that it is possible to change that expression.
But it is simpler to add a parameter to the report.

You should be able to add an optional parameter to existing reports. Instruct the user to ignore that parameter.

[inthegroove · Accepted solution]

I think the best way is to use the method and parameters I found appropriately.

thank you

[DonWilliams]

If you are using .NET then go here:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

See my test app:

how-to-parameters-in-crystal-reports-for-visual-studio-net

It has a drop down listbox that will get the formula, use it by cloning the object and then you can make changes to it.

Other than that as Ido suggested it may be simpler to just update their report

[inthegroove]

thanks for your reply.