Hi team,

My requirement is as follows.I have a property Status which will have list of values and it exist on work item.I need to generate a report as follows.

1. 1. Will need to run a volume report by the system at 8:00pm Est and store the file in a  location
2. 2. This report will contain the following information by Workbasket (Team)…
   1. a.       Received: Count any case created today (Today staring from 8:00:01 pm Est. from the previous day to current day ending at 8:00:00 pm Est.) or reopened today) or reopened today and the resolve status not equal to resolve file down or resolved duplicate.
   2. b.      Completed: Count all cases resolved today (Today staring from 8:00:01 pm Est. from the previous day to current day ending at 8:00:00 pm Est.) or reopened today) and the resolved status is not equal to resolve file down or resolved duplicate.
   3. c.       Current Open: Count all “I” (In process) and “P” (Pending) status.
   4. d.      Current DM: Count all other statuses excluding few.
3. Under each section, we will also need a detail breakdown of data containing in each section that contains the following in order…
   1. a.       Case ID
   2. b.      Work Type
   3. c.       Status
   4. d.      Amount
   5. e.      Case Owner

I am thinking of using sub reports.Please help.

Thanks in Advance,

Saba Fathima