I need to produce a chart in Crystal Reports XI. I have a set of aggregated data in a table – each row represents the summary values of another temporary table relating to arrivals of files into a folder against a deadline. So I have maybe 50 files that arrive over a 1 hour period and have to be in by, say – 10am. I then aggregate the count of the files in 10-minute blocks and put that into an aggregate table. I now want to simply plot those values in a bar graph – the first few columns are title, date, site, and so on, so for example I have one row that looks like:
BD0001,2007-10-16,10,0,0,15,9,0,0,0,1,4,0,0,6,2,0,0
Anything beyond the deadline is late. I’d like to be able to put in a ‘zero’ line at the deadline time if possible so we can easily see how many files come in at what stage before deadline. I just need to plot the values of the row after the date into a bar graph but it won’t work and I’ve tried almost everything. Should be really easy. Anyone able to help?
