I have a table of data that contains team names. Unfortunately, the management level above teams is not recorded on the database and therefore I have to use a formula to work this out. This formula is called Districts.

 

For info, each of the 12 district has 3 teams.

 

What I would like is to have static cascading parameters on my report that first ask for the district (the formula) and then gives the choice of the 3 teams for the chosen district.

 

Any ideas how this could be done ??

 

Many thanks

 

Chris 

 

I've now setup a table which holds the following: 

team id, team name, district name, area name.

 

When creating my report I link from the main dataset to this new table using the team ID field.

 

I have been able to create the cascading parameters and they work as expected.

 

The only issue I have now is how do I give the user the option of choosing ALL instead of picking a team, district, area from the list. I have seen that the asterix can be used as can the word ALL but I would like to keep the parameter as a drop down list rather than a box where they can type in.

 

Any help greatly appreciated.