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

ssrs-2008 reporting-services ssrs-tablix
Emad-ud-deen picture Emad-ud-deen · Apr 8, 2012 · Viewed 19.9k times · Source

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

Paul Patterson picture Paul Patterson · Apr 8, 2012

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

Related questions

SSRS How to repeat the table header on each page in print preview

I have an SSRS report, for some reason the header is not repeating on all of the pages in the print preview mode. Below is the image of the table: I have as well checked the Repeat Header rows on …

Read More
How to check if SSRS Textbox is empty

How do you check if a textbox is empty in SSRS 2008? I've tried this code and it doesn't work. IIF(ReportItems!txtCountVolunter.Value = "", false, true)

Read More
Is there an easy way to rearrange tablix columns in SSRS design mode?

I have an SSRS report which contains more than 20 columns in a tablix. Our users have decided that the data is OK, but they want the columns moved around (sigh!). It seems like it should be easy to re-arrange the …

Read More