Hello,I have a sql report, developed inBusiness Intelligence Development Studio 2005, which contains a column chart. My problem is that this chart displaysduplicate y-axis values at times. For example - If the y axis values are '1', '2', '3', '4', '5', sometimes it will display the following: '1', '1', '2', '2', '3', '3', '4', '5'.When I am developing the report in BIDS 2005, the problem does not occur. The problem occurs when I publish the report to a SQL Server 2008 server and run it from there. When running the report from Report Manager on the 2008 server the duplicate y-axis values appear.Does anyone know what would cause the duplicate values to appear? It appears to occur only when I have a small number of y-axis values, such as 1-5 values. When I have more values the duplicates do not appear.Please let me know if you can help me fix this issue.Thanks,Mike

Is it possibly the number formatting? If the number format is just set to be something like number with no decimal places, you might get multiple instances of 1, but the values are really 1, 1.25, etc. Try checking the formatcode property for the axis labels. -SeanProgram Manager, SQL Server Reporting Services

Thanks for your response. Unfortunately I've verified its not a number formatting issue, and am still trying to figure it out. Thanks again Mike

If you can reproduce the problem against AdventureWorks or using a SQL Statement that doesn't require a database and provide us with the RDL, we will definitely take a look at this. If you want to file a bug on Connect you'll have the option to attach the RDL. Otherwise, if you could put the RDL up on a file sharting site like Skydrive, you can reply back with the link and we will investigate it. -SeanProgram Manager, SQL Server Reporting Services

Sean, I appreciate your help. I will need to consult my manager to check whether or not this rdl file can be posted. If it can be I will let you know. In the meantime, however, I have just realized that our version of SQL Server does not appear to contain the latest hotfixes/patches from Microsoft. Do you believe it would be prudent to install the latest SQL Server 2008 updates, in a development environment first of course, to check whether or not they may solve the problem?Thanks again

If you are using SSRS 2005, please do make sure you have the latest SPs. I do know of an issue related to axis labeling that was fixed in one of the SPs, but the symptons you describe are a bit different. Try reproducing the issue you do have by just using an embedded SQL statement in your report where you populate the chart like this.SELECT 5 as X, 10 as Y UNION ALLSELECT 7 as X, 12 as Y......continuedThat way you can mask the data and then it shouldn't be an issue to put it up on SkyDrive. If you want to try SSRS 2008, you can just download Report Builder 2.0 (Microsoft Downloads) and try to run the report from within it locally.-SeanProgram Manager, SQL Server Reporting Services

Hi Sean,I'm going to download & install the latest service packs this week. After doing so, if the problem disappears I'll be sure to let you know. Otherwise I'll proceed to try that UNION recommendation of yours. Either way I will let you know.Thanks again for your helpMike

I've had the same problem with SSRS Charts in Visual Studio 2008. When I add decimal places, I see fractional values, but the problem is that we're using integers, with no decimal places, so obviously we wouldn't want or need the extra intervals... we ended up just making an expression for the interval that is basically a better "auto". Does anyone know a better solution for this?