Print Page | Close Window

[Solved]Combine multiple results into 1 field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2016
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22836
Printed Date: 03 Aug 2020 at 7:36am


Topic: [Solved]Combine multiple results into 1 field
Posted By: Adventux
Subject: [Solved]Combine multiple results into 1 field
Date Posted: 15 Nov 2019 at 7:43am
This is in Crystal Reports xi

I have a report where I am getting 3 results for 1 field for each APP ID. I have a filed Tracking ID Which i need 3 results. I would like these to be on same line in report.

App Id   other fields Tracking Id Tracking descrptn
1            ghgf          12           first
1            ghgf          22           second
1            ghgf        137           third

Result I would like is

App Id   other fields Tracking Id Tracking descrptn
1            ghgf        12           first
                           22           second
                           137          third

13          ghgf        12           first
                           22           second
                           137          third

...

I.e. The last 2 columns as 1 "Field" in one line of the report.   

How would I do this.



Replies:
Posted By: kevlray
Date Posted: 15 Nov 2019 at 12:38pm
Group by App ID, I believe you should be able to Underlay Following Sections in the Group Header.  If you actually want to combine columns into one column, you would do that in a formula
Something like this. totext({tracking_id},0)+' '+{tracking descrptn}


Posted By: Adventux
Date Posted: 19 Nov 2019 at 8:49am
i did it with a subreport. remove 2 tables from main and put them in subreport to pull tracking items. Group by and Link by Application ID. works perfectly.



Print Page | Close Window