all groups > sql server reporting services > february 2007 >
You're in the

sql server reporting services

group:

RowNumber Problem in Grouped Data


RowNumber Problem in Grouped Data Visualcpp
2/14/2007 10:51:00 PM
sql server reporting services:
I have multiple (multilevel) groupings in my RDL (based on line level data
from SQL server). While using the RowNumber("GrouName") I am getting strange
results. For example If that grouping was made out of 3 individual lines from
data set, then I am getting Row number as 3.

What I want is irrespective of the no of lines involved in such aggregation,
I want the rownumbers based on the final aggregated line and not based on the
no of detailed lines involved in such groupings.

Any help will be appreciated!

Thanks,
Re: RowNumber Problem in Grouped Data brandon.richter NO[at]SPAM gmail.com
3/11/2007 12:00:00 AM
I get this also. With my groupings, RowNumber behaves identically to
CountRows. I have something that looks like:

Group1
Group 2
Details

Group2 and details are initially hidden so I want to alternate row
colors for the group1 header and footer rows. RowNumber("Group1")
returns the number of rows in that group, not the number of the
group. It's identical to CountRows("Group1").

If you figure out the solution to this, please let me know!

On Feb 15, 1:51 am, Visualcpp <Visual...@discussions.microsoft.com>
[quoted text, click to view]

Re: RowNumber Problem in Grouped Data brandon.richter NO[at]SPAM gmail.com
3/11/2007 8:55:37 AM
I don't know if this is the proper way to get around this, but the
following works correctly. If you happened to have blank or null
group headings this method would not work.

=IIF(RunningValue(Fields!name.Value,CountDistinct,nothing) mod 2,
"Transparent", "LightYellow")

[quoted text, click to view]

AddThis Social Bookmark Button