If you're a total newbie, you probably need to read my free online chapters to get the full details of how to do some of these tricks in CR.

To concatenate data, create a string variable and use the & to join multiple fields together. Create a new formula and put code similar to the following in it (change the table and fields for your purposes).

StringVar AllRules;
AllRules := {table.Rule1} & ", " & {table.Rule2} & ", " & {table.Rule3};

Edited by BrianBischof - 19 Jun 2007 at 8:26pm

I was worried you might come back and say that. Well, at least you understood well enough to get it implemented correctly!

The next step is to use a subreport with a global variable. Let the subreport do the looping through the records and behind the scenes build the string variable. Since it is global you can then use it on the main report. The problem is going to be with the subreport screwing up the formatting of the main report. Try suppressing the sections of the subreport (this might not work, I'm not certain). Another option is to make the text of the subreport white so that it isn't visible and on the main report use Overlay section so that the subreport doesn't take up much space.

Those are some ideas for you.