Skip to Content
0
Former Member
Apr 28, 2009 at 05:42 PM

How do I add one record to 2 groups/sections?

20 Views

I have a request to create a report that is grouped in such a way that one record can be in more than one group.

The criteria is like this:

Group1: If Submit Date > (Today - 5)

Group2: If Status = "In Progress" and Type <> "Ongoing"

Group3: If Status <> "Closed" and Type = "Ongoing"

Group4: If Status = "Closed"

Each group would display the same detail record info: ticket#, Status, submit date, priority.....

Technically a record submitted in the last 5 days could be in Group 1 and one of the other 3 groups.

Also a ticket submitted move than 5 days ago could be in more than one group.

Is there a way to do this so that a record can display it's detailed info in more than one group?