Hello!
Some background:
I am creating a report that summarizes market distribution data for various population groups either by the population's age or by chronological date. Not all population groups can be represented by both age or date, that is, certain groups can be represented by age, but not date, and vice-versa, and some groups can be represented by both. We have a database table that contains the information that lists the population groups and its possible representations. See the table drawn below for an example.
The input requirements for this report are as follows:
1. The user first chooses a population group from a drop down list
2. Then based on the specific population, the user is prompted to choose the representation (age or date - for some population one or both choices may be available)
3. If Date representation is chosen, the user is prompted for a date range and three other additional prompts (like product type, sub-type, location etc.)
4. If Age representation is chosen, the user is only prompted for the three additional prompts (like product type, sub-type, location etc.) - and *no* date range
5. User clicks Run to generate the report.
I can create a prompt that dynamically loads the populations form the database table. Then I can use the dependencies to create the prompts on the second requirement that prompts the user to choose the representation. If population_1 is chosen, the user only gets to choose Age. If population_2 is chosen, the the user get to choose either Age or Date, and so on and so forth. However, I am stuck on requirement 3. That is if the user chooses Date representation, I have not been able to figure out how to prompt for a date range based on the answer from step 2! That is, prompt for a date range only if the user chooses a date representation for populations population_2, population_3 or population_4, but leave out the date range prompt if the user chooses Age representation on a population.
Help!
Am I thinking about this incorrectly? Is this possible to accomplish this in a Stored Process using Enterprise Guide?
Sample of a table we have in the database.
POPULATION_REPRESENT
| population_group | population_represent_type |
|---|
| population_1 | Age |
| population_2 | Age |
| population_2 | Date |
| population_3 | Date |
| population_4 | Age |
| populations_4 | Date |
Here is what I can do: I can manually group the prompts for each population. This I would like to avoid since we have over 15 different types of population groups. But really hoping to use the database tables to dynamically accomplish this!
Thanks!
