sql server reporting services: Line Graph Question -- sql server reporting services

Line Graph Question

Ha Vo
9/10/2004 3:39:54 PM

sql server reporting services:

My line graph is currently using the yearmonth datafield on the x-axis and
the number of units ordered datafield on the y-axis ( it pretty much
demostrates the consumers' purchasing trends throughout the months of a
year)- this is a horizontal line. I want to create a second line (vertical
line) that marks the date datafield (separate from the yearmonth datafield)
of an event to show the the user the effects of the purchasing trends after
an event date (date datafield) throughout the months. Is this possible? And
if so, how would I approach this? Thank you in advance for you help.

Sincerely,
Ha

Re: Line Graph Question

Robert Bruckner [MSFT]
9/13/2004 9:31:40 PM

You may want to try to combine the line chart with a column chart (see this
related posting):
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us

You would use the chart series with the columns to mark certain date ranges.
You can modify the default width of columns by changing the PointWidth
property (directly in the RDL file). See also this related posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=8eda1408-dffc-459e-8cb3-c52e718c2358&sloc=en-us

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]