First off, you must have all of the dates you want in your report available in the database. If they're not in the database, there's no way to to show them all on the report.

I usually do this with a "Calendar" table, that has all of the dates, an indicator on whether the date is a weekend, and a few other pieces of information. I then make the calendar table the "master" table for the report and left join from it to a date field in the data (or to a SQL expression that will truncate the time off of the date field).

You then use the date field from the calendar table when you want to show the date - because of the left join, it will show all of the dates in the selected time period.

In the Cross-Tab you use the date field from the calendar table as the columns. I think that initially this will show one date for every week. Once the cross-tab is set up, right-click on the date field in it and select "Column Options" and then "Group Options". Set "This column will be printed" to "for each day" to get all of the days.

-Dell