Multiple Values Parameter - Displaying the Linked Descriptions in RH

[crogers111]

CR XI
SQL

I have a mutiple value parameter that I need to display the descriptions that are linked to the values entered by the user.

e.g.

User enters the following for ?Group#

6001
6002
6003

The record selection is as follows:

{TableA.Group#} = {?Group#} <---- Both are Number Data Type

I found the FAQ that shows me how to display all of the parameter values entered by the user in the RH:

http://www.tek-tips.com/faqs.cfm?fid=5684

What I need is to figure out how to Display the Descrptions for these values that are linked and stored in a different table, TableB


Table A:

Group# Amount
6001 5000
6002 2000
6003 2500

Table B:

Group# Desc
6001 ABC Company
6002 XYZ Company
6003 EZ1 Company


Here is a sample of what I am looking for in the RH:

RH: ABC Company, XYZ Company, EZ1 Company

I'm trying to avoid using a subreport to accomplish this, but will if it's the only way.

Thanks.

 

[lbass]

How many values can there be? And do they change over time? You could hard code these into an if/then within the formulas shown in the faq if there aren't too many and they are static. Otherwise, the subreport is the best approach--and it shouldn't take much processing time.

-LB