retruning data in a row instead of a column

[martink1]

I'm adding UPS/ FedEx tracking numers to orders as a subreport. My tracking numbers come back vertically in a column. how can i get them to populate horizontaly in a row?

 

[Charliy]

Here's one way you can do this:
you'll need three formulas

In the report header (which is suppressed) place formula {@init}
shared stringvar trnums := ' '

In the detail section (which is suppressed) place formula {@bump}
shared stringvar trnums;
trnums := trnums +{table.trackingnumber}&" "

In the group footer A place formula {@sho track}
shared stringvar trnums

In group footer B (suppressed) place another copy of {@init} (this may not be necessary if you're calling the subreport once per group, but it won't hurt)

 

[Madawc]

Another method is a suitable crosstab.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[martink1]

Thanks Charliy, that worked. What exactly did you have me do? I'm not an advanced Crystal user.
Now I just need to get my tracking numbers to be clickable again.

 

[Charliy]

I had you build a string in a shared variable, then display it.