First of all, thank you for your suggestion. While your suggestion is valid, it requires the same calculation to be
done every time a textbox is bound, instead of reusing the result of the
calculation done previously.
For your info, the example that I gave on my first post was the simplified version of my report. In my actual report, there are some textboxes with expressions like this:
I also have some textboxes where I need to calculate this:
If I just use this expression (
=SUM(Fields.TotalPrice - Fields.TotalCost) / SUM(Fields.TotalPrice) * 100
), I will need to calculate
SUM(Fields.TotalPrice - Fields.TotalCost)
and
SUM(Fields.TotalPrice)
again for each textbox. Let's say I have many rows of data, won't this affect the time taken to display the report?