merged Cells on export

building reports crystal reports
1

I have a detail report with one column that is a ‘Note’ or ‘Memo’ field that is entered into the DB with multiple rows.

I’m using Can Grow function on the object but when exported that is the only column that merges with the rows in excel. the other one line fields do not merge to match the Note column.

I have all fields in excel set to Can Grow.
I tried changing the width of the Note field but since the data is entered into the DB with multiple rows the data gets cut off unless the Can Grow Function is on.

How can I get this to export so all the data ends up in one row in excel???

:reallymad: :reallymad: :reallymad: :hb: :hb: :hb:

p_b_bradley :ireland: (BOB member since 2006-03-15)

2

I’m not sure I understand the data. Are you saying that if record 1 has a note that the data is broken up into multiple rows for record 1?

This is someone else’s answer, I’ve used it and it works. You have to have a group for the main record that the note is associated to.

How do you get a list of detail strings to print on one line? So that a list of detail items like:

ItemA
ItemB
ItemC

prints out as one line like:

ItemA, ItemB, ItemC

The solutions requires three formulas, and assumes that the items are within an existing group on the report:

  1. In the Group Header place the @reset formula:

    WhilePrintingRecords;
    StringVar chain := ‘’;
    NumberVar ChCnt := 1

  2. On the Details place the @Accum formula, putting your field into the second line:

    WhilePrintingRecords;
    StringVar Item:= {Your.Field}; // place your field in place of {Your.Field}
    StringVar Chain;
    NumberVar ChCnt;

    if ChCnt = 1
    then (ChCnt:= 2; chain := Item)
    else
    if Length(Chain) + Length(Item) > 64000 //see note about this number below
    then Chain := Chain else
    chain := chain + ', ’ + Item

  3. On the Group Footer place the @Display formula:

    WhilePrintingRecords;
    StringVar Chain

MizarKey (BOB member since 2009-12-16)

3

Turn off Can Grow to get the data all in one cell in Excel.

-Dell

hilfy :us: (BOB member since 2007-04-16)