Solved

SSRS RunningValue start with a particular row

Posted on 2011-09-19
4
1,016 Views
Last Modified: 2012-05-12
Hi Experts!

I need help figuring out how to configure the RunningValue function to start computing on a particular row.
It should always start accumulating on row 3. Here is my sample data:

ID        MyVal     Running Total            RowNumber
112     10                                           1
112      5                                            1
112      2          2                                1
202      3          5                                2
512      5          10                              3
125      1          11                              4
456      2          13                              5
 
The Row Number column is using the function ROW_NUMBER() -- just incase it's needed.

I tried different styles like:
=IIF(Fields!RowNum.Value = 1, "",RunningValue(Fields!MyVal.Value,SUM,NOTHING))

But it is still computing from the first row, it is just hidding those rows visually.

Thanks!
0
Comment
Question by:faiga16
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 18

Expert Comment

by:lludden
ID: 36564343
make a hidden column and then sum that column.

IIF(Fields!RowNum.Value = 1,0,Fields!RowNum.Value))
0
 
LVL 9

Accepted Solution

by:
mimran18 earned 500 total points
ID: 36564922
Hi,
   It will give you the running total after row 3 not from 1st row.

=RunningValue(iif(Fields!RowNum.Value >3, CDbl(Fields!MyVal.Value), CDbl(0)), Sum, Nothing)

Cheers
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36565261
0
 
LVL 15

Author Closing Comment

by:faiga16
ID: 36567752
This works! I just had to change the RowNum value (of the 3rd 1s), so the RowNum looks like:

1
1
2
2
3
4
5

Thank you!
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question