Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
348 views
in Technique[技术] by (71.8m points)

reporting services - 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?

question from:https://stackoverflow.com/questions/32256498/how-do-i-reference-a-text-box-value-in-an-expression-ssrs

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...