Line/Point Chart

I am trying to create a simple chart that displays just the data points and
"hide" the line. Scatter chart does not appear to be the right choice for
this. Is there a way to create a line chart and then hide the line so that
only the data points themselves are visible?
JHIn RS 2000 SP1 or later, you can just set the border line width property on
the value to a value of 0.5 pt or lower.
In RS 2005, you can set the border line style to "None".
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:5A79CABA-6B4E-4579-9610-B06BF3136F71@.microsoft.com...
>I am trying to create a simple chart that displays just the data points and
> "hide" the line. Scatter chart does not appear to be the right choice for
> this. Is there a way to create a line chart and then hide the line so that
> only the data points themselves are visible?
> JH|||Have you tried setting the line color to the same as the background color?
--
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:5A79CABA-6B4E-4579-9610-B06BF3136F71@.microsoft.com...
>I am trying to create a simple chart that displays just the data points and
> "hide" the line. Scatter chart does not appear to be the right choice for
> this. Is there a way to create a line chart and then hide the line so that
> only the data points themselves are visible?
> JH

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 Chart X-Axis has too many point

Hi All,
I have a Chart line report that works great except when there are too many
data points. The x-axis labels then get too cramped and become unreadable.
I saw from another post that to fix this, you right mouse click on the chart
object, select properties, select "X Axis" tab, set "Major tick mark" to
"None" and "Minor tick mark" to "None". So I have "Major tick mark" set to
"None" and "Minor tick mark" set to "None" and also set on my "X Axis" tab
is: Checkbox "Show labels" is "Checked" and "Scale Minimum" = 0 (nothing
else is specified). However, this is not solving the problem (i.e. the
x-axis labels are still cramped together and unreadable).
I called Dundas Software and their tech support department said they cannot
provide technical support to me since I am using the Chart control packaged
with SQL Reporting Svsc 2005.
Can anyone offer any advice on how I can solve this?
Thanks in advance.Hello,
Since SQL Server 2005 has not been publicly released yet, we do not support
SQL Server 2005 in the newsgroup. For any SQL Server 2005 and related
issues, you could post here
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
Thank you for your patience and cooperation.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Sorry, typo...I am on SQL Reporting Svcs 2000.
"Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
news:%23xWn$y%23tFHA.3252@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a Chart line report that works great except when there are too many
> data points. The x-axis labels then get too cramped and become
> unreadable. I saw from another post that to fix this, you right mouse
> click on the chart object, select properties, select "X Axis" tab, set
> "Major tick mark" to "None" and "Minor tick mark" to "None". So I have
> "Major tick mark" set to "None" and "Minor tick mark" set to "None" and
> also set on my "X Axis" tab is: Checkbox "Show labels" is "Checked" and
> "Scale Minimum" = 0 (nothing else is specified). However, this is not
> solving the problem (i.e. the x-axis labels are still cramped together and
> unreadable).
> I called Dundas Software and their tech support department said they
> cannot provide technical support to me since I am using the Chart control
> packaged with SQL Reporting Svsc 2005.
> Can anyone offer any advice on how I can solve this?
> Thanks in advance.
>|||Hello,
Please reproduce this issue with the sample AdventureWorks2000 database,
then post here the detailed steps to reproduce the issue. Send the report
to me so I can check the issue on my side. My email address is
v-sguo@.microsoft.com. After checking it I will let you know the results.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||It sounds like your are NOT using a timescale/numeric x-axis. You can solve
the issue with too many labels on the x-axis by setting the x-axis MINOR
interval value to e.g. 5 (i.e. one label per 5 categories / data samples).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
news:eTarYvGuFHA.3500@.TK2MSFTNGP09.phx.gbl...
> Sorry, typo...I am on SQL Reporting Svcs 2000.
> "Anthony LaMark" <anthony@.eXcSoftware.com> wrote in message
> news:%23xWn$y%23tFHA.3252@.TK2MSFTNGP10.phx.gbl...
>> Hi All,
>> I have a Chart line report that works great except when there are too
>> many data points. The x-axis labels then get too cramped and become
>> unreadable. I saw from another post that to fix this, you right mouse
>> click on the chart object, select properties, select "X Axis" tab, set
>> "Major tick mark" to "None" and "Minor tick mark" to "None". So I have
>> "Major tick mark" set to "None" and "Minor tick mark" set to "None" and
>> also set on my "X Axis" tab is: Checkbox "Show labels" is "Checked" and
>> "Scale Minimum" = 0 (nothing else is specified). However, this is not
>> solving the problem (i.e. the x-axis labels are still cramped together
>> and unreadable).
>> I called Dundas Software and their tech support department said they
>> cannot provide technical support to me since I am using the Chart control
>> packaged with SQL Reporting Svsc 2005.
>> Can anyone offer any advice on how I can solve this?
>> Thanks in advance.
>

