Group header name not appearing on my report

[tazibc]

Dear all I have created a formula such as:-
if {Weekday_Hub_Data.Failed Connections, Explanation}="Saturday Collections No Sunday service" then "Controlled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Trunk Overload" then "Controlled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Loading Error" then "Controlled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Human error sort to incorrect point" then "Controlled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Vehicle Late Breakdown at Hub" then "Controlled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Vehicle Late Breakdown at Service Centre" then "Controlled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Volumes Inbound" then "Controlled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Volumes Outbound" then "Controlled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Break Down" then "Uncontrolled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Vehicle Late (No Reason Given)" then "Uncontrolled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Vehicle Late Breakdown on Route" then "Uncontrolled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Vehicle Late Congestion" then "Uncontrolled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Vehicle Late Diversion" then "Uncontrolled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Vehicle Late in Road Works" then "Uncontrolled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Vehicle Late RTA Diversion" then "Uncontrolled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Weather Conditions" then "Uncontrolled" else
if {Weekday_Hub_Data.Failed Connections, Explanation}="Major Accident" then "Uncontrolled" ;

The word controlled and uncontrolled do not appear on my report could it be that no one has filled in the explanation in the data base or could it be a report issue pls help

 

[CR85user]

//Check for nulls / blanks first
if isnull({Weekday_Hub_Data.Failed Connections, Explanation}) or {Weekday_Hub_Data.Failed Connections, Explanation} = '' then 'Blank Entry' else

//Check for controlled
if {Weekday_Hub_Data.Failed Connections, Explanation} in ["Saturday Collections No Sunday service","Trunk Overload","Loading Error","Human error sort to incorrect point","Vehicle Late Breakdown at Hub","Vehicle Late Breakdown at Service Centre","Volumes Inbound","Volumes Outbound"] then "Controlled"
else

//Check for uncontrolled
if {Weekday_Hub_Data.Failed Connections, Explanation}in ["Break Down","Vehicle Late (No Reason Given)","Vehicle Late Breakdown on Route","Vehicle Late Congestion","Vehicle Late Diversion","Vehicle Late in Road Works","Vehicle Late RTA Diversion","Weather Conditions","Major Accident"] then "Uncontrolled"
else

//If non of the above match then list the cause
"Other category - " & {Weekday_Hub_Data.Failed Connections, Explanation}

Is the field name correct? Are you linking the tables correctly? (If any linked) Can you see the rows that this formula willl relate to?

'J

CR8.5 / CRXI - Discovering the impossible

 

[lbass]

Place your database field on the details section and observe how it displays--does it display all in upper case for example? Or could there be leading spaces?

-LB