cancel
Showing results for 
Search instead for 
Did you mean: 

Join two arrays into single array

scott_selph
Participant
0 Kudos
302

Is it possible to join two arrays into a single array? I'm building two arrays from two different tables. The end goal after joining them is to perform a bubble sort to get them in order by date.

View Entire Topic
DellSC
Active Contributor
0 Kudos

Instead of using arrays in a report that's built by joining tables together in the Database expert, I would write a Command (SQL Select statement) using a UNION clause to get the data from both tables and sort is by date.

For more information about using commands, see https://blogs.sap.com/2015/04/01/best-practices-when-using-commands-with-crystal-reports/.

-Dell