Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / March 2006

Tip: Looking for answers? Try searching our database.

Scatter Chart issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
msdnuser - 21 Mar 2006 23:50 GMT
Hi all,

I have to create a report with scatter chart in reporting services 2005. I
need to set the scale with min 0.5 and max 2 for both X and Y axis and the
both axis should cross the other at 1. I tried checking Numeric or timescale
value in X axis properties. Whatever I do always both the axis starts with 0
but honors the max value. How will I force the starting value for both axis
at 0.5?

Thanks,
msdnuser
Wei Lu - 22 Mar 2006 02:44 GMT
Hi ringt,

Welcome to use MSDN Managed Newsgroup Support.

I have tested on my side, but it works fine. Would you please post the
detail properties here so that I can provide further assistance?

Please let me know the result. I look forward your reply.

Wei Lu
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.
=====================================================
Signature

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

msdnuser - 22 Mar 2006 20:00 GMT
Hi Wei Lu,

The sample dataset has values like these:

colA                colB                 colC
-----------------------------------------
0.6                  1.00                  x3
0.75                1.15                  x4
0.8                  1.10                  x1
0.82                1.08                  x5
0.9                  1.2                    x2

I am using colA as X-axis and ColB as Y-axis and colC as category. I need to
set 0.5 as min and 2 as max in both X and Y axes. Also they should cross each
other at 1. But always if we give a fractional value like 0.5 above, for min,
it automatically takes the next lowest whole number(in this case 0) as min
value (If we see the report in the report manager or preview mode. It is good
only in layout mode.). Is there any remedy to this?

Also when they cross at 1, I want the axis line(horizantal for x and
vertical for Y) also to move up. But what happens is only the x and y axis
labels move up. This makes the chart lot more confusing. Is there any
solution to this?

Note: I always check the option "Numeric/time scale value" for X-axis in
properties  window.

Thanks

> Hi ringt,
>
[quoted text clipped - 14 lines]
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
Wei Lu - 23 Mar 2006 13:29 GMT
Hi ringt,

Thanks for the update.

I tried on my side. If I use 0.5 as min and 2.0 as max, it works fine.

As for the cross issue, I think using the Major tick mark and Minor tick
mark will help you to make the chart more decent.

Hope this information will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
Signature

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

msdnuser - 23 Mar 2006 15:39 GMT
Hi Wei Lu,

Thanks for your help. Can you send me your rdl file? My mail id is
ringt@doglover.com.

Thanks.
Steven Cheng[MSFT] - 31 Mar 2006 10:31 GMT
Hi ringt,

How's everything going?

I'm wondering if the suggestion has helped or if you have any further
questions.  Please feel free to respond to the newsgroups if you need any
additional help.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.