Joined: 28 Nov 2018
Online Status: Offline
Posts: 2
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.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
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}
Joined: 28 Nov 2018
Online Status: Offline
Posts: 2
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.
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
IP Logged
