markchimes
IS-IT--Management
I am attempting to produce a cross-tab report from a membership DBF file that counts the number of members that are Inactive belonging to a particular District for a particular Financial Year that do not have Mail Status Flags of 'D' or 'T'.
When using the Crystal Report Expert and selecting the includes and excludes from the Select Tab, the formula that is produced does not return any records.
I have checked the formula with a separate application which returns the correct number of members (ie: 123).
I notice that when I click Preview or refresh the report data, Crystal only counts through the number of records that match the District selected (eg: 9,000 for District A, 12,000 for District S, etc). If I remove the District variable from the criteria in the formula, Crystal will count through the whole DBF file. The DBF file contains approximately 80,000 records.
The formula produced by the Report Expert is:
{MEMBERS.TAG} = "I" and
not {MEMBERS.MAILFLAG} in ["D", "T"] and
{MEMBERS.DISTRICT} = {?DistrictCode} and
{MEMBERS.FINANCIAL} = {?FinancialYear}
If I modify this formula to include parenthesis, no difference is made.
eg:
({MEMBERS.TAG} = "I" and not ({MEMBERS.MAILFLAG} in ["D", "T"])) and
({MEMBERS.DISTRICT} = {?DistrictCode} and {MEMBERS.FINANCIAL} = {?FinancialYear})
Thanks for your help.
cheers,
Mark Chimes
When using the Crystal Report Expert and selecting the includes and excludes from the Select Tab, the formula that is produced does not return any records.
I have checked the formula with a separate application which returns the correct number of members (ie: 123).
I notice that when I click Preview or refresh the report data, Crystal only counts through the number of records that match the District selected (eg: 9,000 for District A, 12,000 for District S, etc). If I remove the District variable from the criteria in the formula, Crystal will count through the whole DBF file. The DBF file contains approximately 80,000 records.
The formula produced by the Report Expert is:
{MEMBERS.TAG} = "I" and
not {MEMBERS.MAILFLAG} in ["D", "T"] and
{MEMBERS.DISTRICT} = {?DistrictCode} and
{MEMBERS.FINANCIAL} = {?FinancialYear}
If I modify this formula to include parenthesis, no difference is made.
eg:
({MEMBERS.TAG} = "I" and not ({MEMBERS.MAILFLAG} in ["D", "T"])) and
({MEMBERS.DISTRICT} = {?DistrictCode} and {MEMBERS.FINANCIAL} = {?FinancialYear})
Thanks for your help.
cheers,
Mark Chimes