Sorting a field by combining main and subreport

[crystaldev1]

Hello,

I've created a report using CR 2016. I am using 2 stored procedures with the following fields:
SP1: Date1 Activity Comments
SP2: Date2 Inspection Comments

In the main report, I am using SP1 and displaying the fields from above.
In the subreport (located in Report Footer of the main), I am using SP2 and displaying the fields from above.

I would like to know if there's a way to somehow sort based on Date1 and Date2.
Example:
1/1/2019 (Date1) Activity1 Comments1
2/5/2019 (Date2) Inspection1 Comments1
3/1/2019 (Date1) Activity5 Comments5
3/5/2019 (Date1) Activity7 Comments7
4/9/2019 (Date2) Insepction8 Comments8

Currently, the main report is sorted separately as well as the subreport.

Thanks.

 

[crystaldev1]

Any comments? Anyone?

 

[lbass]

If you were working directly with the tables comprising the stored procedure, the answer would be to use a command with a union all statement in order to merge the corresponding fields in each set of tables, thus allowing a sort on date.

You might be able to do this with stored procedures, but I cannot test this. There is a potentially helpful post in SAP archives, entitled: “Merging Data from two stored procedure in a single CRYSTAL REPORT” (sic). See if you can make this work within the Crystal command.

-LB

 

[hilfy]

If you would like more information about how to work with commands, see this blog post:

https://blogs.sap.com/2015/04/01/best-practices-when-using-commands-with-crystal-reports/

-Dell

Senior Manager, Data & Analytics
Protiviti

http://www.protiviti.com