Formula Will Not Display in Header

[LZido]

I have a formula that will not work in the Report Header but will work in Details.
I created a formula to add a day to a parameter date {?Start Date}+1. I did this for 7 days. I then wrote a formula to give me the total hours based on type of hours for each day.

First formula: This is based on just the start date parameter without adding +1.
if {Coverage.TYPEOFHOURS} = "ON DUTY CREW" and
{Coverage.DATEIN} = {?Start Date} then {@TotalHours}

Second formula: this is same as above but using Start date parameter +1.
if {Coverage.TYPEOFHOURS} = "ON DUTY CREW" and
{Coverage.DATEIN} = ({?Start Date}+1) then {@TotalHours}

The first formula works in both the Detail section and the Report Header. The second formula will only work in the Detail section. When I place it in the header I get 0.00 instead of 24.00.

Any solutions?

 

[HowardHammerman]

I bet you have sorted & grouped your data by {coverage.datein}. The first formula works because you are looking at the first date when processing the report header. When processing the first record {Coverage.DATEIN} = ({?Start Date}+1) will be false. You did not provide an "else" part of your If statement so Crystal gave you what you asked for: A blank.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support

http://www.hammerman.com