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 |
|
rvaraganti
Starting Member
22 Posts |
 Posted - 2009-01-18 : 05:04:45
|
| Hi,We have a requirement to show cumulative sales across selected time hierarchy using Line Graph. (SSRS 2005)For Ex: If I want to see sales for Year 2008 on Weekly basis. X-Axis shows all the 52 weeks and Y-Axis shows the Sales Amount. We are using RunningValue Funtion to get the cumulative Sales and implemented Page Break in order to show 12 weeks per page. Now, the problem is for each new page, Running Value resets to 0(Zero). We do not want to reset the running value across the complete data set.We tried to use RunningValue function in following ways but it didn't worked.RunningValue(Fieldname,Sum,DataSetName) or RunningValue(Fieldname,Sum,Nothing) encountered following error :"The DataPoint expression for the chart ‘XAxis’ has a scope parameter that is not valid for RunningValue, RowNumber or Previous. The scope parameter must be set to a string constant that is equal to the name of a containing group within the matrix ‘XAxis’"Please provide your suggestions. Thanks,Rachitha. |
|
|
|
|
|
Running Value resets for each page