sql server reporting services: scatterplots -- sql server reporting services

scatterplots

JMunson
9/2/2005 1:21:03 PM

sql server reporting services: I wish to create a scatterplot in which the data points are connected by a
line.
My recordset is as follows and contains up to 20 records. (there is an
input parameter which limits the dataset to a small # of records.)

ID, X, Y1, Y2

I want the graph to plot the following pairs (X,Y1) and (X,Y2). So far, the
scatterplot only displays one point.

I have done it with a line graph, however, the line graph treats the X
variable as a category and places them in equal intervals. In reality the X
variable is the age of the individual. Thus, I want the Y1, and Y2 variables
plotted at the appropriate place on the X axis (which is the person's Age).

Any ideas why scatterplot can't do this?

Thanks,
Jeff

RE: scatterplots

JMunson
9/8/2005 2:09:04 PM

What data structure do people use to correctly display a scatterplot? Anyone
have any thoughts?

[quoted text, click to view]

Re: scatterplots

Robert Bruckner [MSFT]
9/24/2005 7:26:32 PM

Add a category grouping based on a unique value. In your example it looks
like the ID field provides unique values across rows. Without at least one
category grouping or series grouping, the scatter chart will only show one
point.

Everything else should work then.

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.