Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Help in combining two reports into one

Dear all,

I have created two reports for our end users, both reports are getting their information from different databases however the field names are same.

I have been asked if I can produce one report combining the two reports together. I took up a challenge however I did not realize that how am I going to run two reports in one when the date ranges for both are two different ones.

here is the setup of the reports. See if you can help me finding out a solution to this.

Report 1 - Database 1

Filtration - Order Status <> 0 and FOC ="Y"

Grouped by - Reason Code (From Lab Reasons under Database 1)

Date Range - Lab Orders Date Entered

Code Range - Reason Code

Total Count - Distinct count Order Number and Sum of Order lines qty

==========================================================

Report 2 - Database 2

Filtration - Lab Status = 2 and Line Num < 3 Line Type = "S"

Grouped by - Reason Code (From Lab Reasons under Database 2)

Date Range - Lab Credits Date Entered

Code Range - Reason Code

Total Count - Distinct count Oetrn2 Ordernum and Sum of Lab Credits Qty

Now this is how I started it, I created a report with Grouped by Reason code from Database 1 and then added tables from database 2. I left Report Section Record empty and used the date range within Total Count for each along with their filtration.

However when I ran the report it did not produce the right results. So I thought I might use Sub report to over come this issue however due to grouping the sub report did not fit into the right place. Then I used group 3 and tried it however that didn't work either.

Any ideas how to go about it?

Many thanks

Regards

Jehanzeb

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question