Finding the next 8 weeks 2

[jemsmom]

I'm using Crystal 10 with Oracle 10 g.

I need my report to select records with dates in the next 2 weeks, Sunday - Saturday. I then need a column with the total number of cases scheduled for each of those 2 weeks.


Surgeon 9/27-10/3 10/4/ to 10/10
----------------------------------------------------
Jones 25 32

Any help would be appreciated. Thank you.

 

[lbass]

Use a record selection formula like this:

{table.date} in currentdate-dayofweek(currentdate)+8 to
currentdate-dayofweek(currentdate)+21

Then insert a crosstab that uses {table.date} as the column->group options->print on change of week. Use surgeon as the row field, and count of cases as the summary.

-LB