I am using BIRT to fetch the data from RTC table "LIVE_WORKITEM_CNT", and generate a table report.
The table has one group column and the value is from a computed column I named it as "Status". (The Status value could be "in process", "Will Do", "Past Due" etc..)
If a task's State Name is "2" (in process), it should be grouped under "in process".
If a non-resolved task's due date is before today, it should be grouped by 'Past Due'.
if a task's State Name is "2" and due date is before date, is should be grouped both by "in Process" and "Past Due". So this task should be displayed twice in one table.
Could you let me know how to implement one task displaying under more than one group?