all groups > sql server reporting services > march 2006 >
You're in the

sql server reporting services

group:

X Axis


X Axis Tango
3/14/2006 5:29:39 PM
sql server reporting services:
Hi,
i have a 2000 report with dates on the x axis.
is it possible to just have the start date to the furthest most left point
on the x axis and the end date on the furthest most left point on the x axis

i was also wondering how i could manipulate the range say only showing the
date on the fisrt of each month.

RE: X Axis Joe Dillon
3/15/2006 6:58:28 AM
You could put the minimum & maximum date range in the x-axis Title as an
expression like this:

=" Date Range from " & Min(Fields!myDate.Value) & " to " &
Max(Fields!myDate.Value)



[quoted text, click to view]
RE: X Axis Joe Dillon
3/15/2006 7:21:27 AM
Another solution is to

1) Create a new DataSet (called "dsMinDate") like this (same FROM & WHERE
clause as your chart query):
SELECT Min(myDate) AS "myMinDate" FROM Table1....
2) On chart properties, choose Data tab, select Category Group, click
Edit... button, and change the Label to the following expression:
=iif( Fields!myDate.Value = First(Fields!myMinDate.Value, "dsMinDate"),
Fields!myDate.Value , " " )

3) Then create another dataset for Maximum date, then extend this expression
to test for the max date.



[quoted text, click to view]
RE: X Axis Tango
3/15/2006 9:02:10 PM
Thanks Joe

[quoted text, click to view]
AddThis Social Bookmark Button