Hi
I have two column in my reports one is projects and other is capital , there are 59494 rows for the project column and corrosponding rows for capital too, I want to show all the project as a group lets say under “other project” name so there will be one row for projects because they all come under that “other project” i tried group function but it doesnt work after certain number of rows…i m using 5.1.8… :?
amdel61 
(BOB member since 2004-07-14)
I’m not sure I understand, but I think you want to group like data.
Rather than use the group values function, why don’t you use If then logic? For example,
If product InList (…) then “x” else if…
There are limits to this as well. BO won’t let you have local variables that are 15 pages long. (Please note, I have never counted the pages, nor do I intend too!).
I did however build a list off of 2500 names or so (5.1.3). If you have more than this, I suggest you look into the Match function.
Hope this helps.
SteveBickerton 
(BOB member since 2002-08-15)
thanx for your reply… i am not sorting the project names or anything just want to display a bunch of projects under one field or row which can be any name and total capital associated nect to that column which is sum of all projects
amdel61 (BOB member since 2004-07-14)