I am very new to Crystal Reports (only a couple of months) and I am trying to create a report that is presenting a scenario that I don’t quite know where to begin.
I am using Crystal Reports XI and in my database I have a table {REQUEST} and within this table I have 4 date fields (DateTimeInit, DateSubmitTo, DateComplete and DateTimeClosed). I am trying to create a comparison report (with a chart) to reflect how many service requests were initiated during a date range (regardless of completion date) and how many service requests were completed during the same date range (regardless of the initiated date). What I have found is by creating an initiated start date and initiated end date parameter fields as well as creating a completed start date and completed end date parameter fields, they work together as an “AND” statement. This results in service requests that were initiated AND completed during the date range. I need the report to show ALL service requests that were initiated during the date range as well as ALL service requests that were completed within the same date range. Is this something that can be accomplished within Crystal Reports or will I have to use something like SQL Developer to create a “View” for my database?
Any help would be greatly appreciated. Thank you.

I am using one table and within this table I will use the PROBLEMCODE field for group one (there are 4 problem codes that I need in the final chart), and I will use the DISPATCHTO field as group two (there are several employees that need to be in the final chart). I will use the DATETIMEINIT field in the details of the report (I would like this to be a parameter field that can be changed upon refreshing), and I will use the DATEDISPATCHTO field in the details of the report (I am thinking this needs to be another parameter field, although it will be the same dates as the DATETIMEINIT parameter fields). I will also use the REQUESTID field in the details (this is just the service request number, and will only be used in reference to answer any questions that arise).
The problem is that I need the two different date fields to be independent of each other, because we can have a service request that can be initiated within the date range but not completed within the date range and we can have a completed service request that is within the date range but may not have been initiated within the date range.
The end product that I would like to see is a bar graph that depicts the employees on the X-axis and each employee would have two bars (initiated and completed) and each bar would have 4 sections to it (the problem codes) with the values. I would also like to see a small summary of each employee and the average time (in days:hours:minutes format) that it took the employee to complete the four types of problem codes.
I hope this makes more sense.
Thank you for your previous response.