JSMITH242B
Programmer
Hi Group,
I am having problems in applying the groupings - (1 by Branch number and the other by Account/Site)- as specified below to a Crystal Report I have.
1a(Branch)
Ethnicity by Branch Number
Count by Branch Number the number of each Ethnic Origin.
Display columns for Branch Number, Ethnic Origin & Count Number.
1b(Branch)
Gender, Disability & Age by Branch Number
Count by Branch Number where column A is “MR”, column A is “MRS”, “MS” or “MISS”, column A not any of the above, column E-Disability is “Yes”, column C-Age is between 16 and 25, column C-Age is between 26 and 35 etc.
Display columns for Branch Number, Male, Female, Unknown, Disabled, 16-25, 26-35, 36-45, 46-55, 56+.
2a(Account/Site)
Ethnicity by Account/Site Number
Count by unique Account & Site Numbers the number of each Ethnic Origin from column D-Ethnicity.
Display columns for Account/Site Number, Ethnic Origin & Count Number.
2b(Account/Site)
Gender, Disability & Age by Account/Site Number
Count by unique Account & Site Numbers where column A is “MR”, column A is “MRS”, “MS” or “MISS”, column A not any of the above, column E-Disability is “Yes”, column C-Age is between 16 and 25, column C-Age is between 26 and 35 etc.
Display columns for Account/Site Number, Male, Female, Unknown, Disabled, 16-25, 26-35, 36-45, 46-55, 56+.
As you can see, from the above description, it is the same information shown but grouped differently.
The groupings are to be a summary of the data that is being returned.
I have the main report with all the data but I can't seem to work out the
groupings for the summary.
Any help appreciated.
TIA
I am having problems in applying the groupings - (1 by Branch number and the other by Account/Site)- as specified below to a Crystal Report I have.
1a(Branch)
Ethnicity by Branch Number
Count by Branch Number the number of each Ethnic Origin.
Display columns for Branch Number, Ethnic Origin & Count Number.
1b(Branch)
Gender, Disability & Age by Branch Number
Count by Branch Number where column A is “MR”, column A is “MRS”, “MS” or “MISS”, column A not any of the above, column E-Disability is “Yes”, column C-Age is between 16 and 25, column C-Age is between 26 and 35 etc.
Display columns for Branch Number, Male, Female, Unknown, Disabled, 16-25, 26-35, 36-45, 46-55, 56+.
2a(Account/Site)
Ethnicity by Account/Site Number
Count by unique Account & Site Numbers the number of each Ethnic Origin from column D-Ethnicity.
Display columns for Account/Site Number, Ethnic Origin & Count Number.
2b(Account/Site)
Gender, Disability & Age by Account/Site Number
Count by unique Account & Site Numbers where column A is “MR”, column A is “MRS”, “MS” or “MISS”, column A not any of the above, column E-Disability is “Yes”, column C-Age is between 16 and 25, column C-Age is between 26 and 35 etc.
Display columns for Account/Site Number, Male, Female, Unknown, Disabled, 16-25, 26-35, 36-45, 46-55, 56+.
As you can see, from the above description, it is the same information shown but grouped differently.
The groupings are to be a summary of the data that is being returned.
I have the main report with all the data but I can't seem to work out the
groupings for the summary.
Any help appreciated.
TIA