Manual Crosstab with Date Columns

[jemsmom]

I'm using Oracle 10 g with Crystal Reports XI

I need to create a manual cross tab (because of printing issues) with a column and header for each date for the previous 10 days. I'm using the following select statement to get the return records for the previous 10 days.

{OR_LOG.SURGERY_DATE} >= CurrentDate-10 and {OR_LOG.SURGERY_DATE}<= CurrentDate - 1

As always any and all help is appreciated.

 

[lbass]

//{@10DaysAgo}:

if {OR_LOG.SURGERY_DATE} = CurrentDate-10 then
1 //for a count or {table.amount} for a quantity, etc.

Place this in the detail section and insert sums (not counts) at the group level and then suppress the detail section.

For the label, use:

//{@10DaysAgoLabel}:
totext(currentdate-10,"MM/dd/yyyy")

etc.

-LB

 

[jemsmom]

That worked perfect. Thank you lbass.