Conditional for Hidden Visibility Property works in SSRS 2005 but not working in SSRS 2008

i have custom code this:

name         age        # of hobbies         hobbies

steve          19                   1                   baseball
steve          19                   2                   baseball, basketball
steve          19                   3                   baseball, basketball, football

i have in grouping within grouping. , in hidden visibility property have following conditional:

=iif(rownumber(“table1_group2″) = countrows(“table1_group2″), false, true)

this worked in ssrs 2005 it’s displaying info weird in ssrs 2008. end result display last row , hide previous ones. result of conditional in ssrs 2008 this:

name         age        # of hobbies         hobbies

steve           19                3                    football

here screenshots.

                

please help. thank you!

apologize if i've posted in wrong section. first post.

hi sto0bin,

in reporting services, rownumber function returns running count of rows in specified scope, while countrows function returns number of rows in specified scope, including rows null values. in reporting services 2008 , later versions, when rownumber function placed in details row, value returns changes growth of details group. rownumber returns set of results when works in details row. martina has posted above, can clarify issue adding 2 columns , placing rownumber , countrows functions in details row of columns. screenshot below shows comparison , can find reason why last record visible in scenario.

work around issue, can place rownumber function in textbox outside details group scope (for example, upper right corner textbox in screenshot) , control visibility of details group using expression like:
=iif(countrows("group1")=reportitems!textbox20.value, false, true)

if textbox20 within newly added column, can hide column , doesn’t affect conditional visibility configuration.

reference:
rownumber function

if have questions, please feel free let me know.   

regards,
mike yin

 

SQL Server  >  SQL Server Reporting Services, Power View