Skip to Content
0
Former Member
May 18, 2010 at 11:36 AM

how to use Conditional formula - to change the fontcolor at runtime

36 Views

Hi,

i am using Crystal Report XI Server to built reports on the fly.

here i am trying to change the forntcolor based on the value of the formulafiled "{@Ans1}".

CODE:

foreach (CrystalDecisions.ReportAppServer.ReportDefModel.ReportObject repObj in rcDoc.ReportDefinition.DetailArea.Sections[0].ReportObjects)

{

string sZName = repObj.Name;

if (sZName == "Ans11")

{

CrystalDecisions.ReportAppServer.ReportDefModel.ReportObject fldrptobj;

CrystalDecisions.ReportAppServer.ReportDefModel.ISCRFieldObject fldobj;

CrystalDecisions.ReportAppServer.ReportDefModel.ISCRFieldObject fldobjtmp;

fldrptobj = repObj;

fldobj = (CrystalDecisions.ReportAppServer.ReportDefModel.ISCRFieldObject)fldrptobj;

fldobjtmp = ((CrystalDecisions.ReportAppServer.ReportDefModel.ISCRFieldObject)fldobj.Clone(true));

fldobjtmp.FontColor.ConditionFormulas [CrystalDecisions.ReportAppServer.ReportDefModel.CrFontColorConditionFormulaTypeEnum.crFontColorConditionFormulaTypeStyle].Text = "if {@Ans1} = 'Yes' then crRed";

rcDoc.ReportDefController.ReportObjectController.Modify(fldobj, fldobjtmp);

}

}

my above code is not working. Is this functinality available in RAS.

please help me with valid code for this function.

Regards,

Padmanaban V