Hi
I am using CR v9 and accessing a foxpro database via an ODBC connection.
I am trying to show how many months are due til next training requirement and have been successful in showing up to three months using the following formular :-
If sum ({@PAS11A1/Aout},{people.companyref}) >=1 then "T" else
if Maximum ({@PAS11A1/Arenewaldate},{people.companyref}) in Next30Days then "1" else
if Maximum ({@PAS11A1/Arenewaldate},{people.companyref}) in Next31to60Days then "2" else
if Maximum ({@PAS11A1/Arenewaldate},{people.companyref}) in Next61to90Days then "3" else
if Maximum ({@PAS11A1/Arenewaldate},{people.companyref}) in Alldatesfromtoday then "*" else
"X"
How can I add to this to show "4" "5" etc to "12" months countdown, i.e. 91 to 120 days then "4" etc.
Thanks
Fred
I am using CR v9 and accessing a foxpro database via an ODBC connection.
I am trying to show how many months are due til next training requirement and have been successful in showing up to three months using the following formular :-
If sum ({@PAS11A1/Aout},{people.companyref}) >=1 then "T" else
if Maximum ({@PAS11A1/Arenewaldate},{people.companyref}) in Next30Days then "1" else
if Maximum ({@PAS11A1/Arenewaldate},{people.companyref}) in Next31to60Days then "2" else
if Maximum ({@PAS11A1/Arenewaldate},{people.companyref}) in Next61to90Days then "3" else
if Maximum ({@PAS11A1/Arenewaldate},{people.companyref}) in Alldatesfromtoday then "*" else
"X"
How can I add to this to show "4" "5" etc to "12" months countdown, i.e. 91 to 120 days then "4" etc.
Thanks
Fred