Hours by Day 1

[YANKRAY]

Using CR10.

I am trying to create a result that will show how many hours have been scheduled for a given day using the Project Start Date and Project Finish Date as the Date Range.

For example:

The Project Starts on 3 Feb 2009. The Project Finishes on 26 Aug 2009.

There are multiple work orders to be accomplished during this time frame that are scheduled throughout the Project.

Work Order Start Finish Hours per Day
WO01 03 Feb 06 Feb 20
WO02 09 Feb 29 Feb 6
WO03 02 Mar 12 Mar 12
WO04 03 Feb 26 Aug 15
WO05 09 Apr 12 Jul 20
WO06 25 Jul 26 Aug 10

For the result I am looking for the Project Start Date through the Project Finish Date range by day with the hours required for that day based on the Work Order Flow Dates.

Each date in the date range should be visible in the result even if there are no hours calculated for that day.

This can either go across or down the page (whichever is easier to create).

Thanks,
Ray

 

[Madawc]

Grouping or a crosstab could show you hours per day, but only for days when there were hours booked. One way round is to link the hours booked to something else, a table of dates or else something that occurs for every day.

If you can't find or add a table, you'll be stuck with creating a 'Mock Crosstab'. Crosstabs are fine if you don't mind the absence of rows or columns with no data, but you said you wanted empty slots to show.

A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back.

Each running total will count the record if it was within the criteria - in your case, date.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP