4 Replies Latest reply: Sep 17, 2013 11:14 AM by iccsi

Report Function and calculation

iccsi May 24, 2013 8:50 AM

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,

1. Re: Report Function and calculation

Eddie Lotter Sep 17, 2013 9:04 AM (in response to iccsi)

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.
Like Show 0 Likes (0)

Actions
2. Re: Report Function and calculation

iccsi Sep 17, 2013 10:32 AM (in response to Eddie Lotter)

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,
Like Show 0 Likes (0)

Actions
3. Re: Report Function and calculation

Eddie Lotter Sep 17, 2013 10:57 AM (in response to iccsi)

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.
Like Show 0 Likes (0)

Actions
4. Re: Report Function and calculation

iccsi Sep 17, 2013 11:14 AM (in response to Eddie Lotter)

Thanks for the information and help,

Regards,

Iccsi,
Like Show 0 Likes (0)

Actions