Because this is in the report header, I would do this as a subreport that will connect to the table that contains the table that has the location description.  The subreport will have the same parameter as the main report.  Inside the subreport, you'll have something like the following formula:

 

Shared StringVar descripts;

If "ALL" in {?location} then descripts := "All Locations"

else

  If OnFirstRecord descripts := {LOCATION.DESCRIPTION}

  else descripts := descripts + ", " + {LOCATION.DESCRIPTION};

descripts

 

Suppress all sections of the subreport except a Report Footer section.  Then place this formula in the (suppressed) details section of the subreport.

 

Create a second formula for displaying the descriptions in the Report Footer.  It will look like this:

 

Shared StringVar descripts

 

This will then display either "All Locations" or a comma-delimited list of the selected location descriptions.

 

There are two reasons why you need a subreport for this:

 

1.  In the main report, you can't concatenate data like you want to do and have it show in the Report Header which processes prior to the report data.

 

2.  If there are any selected locations that do NOT have data in the main report, you still want to show the location as having been selected.  The only way to do this is through a separate query.

 

-Dell

 

I have completed what you have advised:

 

1. in the subreport I have got two tables which show me:

 

code     Head (location description)

 

1          xyz

2          xxx

3          abc

...

...

 

the codes and description have all I  need

2. I created same parameter - locations with the pickup list in the  subreport

3. I constructed the formula as advised:

@get_loc_desc

 

 

4. constructed another formula

@display_loc_desc

 

6. change subreport link - > same parameters as Main report

7. when running, the subreport does not display the locations I selected from location prompts, instead it displays the first, the second, etc., in the list of @display_loc_desc ( when I double checked in the subreport alone, if I de-suprress the detail section, and pull the code and head(location description) fields into the detail section - there are the same locations displaying when running the main report along with the subreport.

Any idea, something I missed out?

Thanks in advance.

 

John

 

 

I was origially thinking of using the lookup table, but found I could not directly use it; now I created a view based on that lookup table in the database, and pull the view into the subreport.

Yeh, it works as suggested :-) fantastic !

Thanks a lot!

 

John