I have a scatter chart in my report. On the category axis I am grouping by Product. There are no series groups. In the value well I have one value with the following subitems: Sum(Sales) and Sum(OrderQty). So I am plotting OrderQty vs Sales, by Product.
Here's the problem: I am getting nice round numbers on the Y axis, but on the X axis I get weird numbers (such as 2103, 3103 etc instead of 2000, 3000). I have turned on the margins for X axis, that doesn't help. What does help is if I set Minimum on the
X axis to 0. But I want Minimum to be automatically calculated.
I am using Report Builder 3.0
View Complete Post