List the results of an sql statement in a field

[glschill]

OK, let me see if I can explain what I'm trying to accomplish. ...

I am passing a list of group id's in asp to my crystal report. So let's say I pass the following id's: "299,123,356"

My crystal report will generate a report using the id's. No problem. "Select * From table1 Where groupid in (299,123,356)"

Now, what I need to do is get the descriptive group names from a separate "group" table, and place them in a field so I can show what the user selected in the report header. example:

Speficied Group Criteria: Group1Name, Group2Name, Group3Name

Being a beginner, I would appreciate any assistance I can get on how to accomplish this task

Thanks in advance,
Gary