Post reply

two values in Label in ssrs

  • August 6, 2012 at 4:47 pm

    #264783

    How i can display two values in same label.but i want to show second value in bracket().i am using this expression

    =round(Fields!MegaBytes.Value,0).ToString() & " " & (round(Fields!MBPerSub.Value,0).ToString())

    it is giving me proper result.but second value(MBpersub) is not diplaying in bracket().

    for e.g: 400 (55555).

  • August 7, 2012 at 8:33 am

    #1522636

    weston_086 (8/6/2012)

    How i can display two values in same label.but i want to show second value in bracket().i am using this expression

    =round(Fields!MegaBytes.Value,0).ToString() & " " & (round(Fields!MBPerSub.Value,0).ToString())

    it is giving me proper result.but second value(MBpersub) is not diplaying in bracket().

    for e.g: 400 (55555).

    I don't think you really need the ToString(), but using your expression

    =round(Fields!MegaBytes.Value,0).ToString() & " (" & round(Fields!MBPerSub.Value,0).ToString() & ")"

  • August 9, 2012 at 12:18 pm

    #1524026

    thanks a lot

  • May 17, 2013 at 6:30 am

    #1616139

    Hi,

    Here i have the one column and it contains the data like Active, Closed , Running.

    now i want to display the status count for each status in a single label.

    Like below

    Active : 5

    Closed: 10

    Running : 3

    For this i have a expression but i didn't works here , can any one help me to solve this issue.

    =IIF(Fields!system_state.Value= "Active",Fields!countofWI.Value," ")& VbCrlf & IIF(Fields!system_state.Value= "Closed",Fields!countofWI.Value," ")& VbCrlf &(Fields!system_state.Value= "Running",Fields!countofWI.Value," ")

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply