Help with Date problem ASAP Please

[MrHelpMe]

Hello,
I have grouped a date field by week. The report contains 2 parameters, start and end date. Whatever range I choose, I want the report to display the Friday for each week in the report since our work week is mon - friday. However, my report is displaying the Sat when I say in the group preferences to show last date in period as the value to be displayed. How will I get the report to print the friday for each week within the range instead of the Saturday. Thanks guys.

 

[synapsevampire]

A quick cheat might be to create a formula to adjust it back a day:

cdate(GroupName ({table.Order Date}, "weekly&quot)-1

-k

 

[MrHelpMe]

Thanks for the reply Synapsevampire. However, when I try and put that this formula in the crosstab it does not show up as a selection choice. It removes the formula. Yet I can place in the details of the report and it works. However, I need it in the crosstab. Your help is greatly appreciated again. Thanks.

 

[synapsevampire]

Consider posting your environment, there was no mention of a Cross-Tab before...

Please provide Crystal version, database version, example data and expected output.

-k

 

[MrHelpMe]

Sorry Synapsevampire. You are correct.
K I need this formula to work in a crosstab. I am using crystal reports 8.0. Depending on what daterange the user selects, I need the report to return all the Fridays and there associated values in the report. So basically the report will look as follows: Thanks
Date Range Selected
April 14-25, 2003

4/18/2003 4/25/2003
Process Quality Total Process Quality Total
Buys 16 27 43 2 1 3
NonFinancial 8 10 18 4 5 9
Sells 10 5 15 12 8 20
Switches 12 8 20 3 5 8