Secretgeek
Technical User
Good afternoon,
Am using CRXI and am trying to construct a report that identifies how many records were 'open' at a particular historical point in time.
I.e. I have 6500 records each with a separate closed date, I need my report to say x number of cases were open in this particular month. I understand that this would in some form require something like Count (Month([Closed Date])> Month([Group])) followed by a summary field.
What I'm tying myself up with just how to do this. I need Crystal to say 'here is the month I'm checking was this record open in this month?'.
Any help much appreciated.
Thanks in advance.
Am using CRXI and am trying to construct a report that identifies how many records were 'open' at a particular historical point in time.
I.e. I have 6500 records each with a separate closed date, I need my report to say x number of cases were open in this particular month. I understand that this would in some form require something like Count (Month([Closed Date])> Month([Group])) followed by a summary field.
What I'm tying myself up with just how to do this. I need Crystal to say 'here is the month I'm checking was this record open in this month?'.
Any help much appreciated.
Thanks in advance.