locked
Can you reference the data in another field? RRS feed

  • Question

  •  

    Is it possible to reference the data in another field within the same table?

     

    Let's say that one column has a calculation, and a second column has a different calculation. Can the third column find the difference between the first two columns?

     

    (I'm wondering if this is possible to do within the Layout View, not from the Data View)

     

     

    Thank you!

     

     

    Wednesday, December 5, 2007 11:05 PM

Answers

  • RS lets you refer to the value of a textbox from another textbox (known as report item references).  So if column 1 contains TextBox1 and column 2 contains TextBox2, in column 3 you could find the difference using:

     

    =ReportItems!TextBox1.Value - ReportItems!TextBox2.Value

     

    See the section on ReportItems on http://msdn2.microsoft.com/en-us/library/ms157274.aspx for more information.

     

    Hope this helps,

    John

    Thursday, December 6, 2007 1:59 AM
    Answerer

All replies

  • RS lets you refer to the value of a textbox from another textbox (known as report item references).  So if column 1 contains TextBox1 and column 2 contains TextBox2, in column 3 you could find the difference using:

     

    =ReportItems!TextBox1.Value - ReportItems!TextBox2.Value

     

    See the section on ReportItems on http://msdn2.microsoft.com/en-us/library/ms157274.aspx for more information.

     

    Hope this helps,

    John

    Thursday, December 6, 2007 1:59 AM
    Answerer
  •  

    Yes, that helps a lot! Thank you very much, John!

     

     - Trevor

    Friday, December 7, 2007 11:49 PM