Hessel de Walle's Blog

The other day I discussed the solution for this problem in Report Builder / Reporting Services. A couple of days later I got the same question for Crystal Reports. Somebody wanted his report to look like this: In the example I am showing Customers and Order numbers from the Noordenwind database, the Dutch equivalent to the Northwind database. How can we get this result? I created a report grouped on Klanten.Bedrijf . In the group header I put the formula field orderreset : shared stringvar ordercollect:="";  In the detail section I put the formula field ordercollect : shared stringvar ordercollect; ordercollect:=ordercollect & totext({Orders.Order-id},"00000") & ", "; In the group footer I put first of all the group name field Klanten.Bedrijf  and next to it the formula field orderprint : shared stringvar ordercollect; left(ordercollect,instrrev(ordercollect,",")-1) Finally, I suppressed the details and the group hea...