Need scope for RowNumber( ) function
HI ... I have a detailed report ..with summary lines and detailed lines (drill down). I have a column with a function "RowNumber(Nothing)" which is supposed to just count the rows when I put this in the summary row for the column I need in the Design Layout section and run the report, I get numbers on the summary lines which include the number of rows in the level below (detailed rows). I just want to number the summary rows sequentially without taking into consideration, the number of detailed rows. How do I modify RowNumber(Nothing) to exclude counting the detailed rows....??? Any help will be much appreciated...thanks
November 1st, 2006 8:27pm
To the folks who might face this problem I found the solution myself .....here it goes...just use this in the row you want to rumber (summary or detailed) =RunningValue(Fields!FieldNumber1.Value,CountDistinct,Nothing)
November 8th, 2006 7:23pm
This was exactly what I was looking for thank you very much, you have been a great help
August 1st, 2007 4:56pm
Excellent!! Thank you, I have looked every where for this......
August 7th, 2007 5:19am
Hi, Great Work Buddy, i too myself wandering on RowNumber() but it is inefficient when one wants to display row numbers based on group. Your technique is good, i too myself went with RunningValue() but unable to get desired result as i was giving the group name in scope and Count as function, now as in your example by giving Nothing in Scopeand CountDistinct in function it does the work.
June 19th, 2008 2:15pm
"=RunningValue(Fields!FieldNumber1.Value,CountDistinct,Nothing)"it 's great! it gived me great help.Thank you .Aikon
March 19th, 2009 9:58am
November 28th, 2010 5:33am