Print Page | Close Window

Listing Multiple Values on One Line

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=325
Printed Date: 27 May 2024 at 3:38pm


Topic: Listing Multiple Values on One Line
Posted By: crnewbie
Subject: Listing Multiple Values on One Line
Date Posted: 14 Mar 2007 at 2:33pm
I'm trying to pull multiple values of one field into one line. I have a ticket from one table (table1) that could include multiple items on it from another table (table2). I would like to be able to list all items from table2 on one line with the corresponding ticket from table1.
 
Any help would be greatly appreciated.


-------------
thank you,

crnewbie


Replies:
Posted By: BrianBischof
Date Posted: 14 Mar 2007 at 2:43pm
Crystal Reports isn't designed to print multiple records on the same line. However, you could use a group footer and a formula to get this done. As the detail records print, have a formula that concatenates them together into a single string variable. Then display that string in the group footer and they will all appear on the same line.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: satcire
Date Posted: 15 Mar 2007 at 5:05am
Are the multiple value off the table 2 in one field or multiple field or multiple row ?
 
If they are in multiple field on one row it's not a problem.  Use a sub report or do a join in data expert between the 2 table
 
If they are on multiple row, you can use columnar report (see this link, it's for crystal report 9 but i'm prety sur that I will work with XI) http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_columnar_drill_down.pdf - http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_columnar_drill_down.pdf
 
If they are in ones field, the only thing I see is put them in a array.... but i'm not sur how.

Posted By: bobsn
Date Posted: 21 Mar 2007 at 1:10pm
were you able to find a solution... do let me know!

Posted By: crnewbie
Date Posted: 22 Mar 2007 at 8:06am
Yes. I had to create a subreport for the field I wanted coming on one line and use it to display the data in my report.

-------------
thank you,

crnewbie

Posted By: mhamidch
Date Posted: 27 Jun 2007 at 7:46am
Can you please reply bcuz i am having the same problem if you can tell me how you have done that.....

-------------
mhc


Print Page | Close Window