To combine two reports to see group total along the same line.

PB7

I have two reports.
   a) dw_1   group on a column "unit_code"
   b) dw_2   group on a column "unit_code"

I want to combine the two reports into one so that, I can see the group total along the same line.

Problem:

   Number of rows for particular unit_code in both reports may not be same. Therefore the unit_code total column will be shown up and down and not in the same horizontal line.

Is there any solution?
MateenAsked:
Who is Participating?
 
sandeep_patelConnect With a Mentor Commented:
Hi,

No, there is no direct way. Only solution is create single external datawindow having columns from both datawindows (dw_1 and dw_2) and then in background retrieve dw_1 and dw_2 using datastore and then copy records from datastores to new external datawindow.

Regards,
Sandeep
0
All Courses

From novice to tech pro — start learning today.