Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: [Solved]Combine multiple results into 1 field Post Reply Post New Topic
Author Message
Adventux
Newbie
Newbie


Joined: 28 Nov 2018
Online Status: Offline
Posts: 2
Quote Adventux Replybullet Topic: [Solved]Combine multiple results into 1 field
    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.

Edited by Adventux - 19 Nov 2019 at 8:50am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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}
IP IP Logged
Adventux
Newbie
Newbie


Joined: 28 Nov 2018
Online Status: Offline
Posts: 2
Quote Adventux Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.018 seconds.