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.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-10-11 : 09:09:41
|
| Hi,How can I find out why the deployed report on the server is different to the report I run from the visual studio designer?For example the y-axis min and max values on the deployed chart is different to that in the designer in vs because I use an expression for the min and max values of the y-axis.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-11 : 13:13:19
|
| you've an option to import the report from server if you're mapped on to admin or similar roles.save it as a different name locally and compare it with local versionif there's a version control tool like Visual Source Safe, you can use that also after adding file and view differences------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-12 : 03:46:56
|
| In the y-axis of the chart. the min and max axis options are set to auto by default.I created a new dataset which retrieves the min and max values I can use in the y-axis.So now the minimum and maximum values are expressions set to the following respectively.for minimum range value=Sum(Fields!MinValue.Value, "MinMaxValues")/100for maximum range value=Sum(Fields!MaxValue.Value, "MinMaxValues")/100However, in the expression section there is a red underline for Fields!MinValue.Value and Fields!MaxValue.Value which says unknown collection member.Interval is set to 0.02 and Interval Type is set to AutoThe chart works fine when I preview it. And the y-axis range is quite right based on the new dataset i.e. MinMaxValues datasetProblem is that when I deploy the report, th ey-axis range goes from 0% to 100% at interval of 2%What am I doinig wrong please?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-12 : 05:04:11
|
| are you using same db when accesng report from server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-12 : 05:45:22
|
| Yes, indeed.I have donoe several tests since my last post.In the following the preview shows the expected result on the bar chart.1- If y-axis range for minimum and maximum are set to auto, then the deployed report on the server shows the y-axis range as the auto which in this case is: -10.0% to +10.0%2-If I place the expressions for the min and max values of the y-axis range, then deployed report does NOT show the y-axis range correctly. Instead it shows many values on the y-axis rane. It seems to be goiong from 0.0% to 100.0% with intervals of 1%.For minimum expression for the range of the y-axis of the chart I use:=Sum(Fields!MinValue.Value, "MinMaxValues")/100For maximum expression for the range of the y-axis of the chart I use:=Sum(Fields!MaxValue.Value, "MinMaxValues")/100It seems, If I do not use an expression for the range of the y-axis, the report is fine. The problem happens when I place a range expression.Any thoughts please? |
|
|
|
|
|
|
|
|
Deploy