Hi Everybody,
I have 3 groups in a crystal 8.5 report as YEAR, AREA, MEMBER. I have to display following results:
1. All the REGIONS with their MEMBERS for a given YEAR
2. All the MEMBERS for a given AREA for a given YEAR
3. Particular MEMBER for a given AREA for a given YEAR
My following formula achieves first 2 results from above but fails to get third result.
If {?Area} = "ALL"
then GroupName ({sum.Year1}) = {?Year}
else if {sum.Area}={?Area} and {?Member} <> "ALL"
then GroupName ({sum.Name})={?Member}
else if {?Member} <> "ALL" then
GroupName ({sum.Area})={?Area}
I slogged on it for a long time but could not do it. Can someone help me on it?
I have 3 groups in a crystal 8.5 report as YEAR, AREA, MEMBER. I have to display following results:
1. All the REGIONS with their MEMBERS for a given YEAR
2. All the MEMBERS for a given AREA for a given YEAR
3. Particular MEMBER for a given AREA for a given YEAR
My following formula achieves first 2 results from above but fails to get third result.
If {?Area} = "ALL"
then GroupName ({sum.Year1}) = {?Year}
else if {sum.Area}={?Area} and {?Member} <> "ALL"
then GroupName ({sum.Name})={?Member}
else if {?Member} <> "ALL" then
GroupName ({sum.Area})={?Area}
I slogged on it for a long time but could not do it. Can someone help me on it?