Displaying the value of a textbox in other parts of a report

Question

In a report table there is this formula to calculate a subtotal for an invoice. This is the formula:

=Sum(Fields!LineTotal.Value)

The textbox is called TextBoxSubTotal. I would like to display this in another part of the report such as in the header area where I display that subtotal, tax, shipping charge and also a total due.

Can you tell me how to display this value in TextBoxSubTotal in other parts of the report?

Answer 1

Have you tried creating a report variable? Create a new variable and put the invoice calculation into the expression for the new variable. Then reference the report variable from the two textboxes.

The source for the two textboxes would look something like this:

=Variables!TestVariable.Value

http://msdn.microsoft.com/en-us/library/dd255208(SQL.105).aspx