Grouping by a value that represents the parent ?? RRS feed

  • Question

  • Hi,


    Creating a report and my dataset has a userid and parentuserid fields.

    I'd like to list the users who belong to a parent user, with the parent on top of the list.

    So, for the table below:

    uid   pid   user

    1      10   user1

    2      1     user2

    3      1     user3


    How would I do the grouping in the report by pid and show user1 at the top of the list??

    -Björn Türoque
    Tuesday, April 27, 2010 11:48 PM