I am looking for the best way to who In vs Out as a Chart or CrossTab in Crystal Reports based on Date.
Each record has three columns. Request ID, Date Created, Date Closed. Request ID is a integer and both dates are Date Time.
The problem I am having is showing this neatly in one Chart or Cross Tab. Below is an example of how I'm looking for the cross tab to look likeJan 2014 Feb 2014 Mar 2014 Apr 2014 Jun 2014 In 7 6 5 8 9 Out 9 8 5 6 7
Being able to show the difference would be create as well.