Aaron, Since you're on version 9, I'm not sure if this command is support, but I think it should. Create a formula, and use something like this: join ({?Groups}, ", ") Replace {?Groups} with whatever you call your parameter. Regarding the subreport, check your selection criteria. You should be able to insert a subreport and link the parameter field to a field on your subreport to filter. When I don't see results that I expect in a report I simplify the selection criteria to as inclusive as possible and slowly add in qualifications until I've gotten it working as it should. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701
>>> aaron.cronin...@msd.govt.nz 06/30/09 7:12 PM >>> ** Hi Listers I have created a report which uses a parameter allowing multiple values.(HPD Assigned to Group) This parameter works fine in a cross tab but when I add it to the report as a field, it only shows the first value. Similarly, if I link a sub report to the parameter, it also only uses the first value. Any help appreciated. Crystal Reports 9 ARS 6.3 Oracle 10G ------------------------------- This email message and any attachment(s) is intended only for the person(s) or entity(entities) to whom it is addressed. The information it contains may be classified as IN CONFIDENCE and may be legally privileged. If you are not the intended recipient any use, disclosure or copying of the message or attachment(s) is strictly prohibited. If you have received this message in error please notify us immediately and destroy it and any attachment(s). Thank you. The Ministry of Social Development accepts no responsibility for changes made to this message or to any attachment(s) after transmission from the Ministry. ------------------------------- _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"