locked
show value on Header of report RRS feed

  • Question

  • User-1210839387 posted

    using report builder 2.0

    I am trying to show a field ProductID on the header portin of my report and have tried the following.

    the following shows nothing

    <expression>

    =first(reportitems!ProductID.Value)

    </expression>

    below shows only the first ID

    <expression>
    =reportitems!ProductID.Value

    </expression>

    showing nothing also

    <expression>
    =Fields!OrderNum.Value

    </expression>

    does anyone know the proper syntax for this? 

    Thursday, July 21, 2011 10:06 AM

Answers

  • User-1210839387 posted

    found it.

    1. added hidden textbox to field in body of report (below the header area),  expression is:

    =Fields!ProductID.Value

    ProductID is not a "reportItem" on the report

    2. added reference to field like this in the Header, expression is:

    =first(reportitems!ProductID.Value)

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 21, 2011 11:28 AM