Report Function and calculation

[iccsi]

I use Report Builder for summary at group footer.

I tried to function builder like

Sum(Query.MyField), but the report builder does not like this for some reason.

I tried to use Query.MyField, Report Builder still does not like it to give me ColdFusion does not recognize it.

I need to have calculation field like

sum(MyField1 * MyField2)/ sum(MyField2) and sum(MyField2) base on group elements.

for my summary field and need change color if it is neccessary.

Does Report Builder support client side code like Javascript to change client side behavior?

Your help and information is great appreciated,

Regards,

Iccsi,

[EddieLotter]

If you are still having a problem with this, post a reply and we can work through the problem.

I suspect you are setting up your calculated fields incorrectly.

[iccsi]

Thanks for the information and help,

I use =, < and > sign, I just realized that I need use EQ, GT, and LT.

I need to change the color or the lable base on the equation, but I can not access my lable from my function to assign color.

For example, I want to change my label color to red if field value less than 10.

Thanks again for helping and information,

Regards,

Iccsi,

[EddieLotter · Accepted solution]

Unfortunately the Report Builder does not provide a way to access the field and label properties at runtime.

The only way to make a label/field change its color depending on a value is to create multiple labels, one on top of the other; then use the "Print When Condition" property of each label to determine which one is visible for a given condition.

[iccsi]

Thanks for the information and help,

Regards,

Iccsi,