sql server reporting services: 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,

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.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

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


[quoted text, click to view]