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 it goes...just use this in the row you want to rumber (summary or detailed) =RunningValue(Fields!FieldNumber1.Value,CountDistinct,Nothing)
Free Windows Admin Tool Kit Click here and download it now
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......
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
March 19th, 2009 9:58am

Thank You
November 28th, 2010 5:33am

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

Other recent topics Other recent topics