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

lables in ssrs Expand / Collapse
Author
Message
Posted Monday, August 6, 2012 4:52 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 #1340940
Posted Monday, August 6, 2012 11:47 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 10:57 PM
Points: 56, Visits: 361
You have not coded for the brackets to be displayed. Brackets has to be part of the Expression.
Post #1341014
Posted Tuesday, August 7, 2012 2:01 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 6, 2014 11:35 PM
Points: 75, Visits: 262
try this

=round(Fields!MegaBytes.Value,0).ToString() & " (" & (round(Fields!MBPerSub.Value,0).ToString()) & " )"
Post #1341053
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse