Printing Multiple Data Lines on One Line

[versozc]

I want to use Crystal Reports to create a flat file. The detail is shown below. What I want to do is print unique acct#'s on a single line and each DX_cd associated to the acct# should be on the same line. The line#'s show that for each acct#, the number of DX_cd's can vary. I tried to do this by creating a group on acct# and formulas in the detail and group footer sections. The detail section formula is:

whileprintingrecords;
stringvar dx1_det;

if ({HSP_ACCT_DX_LIST.LINE}) = 1 and
not isnull({CLARITY_EDG.REF_BILL_CODE}) then
dx1_det := {CLARITY_EDG.REF_BILL_CODE}


The group section formula is:

whileprintingrecords;
stringvar dx1_det;


Acct# DX_cd Line#
619 724.00 1
664 719.46 1
829 645.11 1
829 V23.7 2
829 663.31 3
829 664.11 4
829 659.71 5
829 V27.0 6
832 643.93 1
832 663.31 2
832 664.11 3
832 659.71 4
832 V27.0 5
833 303.02 1
833 305.62 2
833 780.39 3
833 401.9 4
835 303.02 1
840 172.5 1
841 724.9 1
842 209.24 1
844 719.46 1
846 300.9 1

I would like the output to look like this:
619 724.00
664 719.46
829 645.11 V23.7 663.31 664.11 659.71 v27.0
832 643.93 633.31 664.11 659.71 v27.0
833 303.02 305.62 780.39 401.9
835 303.02
840 172.5
841 724.9
842 209.24
844 719.46
846 300.9

My results appear to show carryover or
619 724.00
664 719.46
829 645.11 V23.7 663.31 664.11 659.71 v27.0
832 643.93 633.31 664.11 659.71 v27.0 v27.0
833 303.02 305.62 780.39 401.9 v27.0 v27.0
835 303.02 305.62 780.39 401.9 v27.0 v27.0
840 172.5 305.62 780.39 401.9 v27.0 v27.0
841 724.9 305.62 780.39 401.9 v27.0 v27.0
842 209.24 305.62 780.39 401.9 v27.0 v27.0
844 719.46 305.62 780.39 401.9 v27.0 v27.0
846 300.9 305.62 780.39 401.9 v27.0 v27.0

It appears that my variables are not getting initialized. Any suggestions greatly appreciated.
Thank you,
versozc

 

[lbass]

Grouping on acct#. Then create these formulas and place them as noted:

/{@reset} to be placed in the group header:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar x := x + {table.dx_cd}+" ";

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar x;
trim(x)

Suppress the group header and details section.

I'm not sure what the relevance of the field {CLARITY_EDG.REF_BILL_CODE}, but if you only want records where that is not null, then add that to the selection formula.

-LB