Hi Guys,

This seems like a pretty simple thing to do but cannot seem to figure it out.... I have a report that shows the following criteria:

1) Creation Date
2) Update Date
3) Resolution Date

What I want to do now is to count the number of dates in each section. I am expecting to need to 'group' by date but that then throws everything out; for example if I group by 'Creation Date' then the Update/Resolution dates could be wrong as they could have been updated on a different day to the creation.

I am trying to avoid subreports if possible.

Hi DBlank,

Sorry; let me try to explain a little better/more comprehensively.

I am reporting on Incidents and am trying to create a report, broken down by Day, which show the number of Incidents Raised/Updated/Closed.

To Group the Incidents I obviously need a date field (e.g. the Raised Date) but if this is used I cannot then count the number that are Updated/Closed.

Consider the following Example...

raw data

Ref - Create Date - Update Date - Resolve Date
1   - 01/01/14    - 01/01/15    - 01/01/15
2   - 03/01/15    - 03/01/15    - 03/01/15
3   - 05/01/15    - 05/01/15    - 06/01/15
4   - 06/01/15    - 07/01/15    - 08/01/15

If I were to then group on Date (Create Date) then I would effectively lose references 3 and 4 from the update/resolved dates.

Hopefully that makes a bit more sense?

I haven't actually - I will have to look up the syntax for a Union query as I'm not 100% sure what some of the above refers to :-)

thank you.