Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

two values in Label in ssrs Expand / Collapse
Author
Message
Posted Monday, August 6, 2012 4:47 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, January 17, 2014 7:01 PM
Points: 91, Visits: 464
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).
Post #1340938
Posted Tuesday, August 7, 2012 8:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:39 AM
Points: 2,818, Visits: 2,558
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() & ")"
Post #1341309
Posted Thursday, August 9, 2012 12:18 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, January 17, 2014 7:01 PM
Points: 91, Visits: 464
thanks a lot
Post #1342921
Posted Friday, May 17, 2013 6:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 30, 2013 2:48 AM
Points: 1, Visits: 60
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," ")
Post #1453961
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse