How to get Table Cell or Text Box value in SSRS

Comments

15 responses to “How to get Table Cell or Text Box value in SSRS”

1. 

   Sharmin Jose

   January 14, 2012

   I have two tables. One pulls information from DS1 and the other pulls it from DS2. How can I access the textbox txt1 in Tablix1 from Tablix2?

2. 

   Mantvydas Ozerenskis

   August 22, 2012

   Sharmin Jose,
   I need the same answer to.

3. 

   ravinder

   November 29, 2012

   We can use Lookup function which is available in 2008 R2.

4. 

   GAM SKJai

   July 30, 2013

   Thanks for the Help (ReportItems![Text Box name].Value

   )

5. 

   Shalu

   October 30, 2013

   Thanks for posting this useful information.

6. 

   Milton

   May 14, 2014

   How is that when the Text Box is in a Matrix?

7. 

   Ferry Meidianto

   May 14, 2014

   Hi Milton,
   You need to use InScope.
   The following forum thread will give you clue about it:
   http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0bde66d7-b0e4-40da-9a0c-838663e66119/inscope-example-trouble-with-multiple-row-groups?forum=sqlreportingservices

8. 

   Milton

   May 15, 2014

   Hi Ferry,

   I wanted get grand total value to calcule percentage in a chart, but this calculation is in a group and I can’t get the total, so I tried to take it by the textbox name, but this textbox is a matrix.

   I finally deleted the matrix (column group) to have various textbox with distinct names.

   Thanks you very much.

9. 

   Faycel Ben Aissa

   March 31, 2016

   I have one table tablix1 How can I access the textbox txt1 in Tablix1 ? can anyone help me please ?

10. 

    Faycel Ben Aissa

    March 31, 2016

    I have one table tablix1 How can I access the value of the textbox in Tablix1 ? i want to calculate the sum of this expression can anyone help me please ?

11. 

    Ferry Meidianto

    March 31, 2016

    You can refer to this discussion:
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d4a3969a-f3fc-457b-8430-733d7b590ff6/use-reportitems-to-sum-all-textboxes-in-a-tablix?forum=sqlreportingservices

12. 

    ABHISHEK C

    July 1, 2016

    Thanks for the query.(ReportItems![Text Box name].Value) I have searched some many website but i did not get. Finally i got here.

    Thanks.

13. 

    Fazal

    March 16, 2017

    Thanks! Works well!

14. 

    Jethro

    April 10, 2018

    Thank you for this post. Very informative! This solved my problem. God Bless You

15. 

    Hanif Ontorizarwin

    April 23, 2018

    Thank you very much. you save my day. GBU