Create Parameter on a Named Group

[jazbar]

Hi All
I'm using CRXI over an AS400 database.
I have created a report based on customer addresses and have split the customer details into regions based upon their post code details.

I've done this by grouping on the postcode and then in Group Expert chosen to group in Specified Order. I've then created Named Groups e.g. Scotland, North East, North West, Wales, etc, and associated each postcode area with it's relevant Named Group. e.g. for the Scotland Named Group I've done "Postcode is like EH*" and repeated this for each postcode area.

What I now want to do is create a parameter that the user will use to select a region and the report will only return those records associated with one of the Named Groups, e.g. Scotland, North East, North West, Wales, etc.

I've created the parameter as Static and added the name of each region into the Value section of the Edit Parameter box, but how do I associate the parameter to the Named Group so it only pulls data for that one region?

Any help you can offer will be greatly appreciated.

Thanks in advance.

 

[lbass]

Use a record selection formula like:

(
select {?region}
case "Scotland" : {table.postcode} like "EH*"
case "England" : {table.postcode} like "Whatever*" //etc.
)

-LB