Client has home sale data (one row per sale) that falls into the following hierarchy of location:
County - the highest level - made up of several wide areas.
Wide Area - a region within the county - this is a three digit number ending with 0 - example 120.
Area - this is a sub-set of Wide Area - three digit number where the first two digits are the same as the wide area, but the last digit is different - examples 121, 122, 123.
Sub-area - this is a sub-set of Area. Three digit number that matches the area, with an alpha character added at the end - example 121A, 121B, 121C.
Sub-division - This is a sub-set of sub-area. Will be the name of a subdivision in that area.
The raw data will be structured like this:
Sale address
Sale Sub-Area
Sale Sub-division
Sale Price
The raw data will not contain a field for Area, Wide Area, or County. Area and Wide Area can easily be determined from the Sub-Area field. County will have to be built manually by combining wide areas, as nothing in the sub-area field tells us what county it is.
When the report is run, the user wants parameters to choose what data to report. He may want to report on an entire county (all wide areas, areas, sub areas and subdivisions), just one wide area, just one area, multiple sub-areas, or multiple-subdivisions.
I am trying to determine the best way to let him choose what he wants. If he selects County, Wide ARea, or Area, the rest of the choices are irrelevant. If he selects Sub-Area or sub-divsion, he may want to select one or several.
I haven't used Dynamic or Cascading parameters in Crystal XI, but I think that may be the way to go. Anybody have a good high-level vision for me of how to structure this?
County - the highest level - made up of several wide areas.
Wide Area - a region within the county - this is a three digit number ending with 0 - example 120.
Area - this is a sub-set of Wide Area - three digit number where the first two digits are the same as the wide area, but the last digit is different - examples 121, 122, 123.
Sub-area - this is a sub-set of Area. Three digit number that matches the area, with an alpha character added at the end - example 121A, 121B, 121C.
Sub-division - This is a sub-set of sub-area. Will be the name of a subdivision in that area.
The raw data will be structured like this:
Sale address
Sale Sub-Area
Sale Sub-division
Sale Price
The raw data will not contain a field for Area, Wide Area, or County. Area and Wide Area can easily be determined from the Sub-Area field. County will have to be built manually by combining wide areas, as nothing in the sub-area field tells us what county it is.
When the report is run, the user wants parameters to choose what data to report. He may want to report on an entire county (all wide areas, areas, sub areas and subdivisions), just one wide area, just one area, multiple sub-areas, or multiple-subdivisions.
I am trying to determine the best way to let him choose what he wants. If he selects County, Wide ARea, or Area, the rest of the choices are irrelevant. If he selects Sub-Area or sub-divsion, he may want to select one or several.
I haven't used Dynamic or Cascading parameters in Crystal XI, but I think that may be the way to go. Anybody have a good high-level vision for me of how to structure this?