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

chart x-axis. Separate label format plz help Expand / Collapse
Author
Message
Posted Wednesday, October 17, 2012 3:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 4:19 AM
Points: 3, Visits: 94
Hello everyone,

I want to do a simple thing which costed me a lot of time already

View the following chart:


For example I only want the label 29 to have an underline.
the X-axis category group is a date. And in the label I show the value: =Day(Fields!date.Value)

So far so good, but when I want to format the label-effect through the use of an expression. It doesn't do it.
The used expression: =Iif(Day(Fields!date.Value)=29,"Underline","None")

Am I doing somethin wrong or is it just not possible to format a separate label?
I am using 2008R2 SP2

Greets and thanks
Post #1373701
Posted Wednesday, October 17, 2012 6:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 4:19 AM
Points: 3, Visits: 94
Okay normally you can't format the labels seperately, it's some kind of bug:

[url=http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/fcb9bcb4-eae4-4f8e-9827-19158b18a653/?prof=required][/url]

But a good alternative is to apply the expression on the markers of a chart serie. That works.

greets
Post #1373757
Posted Monday, October 22, 2012 5:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 7:23 AM
Points: 114, Visits: 386
Hello ,
Look into this link common properties of charts
http://www.bi-rootdata.com/2012/10/chart-common-properties.html
Post #1375343
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse