Showing posts with label graph. Show all posts
Showing posts with label graph. Show all posts

Wednesday, March 21, 2012

Line location as expression

Is it possible to move lines based on the values from dataset(trying to draw graph kinda thing by joining points using lines) ?Let me know if I am not clear here.

Thanks

Yes, it is possible if I understand you correctly and if you are willing to do some custom rendering. Check out CustomReportItem and look at the Polygons sample in the RS sample stuff.

If you go this route, take it from me you will find out it's not all about 1's and 0's <rofl>.

But, yes, you are really not being clear <g>. So maybe I've misunderstood...

>L<

sql

Line Graph Question

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,
HaYou 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.
"Ha Vo" <ha.vo@.prometheuslabs.com> wrote in message
news:uqfYZc4lEHA.2680@.TK2MSFTNGP15.phx.gbl...
> 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
>

Line Graph One Data Point

Re: SQL Svr 2000

VS.NET 2003, with SQL Reporting Services (RS)

I have a graph that is requested to be a line graph, with data starting in Jan (hence one data point).

The graph lines are not showing, but markers do show.

Can a line graph, in RS, produce lines when there is only one month's data.

If so, pray tell, how?

Y axis is a count of projects by Complexity levels.

X axis are the months, which will range from Jan to Dec, when all the data is in.

I need to show Jan results.

A line chart "connects" data points. If there is only one data point at all, there will be no line.

-- Robert

sql

Line graph on bar chart

Does anyone know if it is possible to create a graph where a line is on top
of a bar chart?
I'm using reporting services 2000, cheers
bobThis is not possible unless you have a 3rd party program such as Dundas
"bobfoc" <Greg.conn@.nospam.nospam> wrote in message
news:uB8GP9Q6FHA.2092@.TK2MSFTNGP12.phx.gbl...
> Does anyone know if it is possible to create a graph where a line is on
> top of a bar chart?
> I'm using reporting services 2000, cheers
> bob
>|||Hi Bob,
Can you be more specific? Do you need to create stacked values or
duplicate values bar - line charts?
You can download and try Nevron Chart for .NET from:
http://www.nevron.com
The evaluation is fully featured and you will be able to create
spectacular charts.
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success|||And this works with reporting services yes?
Greg
"Christo Bahchevanov" <christo@.nevron.com> wrote in message
news:1133452933.814425.96550@.g14g2000cwa.googlegroups.com...
> Hi Bob,
> Can you be more specific? Do you need to create stacked values or
> duplicate values bar - line charts?
> You can download and try Nevron Chart for .NET from:
> http://www.nevron.com
> The evaluation is fully featured and you will be able to create
> spectacular charts.
> Regards,
> Christo Bahchevanov
> Nevron - Visualize Your Success
>|||Hi Greg,
Nevron Chart can be used as part of any program that want to generate
dynamic, data driven charts.
Feel free to download the free evaluation from http://www.nevron.com
Regards,
Christo Bahchevanov
Nevron - Visualize Your Success

Line graph - line width

How do I set the line width (weight) of lines with a line chart. Lines
always seem several pixels wide.
Also, when selecting "Numeric or time-scale values" on the X-axis of a line
chart the labels appear vertically in the Chart Properties dialog box but
appear horizontally when the report is generated. I have RS sp1 installed.
How do I fix this problem?Answer to your first problem:
Layout view: right-click the chart, select properties, go to the data tab,
press the edit button for the desired value, go to the appearance tab and
there you can set the width of a line.
They've put it away quite well :)
"Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> How do I set the line width (weight) of lines with a line chart. Lines
> always seem several pixels wide.
> Also, when selecting "Numeric or time-scale values" on the X-axis of a
> line
> chart the labels appear vertically in the Chart Properties dialog box but
> appear horizontally when the report is generated. I have RS sp1 installed.
> How do I fix this problem?|||Thanks! I've noticed that setting the line weight to 0.75 pixels produces
sharp lines. Less than 0.75 and the line doesn't appear.
"Pieter van Maasdam" wrote:
> Answer to your first problem:
> Layout view: right-click the chart, select properties, go to the data tab,
> press the edit button for the desired value, go to the appearance tab and
> there you can set the width of a line.
> They've put it away quite well :)
> "Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
> news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> > How do I set the line width (weight) of lines with a line chart. Lines
> > always seem several pixels wide.
> >
> > Also, when selecting "Numeric or time-scale values" on the X-axis of a
> > line
> > chart the labels appear vertically in the Chart Properties dialog box but
> > appear horizontally when the report is generated. I have RS sp1 installed.
> > How do I fix this problem?
>
>|||This is a limitation of the chart control in RS 2000 which only allows
integer values for line width. This will change in RS 2005. For pixel-based
output format (like TIFF) you won't notice to much difference, but in vector
graphics formats (like EMF) you will see differences especially when zooming
or at high resolutions (e.g. printing).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in message
news:80991847-4967-4F14-840E-20F72C0DE53B@.microsoft.com...
> Thanks! I've noticed that setting the line weight to 0.75 pixels produces
> sharp lines. Less than 0.75 and the line doesn't appear.
> "Pieter van Maasdam" wrote:
> > Answer to your first problem:
> >
> > Layout view: right-click the chart, select properties, go to the data
tab,
> > press the edit button for the desired value, go to the appearance tab
and
> > there you can set the width of a line.
> >
> > They've put it away quite well :)
> >
> > "Stephen Strong" <StephenStrong@.discussions.microsoft.com> wrote in
message
> > news:B7EB33C9-E210-4F18-9E08-AC588746DC7F@.microsoft.com...
> > > How do I set the line width (weight) of lines with a line chart.
Lines
> > > always seem several pixels wide.
> > >
> > > Also, when selecting "Numeric or time-scale values" on the X-axis of a
> > > line
> > > chart the labels appear vertically in the Chart Properties dialog box
but
> > > appear horizontally when the report is generated. I have RS sp1
installed.
> > > How do I fix this problem?
> >
> >
> >
>