Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how do I reference a text box value in an expression? SSRS

I have a list and inside this list I have a text box.

Since it's a list, the text box value changes for each row in the dataset.

OUTSIDE this list, I have another text box which is part of the HEADER.

I want the HEADER to change based on the value of the text box in the list.

In the text box in the header, how do I reference the text box inside the list?

like image 897
JJ. Avatar asked Aug 27 '15 18:08

JJ.


People also ask

Where is the text box number in SSRS report?

You can right-click on the report(. rdl) and click "View Code". This opens the xml file in Visual Studio. You can search the number in the xml file.

What we called a special textbox that calculates value as the report is generated?

The textbox is called TextBoxSubTotal.


1 Answers

To refer to any report objects you can use ReportItems Collection.

In your header textbox put a expression like this to refer to textbox in the list:

=ReportItems!TextBoxList1.Value 

Remember SSRS is case sensitive. Make sure you get the right name of the text box object you are referring to.

MSDN article on ReportItems

like image 151
Anup Agrawal Avatar answered Sep 19 '22 06:09

Anup Agrawal