SQL Server Performance

Textbox Calculations

Discussion in 'SQL Server 2005 Reporting Services' started by Toni, May 16, 2006.

  1. Toni New Member

    I have 2 text boxes on my report that contain values. I want to be able to divide one by the other and the result placed in a third. I have try some variants on the expression builder to do the sum but it won't have it. Obviously I can't use =Fields!etc as they are not fields in the soure data for the report.

    What is the syntax to basically say TextBox3Value = Result of (Textbox1.Value / Textbox2.Value)

    Regards


    Toni Chaffin
    aka Toni
  2. Toni New Member

    Resolved by using

    TextBox3 syntax was:-

    =((ReportItems!TextBox1.Value)/(ReportItems!TextBox2.Value))

    Regards


    Toni Chaffin
    aka Toni

Share This Page