Horizontal Display?? 1

[Santos]

Hi everyone,

Does anyone know the formula for displaying a field with multiple rows...on just ONE row? Hope this makes sense:

Example:

Jones1
Jones2
Jones3

----> Jones1, Jones2, Jones3

I saw this formula a while back, but since the keyword search is down, I can't find it. Can anyone help?

Thanks...dan

 

[FoxG]

Hi Dan,

what is you email?

I have a sample CR7 report which does this.

Geoff

 

[kenhamady]

You have to use a variables style running total, except the running total uses a string Var instead of a numberVar.

See the FAQ on running totals and the 3-formula technique is close. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Santos]

Hi Geoff,

Email: daniel_santos@avid.com

Thanks!

 

[FoxG]

Email sent to Dan,

Hope this helps

Geoff

 

[Santos]

Thanks everyone...I fixed it!

- dan

 

[dfern246]

Geoff,

I have similar problem. The report will look like this:

Jones1 36 Jones4 35 Jones7 41
Jones2 40 Jones5 32 Jones8 42
Jones3 30 Jones6 31 Jones9 34

Does your sample report is similar to this report?

Thanks,

Dan

 

[hgg21]

hi FoxG and Santos,

I encountered this problem too.
Can i have the formula too?

Thanks!
Jerry

 

[anjanaj]

Hi Geoff,

Can u please send the same report to me too ... even I have to display a few records in the same row ... Please help !

Thanx
Anjana

 

[kenhamady]

This formula is now part of faq149-243 . Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com