Mutli-value items and grouping in report control

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi,

is it possible to have "multi-value" items in report control and use them for grouping?

Example:
The ReportControl displays a list of users. Each user can belong to x groups.
The user is a report record and has two items, "name" and "groups".

An example without grouping would look like this:
"User 1" "Group 1, Group 2"
"User 2" "Group 1"
"User 3" "Group 2"

After grouping by "groups", it should look like this:
"Group 1"
 -- "User 1"
 -- "User 2"
"Group 2"
 -- "User 1"
 -- "User 3"

Is this possible and if yes, how can it be done?

Ingo.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ingo Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 10 March 2006 Location: Germany Status: Offline Points: 7	Post Options Post Reply Quote ingo Report Post Thanks(0) Quote Reply Topic: Mutli-value items and grouping in report control Posted: 04 March 2010 at 6:57am
	Hi, is it possible to have "multi-value" items in report control and use them for grouping? Example: The ReportControl displays a list of users. Each user can belong to x groups. The user is a report record and has two items, "name" and "groups". An example without grouping would look like this: "User 1" "Group 1, Group 2" "User 2" "Group 1" "User 3" "Group 2" After grouping by "groups", it should look like this: "Group 1" -- "User 1" -- "User 2" "Group 2" -- "User 1" -- "User 3" Is this possible and if yes, how can it be done? Ingo.