Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping summaries

Status
Not open for further replies.

JSMITH242B

Programmer
Mar 7, 2003
352
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top