I am creating a Crystal Report which selects item A as a parameter in the main report from table X. A subreport then displays sub-items B and C from table Y (there may be 2 or 3 of these sub-items). I then want to display in a second sub-report all activity from table Z for all items and sub-items A, B, and C.

I felt one way of achieving this was having a selection formula in the second subreport of {Table Z} in ["A", "B", "C"]. This works if I hard-code the values. However, when I use a formula in the first subreport to read all the records with the following code:

stringVar subs;
WhileReadingRecords;
subs:=subs + "," + ({TableY, Column B});
subs

Firstly it returns ,B,C (note the preceding comma) but also I cannot do any string manipulation with it (e.g. Join with parameter A from the main report) because 'A string array is expected here'. So it seems I have no way of creating my required string of ["A", "B", "C"] because WhileReadingRecords always returns an array. Is there another way of putting the contents of the first subreport into a string?

Unfortunately the data structures won't allow that. I did try that first but it will only pull the records for A, not B/C from table Z.

Thanks for your suggestion.

Yes but when I try to do that Crystal complains 'A string array is expected here' because WhileReadingRecords always returns an array.