Forum Discussion

Grantx's avatar
Grantx
Frequent Visitor
2 years ago
Solved

Report builder - count grouped items

In my report, each person is grouped because they could have more than one address. How do I count the number of grouped results so that I can specify postcode1, postcode2, postcode3 etc...?   Thi...
"Report Builder"
  • d_gosbell's avatar
    d_gosbell
    2 years ago

    You can use the RowNumber() function passing in the name of the parent group. So if your group is called "Fullname" you could change the postcode to an expression like

     

    = Fields!Postcode.Value & RowNumber("Fullname)

d_gosbell's avatar
d_gosbell
Super User
2 years ago

You can use the RowNumber() function passing in the name of the parent group. So if your group is called "Fullname" you could change the postcode to an expression like

 

= Fields!Postcode.Value & RowNumber("Fullname)