locked
how to write RDLC Report Expression RRS feed

  • Question

  • User-788007034 posted

    i want to write some expressions

    i have some expressions in my access version like

    =Round([SUF_T1_Cost]+[SUF_T2_Cost]+[SUF_T3_Cost],2)

    =IIf(IsNull([T1_Cost]),Null,[T1_Unit_Price])

    how ccould i write these two in .net rdlc reporting while design time

    i have write this by right click on my textbox and choose Expressions but there is one red line that shows error

    so help me plzzzzzz

    Tuesday, October 18, 2011 6:11 AM

Answers

  • User-788007034 posted

    Whenever you wanna write expressions in Design of RDLC Report and want to write fill out textbox with db filed you must wirte it as

    =Fields!T1_Cost.Value+Fields!T2_Cost.Value+Fields!T3_Cost.Value

    in case of Immediate if (IIF)

    =iif((Fields!T1_Cost.Value Is Nothing),"", Fields!T1_Unit_Price.Value)       to check null

    if condition is true then it fill the textbox with blank as i set "", if you set it as "NULL" your particular textbox will contains NULL in case of condition false

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, October 20, 2011 4:21 AM

All replies