Display of data on Crystal Report

[computerman29651]

Right now when the data/text is displayed on the crystal report is displaying like this:

Hey
There
Man

But, I would like for the data/text to display like this:

Hey, There, Man, etc....

Does anyone know a way to get the data/text to do what i want?

 

[lbass]

Add two formulas:

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

//{@display} to be placed in the report footer:
whileprintingrecords;
stringvar x;
left(x,len(x)-2)

-LB

 

[computerman29651]

The data that is displayed in the report footer is displayed how I want in the detailed section.

The data that is displayed in the detailed section is not displaying correctly. It is displaying like this:

Hey,
Hey, There,
Hey, There, Man,


Is there away to fix this?

 

[lbass]

The detail section is accumulating the results for later display which could be displayed at a group or report level. You would then suppress the detail section. Do you have a group where you want to see this result?

-LB

 

[computerman29651]

I would like for it to display under Group Header #1.

Is this what you were asking?

 

[lbass]

The result would have to be displayed in a group footer section, since it is a manual running total and the result wouldn't be available until then. You would suppress the group header and detail section. In the group header, you would place a reset formula:

whileprintingrecords;
stringvar x := "";

-LB

 

[computerman29651]

So, there is no way to get in the details section where everythig is duplicated on the next line?

 

[lbass]

What exactly do you hope to see? Please show a sample with multiple detail rows. If you have three rows, with different field results in each, are you hoping to see all results three times--once in each row? Hard to imagine why you would want to do this.

-LB

 

[computerman29651]

What I want to be able to do is have all the results (just once) in the detailed section without duplication.

If the results contained in the database for a certain field is the following:
Hey
There
Man
What
Are
You
Doing

I would like for the results to appear in the detailed section like: Hey, There, Man, What, Are, You, Doing.

As of right now with the formulas you provided, the detailed section is displaying the data like this:
Hey,
Hey, There,
Hey, There, Man, etc...

All my other fields are in the detailed section so I would like for this field toline up with all other fields.

Does this help?

 

[lbass]

Probably not possible unless your other fields only occur once per group. Please show sample data that shows all of your detail level fields.

-LB