Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 bar chart - y-axis

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2011-10-13 : 05:02:56
I am developing a SSRS report on a local machine which has sql server, BI...
In the designer, I use a dataset to set the max and min values of the chart y-axis.
Works well in the designer.
Problem starts when I deploy. (Deploy is done to the same machine). The deployed report messes up the y-axis and it shows 0% to 100% instead of showing say -5.5% to 6.9%
In-case it makes any difference, although placing =Sum(Fields!MinValue.Value, "MinMaxValues") into the minimum value, it gives a red line underneath Fields!MinValue.Value and when I hover over it, it says unknown collection member. Same for the maximum which I use =Sum(Fields!MaxValue.Value, "MinMaxValues")
Note that the above works in the designer, but not when deployed.
Everything is done on the same machine. There is no remote machine involved.
Question:
Do you know why the deployed report shows incorrect y-axis values?
Thanks
   

- Advertisement -