Dynamic grouping in acutate

[Chris Dale]

Hello
I am working with actuate on siebel and will like to dynamically prompt the user with two input boxes to base the sort criteria of the report on. For example the
Prompt 1 Select primary grouping (Class, family, Model, or Product)
Prompt 2 Select secodary grouping(Area, Sub-Area or Res-Code)
So the second group will be subgrouping under the first. I have gotten the first one to work but the second grouping is not. It just displays one record even though there are multiple records. Can someone please let me know how this can be accomplished?
Thanks
Chris
Princenoo@yahoo.com

 

[Chris Dale]

Update on dynamic grouping

I have figured out what I was doing wrong.
In the datrow I declared two variables that the compare method was using as
Storage = Static,
Visibility = Public
Type = Variant
I change the declaration to
Storage = Instance
Visibility = Private
Type = String
After this I change the compare method of the memorysorter to
Dim Rw1 As ssService_RequestDataRow1
Dim Rw2 As ssService_RequestDataRow1
Set Rw1 = row1
Set Rw2 = row2
Compare = CompareKeys(Rw1.GroupField,Rw2.GroupField)
If Compare = 0 Then
Compare = CompareKeys(Rw1.GroupField1,Rw2.GroupField1)
End If
With these changes the dynamic grouping worked.