CHANGE SUMMARIZE FIELD COLOR

Applications Grid / Reports
#1

HOW CAN I CHANGE THE FIELD COLOR IN SUMMARIZE (RESUMEN EN ESPA?OL) OF A SUM FIELD DINAMICALLY?

F EX.

IF THE SUM > 100 THEN COLOR IS RED

ETC

I CANT FIND WHERE OR WHICH EVENTS USE?

THANKS

ADRIAN

#2

Re: CHANGE SUMMARIZE FIELD COLOR

HI
Check sc_field_color marcros in sc help

Regards
Dhana

#3

Re: CHANGE SUMMARIZE FIELD COLOR

sc_field_color (“sum_balance”, “#33FF66”);

Thanks Dhana! I did it in the Group By Events but nothing happens. The summarize dont come with events. is there any other place to wrote this code?

maybe im doing someting wrong.

#4

Re: CHANGE SUMMARIZE FIELD COLOR

You have write it in Onrecord event…!
if doens’t work check the Group events… for any event…!
Regards
Dhana

#5

Re: CHANGE SUMMARIZE FIELD COLOR

The grid section events doesnt seems to affect the sumarize flow at all

i put the following code on the onrecord event:

sc_error_message(“hi”);
sc_error_exit();

and my grid goes directly to the summarize and nothing happens

the group by events works for the calculation, but the format dont seems to be affected.

on the ongroupby event:

$total={count_departamento}*10;
if ($total>0) {sum_departamento_Calculada}=round({sum_departamento_Calculada}*100/$total);
else {sum_departamento_Calculada}=0;

until here works excellent

but
sc_field_color (“sum_departamento_Calculada”, “#33FF66”);

dont do anything. or maybe this function dont have scope with the special group by variables

#6

Re: CHANGE SUMMARIZE FIELD COLOR

SC needs an onSummary/onTotal event for this to happen. I have asked, please ask them as well.

Regards,
Scott.

#7

Re: CHANGE SUMMARIZE FIELD COLOR

Hi Scott,

Ok, i already post it in sugestions

Best

Adrian