Cross Tab - Back Ground Colour 1

[saran26]

Hi All,

I have a summary field in cross tab, called "Effort".

I have an additional field in the table called "Status". Is it possible to change the back ground colour of the effort based on the status field.

I tried the following in the back ground x-2 with out any success.

Please help me out.

if {ClearQuest.monthlyeffort_status} = "1" then crRed else crYellow

Thanks
Saran

 

[lbass]

How is the crosstab set up (rows, columns, summaries)? Is the monthlyeffortstatus field used in the crosstab somewhere?

-LB

 

[saran26]

Yes LB .

It was set it up as (rows, Columns and Summaries)

I did try to include the monthly effort status field as a summary field and change the back groud.

But it changes only for that field. Is it possible to change the selected row based on the status field.

Please let me know.

Thanks

 

[lbass]

I am asking you to identify the row, column and summary fields.

-LB

 

[saran26]

OK here it is

Row Field is ClearQuest.name

Column fied is ClearQuest.Monthly Effort

Summary field 1 is Max of @effort (it is a formula field)

Summary field 2 is Max of ClearQuest.MonthlyEffortStatus

Thanks

Saran

 

[lbass]

Reverse the order of the summary fields, and then select the summary of the effort status field in preview mode->right click->format field->suppress->x+2 and enter:

whileprintingrecords;
stringvar status := currentfieldvalue;
false

Then select the {@effort} summary->right click->format field->borders->color->background->x+2 and enter:

whileprintingrecords;
stringvar status;
if status = "1" then
crRed else
crYellow

-LB