Include dates with no records

[mulliganradio]

I am creating a report that selects employee time between a range of dates. I want all days to show even if the employee only works 5 days:

Example

Mon - 8 hours
Tues - 8 Hours
Wed - 8 Hours
Thur - 8 Hours
Fri - 8 Hours
Sat - Off
Sun - Off

Currently it only shows days with hours as those are the only dates in the veiw but I would like to add the last 2 days in the date range as Off or Zero Hours.

Any help is GREATLY appreciated!!

 

[Thadeus]

Sounds like you could do this with seven formulas incorporating an If isnull({field} type coding...

~Thadeus

 

[mulliganradio]

I thought about doing that but the range of dates may not always be 7 days. It may be 2 days or 2 weeks. It all depends on the parameters that the manager picks ?from timeframe and ?to timeframe

 

[Thadeus]

I think it's time for you to reveal more about how your data is stored in your DB (ie. I have a numeric field that stores a number of hours and a date field that stores the date the hours were worked, One record per date, etc)

Secondly, and as importantly, you need to explain how to display the data.

Third, If there are variations from what you lay out above, let us know upfront.

Thanks,
~Thadeus

 

[crystalreporting]

Can you create a table with a full calendar of days in it i.e. one record for each day?

Peter Shirley

http://www.linkcorp.com