Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing a field in details section horizontally, with concantenation 2

Status
Not open for further replies.

Cairmor

Technical User
Sep 14, 2007
5
US
I am wondering if there is a way to force Crystal to print its details section horizontally similar to the output of a Join(array,", ") function.

Normal Output would look like this. The report would have a simple group stucture with a groupname in the groupheader 1, and one field called {fname} in the detail section.

GROUPNAME1
John
Pete
George
Ringo
Paul
GROUPNAME2
Michael
Mark
Terry
Neman

*end

What I want is this:

GROUPNAME1
John, Pete, George, Ringo, Paul
GROUPNAME2
Michael, Mark, Terry, Neman

*end

Is it possible to somehow load the {fname} field into an array and use the Join function to print it "horizontally" with punctuation?

I am not interested in getting this output to print over columns, or with a creative use of cross-tabbing.


 
Aside from using the 3 formula method, you can use the whilereadingrecords level to do some slick stuff, check out my FAQ:

faq767-6528

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top