Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Conditional Formatting Question

First off, let me say that I am definitely a Crystal novice and I'm sure the answer to this question is above my head but if someone can guide me in the right direction, I'm pretty sure I can figure it out.

OK, I have a report that contains a cross-tab. The column contains the date grouped by month. There are 3 fields in the rows and a field called Assignment.ActualTime in the summarized field.

I would like to setup an advanced conditional formatting syntax for the Summarized field. I would like for the background of each cell of Assignment.ActualTime to turn RED if the increase from the previous month is greater than 20%.

Any help would be appreciated.

Kindly,

Dean Schmaus

replied

Hi Dean,

As per your query:

"In Crystal Reports (CR), is it possible to conditionally format a field based on the values of another field within a cross-tab report?"

I can provide you the following information:

--> It is not possible to conditionally format a field based on the value of another field in the cross-tab report.

For example, you are attempting to conditionally format the color of one cross-tab summary field based on the value of another summary field.

The cross-tab field can only be conditionally formatted based on the current field values.

Background Information

-


By design, a cross-tab report displays summary values that correspond to specific row and column values only. The values for one summarized field are not accessible to other summarized fields for use in conditional formatting formulas due to the evaluation time of the summaries.

NOTE:

It is possible for fields in a cross-tab report to be conditionally formatted based on the current field values only.

Regards,

Alpana

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question