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

1. Sharmin Jose January 14, 2012 at 1:50 am

   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 at 6:10 pm

   Sharmin Jose,
   I need the same answer to.
3. ravinder November 29, 2012 at 2:26 pm

   We can use Lookup function which is available in 2008 R2.
4. GAM SKJai July 30, 2013 at 7:18 pm

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

   )
5. Shalu October 30, 2013 at 8:47 pm

   Thanks for posting this useful information.
6. Milton May 14, 2014 at 9:09 am

   How is that when the Text Box is in a Matrix?
7. Ferry Meidianto Post authorMay 14, 2014 at 11:38 am

   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 at 10:32 pm

   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 at 7:54 pm

   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 at 7:58 pm

    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 Post authorMarch 31, 2016 at 10:47 pm

    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 at 5:46 pm

    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 at 11:46 am

    Thanks! Works well!
14. Jethro April 10, 2018 at 12:21 pm

    Thank you for this post. Very informative! This solved my problem. God Bless You
15. Hanif Ontorizarwin April 23, 2018 at 2:07 pm

    Thank you very much. you save my day. GBU