Line Chart data points

Hello all,
I hope one of the gurus here can help me out.
I have a line chart in reporting services (sp2) with month on x-axis, year on
y-axis with aggregate monthly totals for datapoints. The user selects a date
range, say January 2004 to June 2005. The chart produces one line for each
year but since 2005 has not ended yet, there should be no data for the end of
the year but the chart is putting datapoints with a zero value on the chart.
When I put the same query in a matrix, those months don't show up because
there is no data (duh). How can I get those data points off the chart?
Looking forward to any help and many thanks in advance.
Cheers!Hi Wendy, I am still pretty new at this. But I would think an IIF statement
in the Filter tab of the Chart properties might work. I guessing here, but
that is the first thing that pop in my head when I read your post. Thanks and
have a great day, Kerrie
Wendy j wrote:
>Hello all,
>I hope one of the gurus here can help me out.
>I have a line chart in reporting services (sp2) with month on x-axis, year on
>y-axis with aggregate monthly totals for datapoints. The user selects a date
>range, say January 2004 to June 2005. The chart produces one line for each
>year but since 2005 has not ended yet, there should be no data for the end of
>the year but the chart is putting datapoints with a zero value on the chart.
>When I put the same query in a matrix, those months don't show up because
>there is no data (duh). How can I get those data points off the chart?
>Looking forward to any help and many thanks in advance.
>Cheers!
Message posted via http://www.sqlmonster.com|||Hi Kerrie,
Thanks for your reply! I thought the same thing initially but since the
points technically don't exist they cannot be filtered out. It is almost as
if the chart is 'filling in the blank' with a value of zero.
Wendy
Kerrie S wrote:
>Hi Wendy, I am still pretty new at this. But I would think an IIF statement
>in the Filter tab of the Chart properties might work. I guessing here, but
>that is the first thing that pop in my head when I read your post. Thanks and
>have a great day, Kerrie
>>Hello all,
>>I hope one of the gurus here can help me out.
>[quoted text clipped - 7 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
Message posted via http://www.sqlmonster.com|||Sorry I could not be more help. I hope someone answer you, I am curious to
know.
Wendy j wrote:
>Hi Kerrie,
>Thanks for your reply! I thought the same thing initially but since the
>points technically don't exist they cannot be filtered out. It is almost as
>if the chart is 'filling in the blank' with a value of zero.
>Wendy
>>Hi Wendy, I am still pretty new at this. But I would think an IIF statement
>>in the Filter tab of the Chart properties might work. I guessing here, but
>[quoted text clipped - 6 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
Message posted via http://www.sqlmonster.com|||It sounds like you are running into the issue described in the following KB
article: http://support.microsoft.com/kb/883675
However, this was definitely fixed on RS 2000 SP2. Are you sure you have SP2
installed for Report Designer and on the report server?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kerrie S via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:541C109219A03@.SQLMonster.com...
> Sorry I could not be more help. I hope someone answer you, I am curious to
> know.
> Wendy j wrote:
>>Hi Kerrie,
>>Thanks for your reply! I thought the same thing initially but since the
>>points technically don't exist they cannot be filtered out. It is almost
>>as
>>if the chart is 'filling in the blank' with a value of zero.
>>Wendy
>>Hi Wendy, I am still pretty new at this. But I would think an IIF
>>statement
>>in the Filter tab of the Chart properties might work. I guessing here,
>>but
>>[quoted text clipped - 6 lines]
>>Looking forward to any help and many thanks in advance.
>>Cheers!
>
> --
> Message posted via http://www.sqlmonster.com