Chart with RunningValue and maximum Y axis - line goes off the top of the chart
I have a SSRS 2005 chart that has three normal data lines plus one that uses a RunningValue. I have a Y axis maximum that is set at run time via a function. Depending on the result of that function, it is quite normal for the data to exceed that. The normal data lines behave the way I expect, and cleanly get cut off at the maximum value. The running value, however, goes right off the top of the chart, through the report title area. Is there something I need to do differently to get it to behave itself?
April 13th, 2010 1:04pm

Any suggestions? Is this a known bug?
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2010 5:42pm

Bumping again.... I'm going to try drawing a white rectangle on the screen to band-aid this temporarily, but I can't be the only person who has ever encountered this....?
April 16th, 2010 12:39pm

Hi alicorn2, I tested your scenario on my local environment Sql Server Reporting Service 2008, the result is fine. In order to solve the issue properly, could you please supply the way you produce your report and the expression of Running Value? I reproduce the case as following steps: 1. Prepare for a dataset with your data fields 2. Drag and drop the data fields such as 'Current Cost To Date', 'Allocation','2003 Costs' to the corresponding place 3. Drag and drop any one of the data fields from the dataset to the data field place for a second time, and right-click the data field , then select Series Properties 4. Click the 'fx' button at the back of drop-down list of Value field, type in the expression =RunningValue(Fields!Originalvalue.Value,Avg,"DataSet1") Note: Here Originalvalue is just a instance, you can change it to the data field of which you want to get a average 5. Click OK, and then switch to Legend tab. 6. Change the name of legend to 'Average Historic Cost To Date' in textbox of 'Custom legend text:' 7. Switch to the Design page of report, and then right-click the Y-Axis on the report 8. Select Axis Properties, type in a max value in the textbox of Maximum Then preview the report, you will see that the lines is cut off at the maximum value. Thanks, Challen Foo
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2010 3:53am

Hi Challen, thanks for the reply - I am using SSRS 2005 though, so perhaps it is a bug they've fixed. I've written a work-around: My original code was just this: =RunningValue(Fields!HistCostToDate.Value,Sum,"Dummy2") So I wrapped it in an IIF to check to see if it has exceeded my "zoom" maximum value, and if it has, return Nothing instead of the value. =iif(RunningValue(Fields!HistCostToDate.Value,Sum,"Dummy2")>First(Fields!YAxisMaxZoom.Value, "CostToDate") ,Nothing,RunningValue(Fields!HistCostToDate.Value,Sum,"Dummy2")) Not exactly ideal, but it has solved the problem.
April 19th, 2010 2:12pm

Hi Alicorn2, Thanks for your solution. I am looking to implement it in my chart to fix a similar problem. Can you pls explain how I get the equivalent of First(Fields!YAxisMaxZoom.Value, "CostToDate")? I assume "CostToDate" is a dataset... Looking forward to your response. Regards, Efomie
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2012 12:19pm

Yes, it's the data set. I haven't looked at this for over 2 years so I'm going from memory here, but I think I passed in a maximum "zoom" value (in the example shown, it would be 100,000,000) and then return it back out as a data item (with the same value in every data row). So the data set might be something like Date, HistCostToDate, YAxisMaxZoom, (... other needed fields) Apr 1, 1500, 100000000 Apr 2, 1700, 100000000 Apr 3, 1900, 100000000 etc
June 21st, 2012 1:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics