Skip to Content
0
Former Member
Sep 21, 2007 at 07:43 AM

Displaying in a main report one field's comma separated values in a subreport

156 Views

Post Author: shalbert

CA Forum: Formula

I have two database tables Fields and Memfields:

Fields Table

ID

LABEL

1

A

2

B

3

C

4

D

Memfields Table

ID

LABEL

1

B,D

2

C,A

3

A,D

4

A,B

So what I want to do is create a mainreport linking the sub-report by {fields.label} in the main report. So that the main report would look something like what's below. What does the parameter field formula need to look like on the main report to achieve this? I am using CRXI Release 2. Thanks!

A 2 C,A3 A,D4 A,B

B 1 B,D4 A,B

C 2 C,A

D 1 B,D3 A,D