Sorting a field by combining main and subreport

crystaldev1 · Feb 28, 2019

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 · Mar 1, 2019

Any comments? Anyone? [ponder]

lbass · Mar 2, 2019

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 · Mar 6, 2019

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Sorting a field by combining main and subreport

crystaldev1

Programmer

crystaldev1

Programmer

lbass

Technical User

hilfy

Active member

Similar threads

Part and Inventory Search

Sponsor