merge results into single cell to get one line of data

[Former Member]

Hi,

I am looking to merge several output results <property 1> which have the same common reference numbers <Ref nun> into one cell in order to get one line of data per reference number. The results below are from two data providers and positioned together in the report using sections. The merged dimensions and sections are the Ref number. The Ref num and date are block 1 and the property is block 2.

At the moment I get the following results in three columns:

Ref num....date..........property.....

10.............01/01/09...Laptop.......

..................................Fridge........

..................................Freezer......

11.............02/01/09...Cooker......

12.............02/01/09...Mac...........

..................................Laptop.......

These are the results I want, still in three columns so the property output for each ref number is merged in one cell.

Ref num.....date.........property

10.............01/01/09....Laptop, Fridge, Freezer

11.............02/01/09....Cooker

12..............02/01/09...Mac, Laptop

Is this possible?

Many thanks

[Former Member · Accepted solution]

Yes. Group by RefNum and Date. Create a formula field in the Detail section that uses a global variable to "collect" the Properties (basic syntax):

global props as string
if props = "" then
  props = {Property}
else
  props = props + ", " + {Property}
end if
formula = ""

Put another formula field in the Date group footer that just returns this global variable for display. Create yet another formula field for the Date group header that sets the global variable to "".

(All printing is done in the Date group footer, not detail section.)

HTH,

Carl